We have an Oracle Database 12c instance on Windows 2012 R2. Recently we tried changing the SYS password. The change was successful, but strange thing is that the old password still works. We even tried putting random passwords for SYS user and all the passwords work. We were able to change password for SYSTEM and SYSMAN etc but can anyone help with this SYS password issue we're having?
Thanks,
That's because you're authenticating as a user belonging to the dba group. Try going to the users groups and remove your user. When you authenticate as sysdba or sysoper, Oracle first validates if your user belongs to the dba group.