Setting variables in the Amazon RDS for Oracle database
You set the ORACLE_HOME, ORACLE_SID, and java CLASSPATH: ORACLE_HOME variables before you begin the upgrade process. If you do not set these variables, you cannot complete the migration process during the Enforce Server upgrade process.
- Log on as a domain user.
- In the command prompt, run the following command to set the ORACLE_HOME variable. Confirm your Oracle version and installation path before setting this variable. For example:set ORACLE_HOME=c:\oracle\product\19.3.0.0\db_1
- Run the following command to set the java CLASSPATH: ORACLE_HOME variable:
- For Windows:set CLASSPATH=%CLASSPATH%;JAVA_HOME\lib;.;echo %CLASSPATH%
- For Linux:export CLASSPATH=${CLASSPATH}:.echo $CLASSPATH