Unable To Modify Database Password With modifyPassword.sh After Ixp Upgrade

Solution Type Problem Resolution Sure

Solution 2227599.1 : Unable To Modify Database Password With modifyPassword.sh After Ixp Upgrade

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.1.5 and later
Information in this document applies to any platform.

When executing the modifyPassword.sh script on NSP and error is returned even if the credential used are correct:

-ERROR: Password or service name incorrect for sys user. Nothing changed.ease try again.

The IXP subsystem has just been upgraded to PIC 10.2.

The script is failing to change the IXP user password because the access to the DWS oracle database as sysdba is rejected.

A test to connect to the IXP DWS database from the NSP is generating the following error:

ORA-01017 invalid username/password; logon denied.

However a connection from the DWS server as sysdba works fine.

In order to fix the issue the SYS user account on the DWS server must be reset, here is the procedure:

Login as oracle user on the DWS
Log onto sqlplus:

sqlplus / as sysdba
Reset sys user password (where xxxxx is the sys password):

alter user SYS identified by xxxxx;
Unlock sys account:

alter user SYS account unlock;
Exit sqlplus and run again the modifyPassword script on the NSP.

Attachments

This solution has no attachment