Reset the Password for the Oracle Database User

Login to the server on which SDM is installed with the nncentral user.

ssh -Y nncentral@<OCSDM-Linux-server>

Change directory to the SDM bin directory.

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

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 shut down the entire cluster if no flag options are provided.

Note:

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

Go to the Oracle database bin home directory.

cd $ORACLE_HOME/bin

Specify the Oracle SID to ocsdmdw.

export ORACLE_SID=ocsdmdw

Connect to the Oracle database as the Oracle system administrator (sysdba).

./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 29 10:29:14 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL>

Check the OCSREMDW user status.

SQL> select username, account_status from dba_users where username = 'OCSREMDW';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
OCSREMDW                       LOCKED

If the status is in the LOCKED status (the status before the password expires) then you must unlock the OCSREMDW user account before you reset the password. If there is a different status, such as OPEN, EXPIRED and LOCKED, or EXPIRED, skip this step and proceed to step 9.

SQL> alter user ocsremdw account unlock;

User altered.

Reset the OCSREMDW password by entering the original password that was specified during original database installation.

SQL> alter user ocsremdw identified by <original password>;

User altered.

Logout as the Oracle system administrator (sysdba).

SQL> exit;
Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

Connect to OCSDMDW database as the OCSREMDW user to ensure that the database is operational.

./sqlplus ocsremdw/<password>@ocsdmdw

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 29 10:43:17 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL>

Logout as the OCSREMDW user.

SQL> exit;
Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

Change to the SDM server bin directory.

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

Start the SDM server.

./startnnc.sh

Check the Reporting Service log to make sure that it was started successfully.

cd <OCSDM-INSTALL_DIRECTORY>/logs
grep "service started" ReportingService.log
2016-02-09 16:44:37,988 INFO [com.acmepacket.ems.server.services.ReportingService] - Method: [startService]
Thread: [ReportingService:25]  Msg:[...service started]

If you are running an SDM server cluster, repeat the previous steps for each cluster member node.