Sunday, November 3, 2013

Can't login as SYS user from SQL Developer - Oracle 11g

Problem:

Couldn't login as SYS user to Oracle 11g Database through SQL Developer.
But I could log in through SQLPLUS with the same username & password.
Tried several times through SQL developer(By selecting right options) but only SYS user seems to have this problem.

Solution:

1.Login the remote server and login as sys/123 as sysdba.(Or whatever your password)
2.Reset the password ( alter user sys identified by 123;)(With your prefered password)
3.Relogin the oracle as sys.

Now I could log in to the SQL developer through SYS user successfully.I know it's strange..but it worked!

No comments:

Post a Comment