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!
Exploring the intersection of technology and management, I share insights on databases, middleware, applications, and IT strategy to help professionals navigate complex systems with clarity and efficiency.