Preparing the Staging Database

After the staging owner (STGADM), application user (STGUSER) and read access user (STGREAD) are created, install the initial database option in the staging schema. The rest of the steps are listed below.

To run the utility:

1. Set JAVA_HOME, PATH, and CLASSPATH.

For ADB, make sure the database connection is working. For more information, see step 1.b.a.c in the section and export/SET TNS_ADMIN=<wallet location>.

Linux/UNIX:

export JAVA_HOME=/scratch/software/jdk1.8.0_291/

export PATH=$JAVA_HOME/bin:$PATH

export CLASSPATH=/../FW-V4.5.0.1.1-Oracle-Database- Multiplatform/FW/jarfiles/*

Windows:

SET JAVA_HOME=C:\Program Files\Java\jdk1.8.0_291

SET PATH=%JAVA_HOME%\bin:%PATH%

SET CLASSPATH= C:\FW-V4.5.0.1.1-Oracle-Database- Multiplatform\FW\jarfiles\*

2. Run Conversion from any directory making sure Step 1 is complete. Run the command as necessary.

Note: Execute the following command as ADMIN for ADB:

grant dwrole to STGADM;

grant dwrole to STGUSER;

grant create any view to STGUSER;