PreviousNextJavaScript must be enabled to correctly display this content
Reset the OCSREMDW User Password
The password for the Oracle Communications OCSREMDW User
who connects to the Oracle Communications Session Delivery Manager Data
Warehouse (ocsdmdw) database expires every 180 days. Use this task to reset the
expired password with a new password.
Shutdown SDM as the
nncentral user.
cd /opt/AcmePacket/NNC75/bin
./shutdownnnc.sh
Run setup.sh as
root.
Select
Custom and
Oracle DB
OCSDMDW Configuration.
Enter and then
confirm the OCSDMDW password.
Enter the
ORACLE_HOME path.
The error message should say "OCSDMDW Oracle
DB already exists. Please drop this DB and try again."
Exit setup.sh.
Set the ORACLE_HOME
and ORACLE_SID variables as the nncentral user.
su nncentral
export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=ocsdmdw
Log in to the
Oracle database.
cd $ORACLE_HOME/bin
./sqlplus / as sysdba
If the database
user accounts are locked because of multiple failed logins with the wrong
password, unlock the nncentral and oscremdw accounts.
alter user nncentral account unlock;
alter user ocsremdw account unlock;
Change passwords
for the nncentral user and the ocsremdw user. The new ocsdmdw password must be
the same as the one specified in step 4.
alter user nncentral identified by <new_password>;
alter user ocsremdw identified by <new_password>;
Exit
exit;
Confirm the
password changes by looking for a successful log in to the following commands: