After setting REMOTE_LOGIN_PASSWORDFILE=NONE can't login to SYS as SYSDBA
Posted on 2010-08-28
ran: ALTER SYSTEM SET remote_login_passwordfile=NONE scope=SPFILE;
Then rebooted the server.
Now everything works but when I try to log into sqlplus or the dbconsole with SYS as SYSDBA it says "insufficient privileges" in sqlplus and "invalid password" on the dbconsole login screen.
I did NOT change the SYS password and I was logged in as SYS when I ran the ALTER SYSTEM command so I know that I had the right password at that time.
All other logins, including SYSTEM, still work.
Any ideas on what happens here and how I can fix it?