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 section for more information.
  7. Stop the BI Publisher database instance listener (LISTENER).
    [oracle@vm bin]$ ./lsnrctl stop
  8. Manage the WebLogic Server
  9. Stop the OCSDMDW database instance listener (LISTENER2):
    [oracle@vm bin]$ ./lsnrctl stop LISTENER2
  10. 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/19.3.0/dbhome_1
  11. Specify the ORACLE_SID variable for the AcmeBIPublisher database.
    export ORACLE_SID=AcmeBIPublis
  12. Execute the ORACLE_HOME/bin/sqlplus script.
    [oracle@vm bin]$ ./sqlplus '/ as sysdba'
    
  13. Use the following option to shutdown the Oracle database instance and exit:
    SQL> shutdown immediate;
    SQL> exit
  14. Specify the ORACLE_SID variable for the Report Manager database instance (OCSDMDW).
    export ORACLE_SID=ocsdmdw
  15. Execute the ORACLE_HOME/bin/sqlplus script.
    [oracle@vm bin]$ ./sqlplus '/ as sysdba'
    
  16. Use the following option to shutdown the Oracle database instance and exit:
    SQL> shutdown immediate;
    SQL> exit