SUM ERROR: Password for 'SYSTEM' does not work, please reenter.

[jorge_velasquez]

Hi,

I am updating Solman with SUM and error occurred.

ERROR: Password for 'SYSTEM' does not work, please reenter

I changed password with sqlplus

SQL> ALTER USER SYSTEM IDENTIFIED BY “password”;

User altered.

No luck

SQL> connect system

Enter password:

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE

Solman is UP and running perfectly also listener.

System user is not locked

SQL> SELECT username,

  2         account_status

  3    FROM dba_users;

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------

SYSTEM                         OPEN

SYS                            OPEN

OPS$SAPSERVICESMP              OPEN

OPS$ORASMP                     OPEN

OPS$SMPADM                     OPEN

SAPSR3                         OPEN

SAPSR3DB                       OPEN

OUTLN                          LOCKED

DIP                            EXPIRED & LOCKED

ORACLE_OCM                     EXPIRED & LOCKED

DBSNMP                         EXPIRED & LOCKED

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------

APPQOSSYS                      EXPIRED & LOCKED

OS AIX 6.1 on Oracle 11g

Any clue?

[sunny_pahuja2 · Accepted solution]

Hello,

Please make sure that you should not use special character like '@' in password. Please refer to SAP note 1534597 for more information.

Thanks,

Sunny

[former_member188883]

Hi Jorge,

The ORA-12154 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases.

Make sure that your listener is listening for the same service name that you are using.

Your service name might have an alias, so check for global (world) entries and local entries.  Check:

$ORACLE_HOME/network/admin/tnsnames.ora

Check your global_name setting with this SQL:

select * from global_name;

Hope this helps.

Regards,

Deepak Kori

[former_member182657]

Hi,

Are you giving any quotes on the new password.It should be

alter user system identified by NewPasswordHere;

Change the password to whatever you want it to be. Note also that it doesn’t need to be in single quotes, as you might expect.Then try again to logon to system as SQL> sqlplus /nolog

SQL> conn system

Regards,

[former_member182657]

Hi,

You can also try to reset password of system user with BRTOOLS or by command

brconnect -f chpass -o [sapr3 | sap<sid> | sap<xyz> | sapsr3] -p <new_password>

Refer SAP note   562863 - FAQ: Logon mechanisms

Regards,

Gaurav