You must verify that the Report Manager database instance
(OCSDMDW) is created.
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
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.
Check the logs
directory to discover why a failure happened (if a failure has happened).
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.