Specify Oracle Database Software Variables

Use the following steps to specify the variable for the oracle database (ORACLE_HOME), and the system identifier (SID) variable that identifies the BI Publisher database.

1. Append the following lines to /home/oracle/.bash_profile.

   export ORACLE_HOME=/home/oracle/app/oracle/product/19.3.0/dbhome_1
   export ORACLE_SID=AcmeBIPublis

   Note:

   Make sure the ORACLE_HOME path has no trailing slash.
2. Switch to the nncentral user.

   su - nncentral

3. Append the following line to /home/nncentral/.bash_profile.

   export ORACLE_HOME=/home/oracle/app/oracle/product/19.3.0/dbhome_1

   Note:

   The ORACLE_HOME variable must be set when restarting either the listener or Oracle Communications Session Delivery Manager.
4. Start a new bash shell as the "oracle" Linux user. For example:

   ssh -Y oracle@<my_oracle_server>