Shutdown Report Manager

1. On the SDM server, log in as the nncentral user.
2. Change the directory to the bin directory.
   For example:

   cd /home/nncentral/AcmePacket/NNC<version>/bin

3. Execute the shutdownnnc.sh script. By default, the shutdownnnc.sh script detects whether the existing installation is a standalone or clustered system and prompts you with the option to shutdown the entire cluster if no flag options are provided.

   Note:

   However, you can script an option ahead of time by adding -local for single nodes and - cluster to shutdown an entire cluster.

   ./shutdownnnc.sh
   Shutdown back-end server
   Do you wish to shut down the entire cluster (Yes/No)? Yes

4. On the server where the Oracle database software and BI Publisher are installed, login as the Oracle user.
5. Change to the WebLogic server directory. For example:

   [oracle@vm ~]$ cd /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/bin

6. Stop the WebLogic server. Go to the Manage the WebLogic Server section for more information.
7. Stop the BI Publisher database instance listener (LISTENER).

   [oracle@vm bin]$ ./lsnrctl stop

8. Stop the OCSDMDW database instance listener (LISTENER2):

   [oracle@vm bin]$ ./lsnrctl stop LISTENER2

9. If undefined, set the ORACLE_HOME variable in the .bash_profile of both the oracle user and the nncentral user.

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

10. Specify the ORACLE_SID variable for the AcmeBIPublisher database.

    export ORACLE_SID=AcmeBIPublis

11. Execute the ORACLE_HOME/bin/sqlplus script.

    [oracle@vm bin]$ ./sqlplus '/ as sysdba'
    

12. Use the following option to shutdown the Oracle database instance and exit:

    SQL> shutdown immediate;
    SQL> exit

13. Specify the ORACLE_SID variable for the Report Manager database instance (OCSDMDW).

    export ORACLE_SID=ocsdmdw

14. Execute the ORACLE_HOME/bin/sqlplus script.

    [oracle@vm bin]$ ./sqlplus '/ as sysdba'
    

15. Use the following option to shutdown the Oracle database instance and exit:

    SQL> shutdown immediate;
    SQL> exit