SYSDBA System role gone..
674757May 26 2010 — edited May 26 2010Greetings all,
You have to love Oracle, wonder what I did this time. I have a Redhat 5.4 host 64 bit, running 11.1.0.7. I created my database, tablespaces and did an import of an export file from a Windows 32 bit DB. That seemed to go well, up and running. I then took the Examples schema off-line to move the datafile to another location, but could not bring that schema or datafile back on-line becuase it need recover. Well, I could export the Example schema later and fix that, that's not the issue right now, and will tend to that later. However, I noticed that my SYS user account is missing the SYSDBA and SYSOPER system roles. They are not even available from the drop down. Where did they vanish to? I can connect via SQL >connect / as sysdba, and that works well, but don't know what rights that has now.
Any clue? The Windows DB had the SYSDBA and SYSOPER roles. Did something get corrupt durring the export or could this be related to taking the Example tablespace off-line?
Would apprediate your advise..
Thx,
Rob
Edited by: ronthe11gdba on May 26, 2010 9:15 AM