Cannot Log In As SYSTEM
1012198May 31 2013 — edited Jun 2 2013I created an empty database using the DB Configuration Assistant, then imported a dump file provided by a client. I believe what happened is that all of the user passwords (for SYSTEM, SYSDBA, etc.) which I had created in the DB Config Assistant were overwritten during the import process as I can no longer log into the DB. I have attempted logging into sqlplus using the /as sysdba swith while logged in to the server as a user in the ORA_DBA role, but I still get the ORA-01031: insufficient privileges message. I am running Oracle 11g R2 on Windows 2008 R2. Any suggestions would be greatly appreciated.
Edited by: user11222476 on May 31, 2013 2:35 PM