| Cannot connect to database [message #436913] |
Tue, 29 December 2009 08:26  |
zahidbashir
Messages: 34
Registered: September 2009
|
Member |
|
|
Hi,
When i launch the OEM standalone, I can connect to the database as sys user by the providing the database connect information(user/password).
When i login to the Oracle Management Server and try to connect to the same database as sys providing the same database connect information (user/password, it says invalid username/password 
Please help
Regards,
|
|
|
|
|
|
| Re: Cannot connect to database [message #436918 is a reply to message #436913] |
Tue, 29 December 2009 09:09  |
zahidbashir
Messages: 34
Registered: September 2009
|
Member |
|
|
Is it possible that same database have different passwords for same user when i access them via standalone and oracle managed server?
Although i usually give same password to sys users as it is test environment. Still i want to know how to change the passwords. I tried changing it through preferences but still cant login.
[Updated on: Tue, 29 December 2009 09:13] Report message to a moderator |
|
|
|
| Re: Cannot connect to database [message #436921 is a reply to message #436913] |
Tue, 29 December 2009 09:49 |
zahidbashir
Messages: 34
Registered: September 2009
|
Member |
|
|
Okay i just did this
$ sqlplus /nolog
SQL> CONN SYS AS SYSDBA
Enter password: ***
Connected.
SQL> SHO USER
USER is "SYS"
SQL> ALTER USER sys IDENTIFIED BY [i]password[/i];
Just changed the password for the sys user and now i can login.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
