on 02-17-2014 4:36 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.