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!
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!
Comments
Post a Comment