6 Verify the Report Manager Database Instance

You must verify that the Report Manager database instance (OCSDMDW) is created.

1. From your Linux system, query the Oracle database to verify if the OCSDMDW database is active:

   ssh -Y oracle @vm
   export ORACLE_SID=ocsdmdw
   cd $ORACLE_HOME/bin

2. Enter the path to the OCSDMDW database:

   ./sqlplus ocsremdw/<ocsremdw password>@ocsdmdw

   If a success message appears, it indicates that the OCSDMDW database is active and installed correctly. If a failure message appears, either the database is not installed or not configured. Continue to step three if you get a failure message.
3. Check the logs directory to discover why a failure happened (if a failure has happened).

   /home/nncentral/AcmePacket/NNC<version>/logs/SetupApplication.log

4. Look for any error messages in the setup application log. We suggest filtering your search with the words LISTENER2 and OCSDMDW. If you are unable to determine what is wrong, contact your Oracle Communications support representative.