Shutdown Report Manager

  1. 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:
    [oracle@vm ~]$ cd /app/OracleMiddleWare/user_projects/domains/bifoundation_domain/bin/
  6. Stop the WebLogic server by running the stopWebLogic.sh script.
     [oracle@vm bin]$ ./stopWebLogic.sh
  7. Stop the BI Publisher database instance listener (LISTENER).
    ./lsnrctl stop
  8. Stop the OCSDMDW database instance listener (LISTENER2):
    ./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=/app/oracle/product/11.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