Linux/UNIX:
If '-a' (apply on staging flag) is passed, it connects to the database as staging schema admin and performs the conversion setup, in addition to creation of the above files, by running the same SQLs present in the create* SQL files.
java com.oracle.ouaf.oem.conversion.ConversionSetup -d ${JDBC_CONN_STRING} -p ${CIS_ADMIN_USR},${CIS_ADMIN_PSWD} -a -s ${STG_ADMIN_USR},${STG_ADMIN_PSWD},${STG_RW_USER}
If '-r' (revert staging flag) is passed, it connects to the database as staging schema admin and reverts the staging to a state prior to conversion setup, running the same SQLs present in drop_* or restore_* SQL files.
java com.oracle.ouaf.oem.conversion.ConversionSetup -d ${JDBC_CONN_STRING} -p ${CIS_ADMIN_USR},${CIS_ADMIN_PSWD} -r -s ${STG_ADMIN_USR},${STG_ADMIN_PSWD},${STG_RW_USER}
To generate ONLY the scripts, the program should be invoked with '-s' parameter with no other flags (no '-a' or '-r' ):
java com.oracle.ouaf.oem.conversion.ConversionSetup -d ${JDBC_CONN_STRING} -p ${CIS_ADMIN_USR},${CIS_ADMIN_PSWD} -s ${STG_ADMIN_USR},${STG_ADMIN_PSWD},${STG_RW_USER}
Windows:
If '-a' (apply on staging flag) is passed, it connects to the database as staging schema admin and performs the conversion setup, in addition to creation of the above files, by running the same SQLs present in the create* SQL files.
"%JAVA_HOME%"\bin\java com.oracle.ouaf.oem.conversion.ConversionSetup -d %{JDBC_CONN_STRING}% -p %{CIS_ADMIN_USR}%,%{CIS_ADMIN_PSWD}% -a -s %{STG_ADMIN_USR}%,%{STG_ADMIN_PSWD}%,%{STG_RW_USER}%
If '-r' (revert staging flag) is passed, it connects to the database as staging schema admin and reverts the staging to a state prior to conversion setup, running the same SQLs present in drop_* or restore_* SQL files.
"%JAVA_HOME%"\bin\java com.oracle.ouaf.oem.conversion.ConversionSetup -d %{JDBC_CONN_STRING}% -p %{CIS_ADMIN_USR}%,%{CIS_ADMIN_PSWD}% -r -s %{STG_ADMIN_USR}%,%{STG_ADMIN_PSWD}%,%{STG_RW_USER}%
To generate ONLY the scripts, the program should be invoked with '-s' parameter with no other flags (no '-a' or '-r' ):
"%JAVA_HOME%"\bin\java com.oracle.ouaf.oem.conversion.ConversionSetup -d %{JDBC_CONN_STRING}% -p %{CIS_ADMIN_USR}%,%{CIS_ADMIN_PSWD}% -s %{STG_ADMIN_USR}%,%{STG_ADMIN_PSWD}%,%{STG_RW_USER}%
It creates the following files in current directory (or output directory if passed as '-o') if '-r' (revert staging flag) is not passed.
After the staging schema has been set up, generate the security for the staging user following the steps in the Configuring Security section.
Linux/UNIX:
java -Xmx1500M com.oracle.ouaf.oem.install.OraGenSec-d
<STAGING_DBUSER>,< STAGING_DBPASS>, jdbc:oracle:thin:@<DB_SERVER>:<PORT>/
<SID> -u <STAGING_RW_USER> -r <STAGING_RW_USER_ROLE>,< STAGING_R_USER_ROLE> -a A -p
<RW_USERPASS>
Windows:
"%JAVA_HOME%"\bin\java -Xmx1500M com.oracle.ouaf.oem.install.OraGenSec -d < STAGING_DBUSER>,< STAGING DBPASS>, jdbc:oracle:thin:@<DB_SERVER>:<PORT>/
<SID> -u < STAGING RW_USER> -r <STAGING RW_USER_ROLE>,<STAGING R_USER_ROLE> -a A -p
<STAGING_RW_USERPASS>