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.
  1. Log on as a domain user.
  2. 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
  3. 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