DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001


    In DBA Studio (oracle PO 8i Enterprise ed 8.1.7) I want to back up a database. I log into DBA Studio via OMS as system or as me ( I am set up currently with connect and resource and DBA role. In system privileges tab I cannot locate the sysdba privelege?? I have even gone into sqlplus as connect sys / as sysdba and granted myself sysdba and still i get this insufficient priveleges ORA - 01031!!!! Why is there no sysdba available for this datbase and is for the other I had created ?????

    ANY help as I am totallay and utterly lost!!!?

  2. #2
    Join Date
    Nov 2001
    Quebec City
    I am pretty sure there is one script you did not run... but before you try to find it I suggest to create a dummy role with
    'EXP_FULL_DATATASE" as system privilege, and grant it to yourself...

    Also, is your variable ORACLE_SID setup correctly??

  3. #3
    Join Date
    Oct 2001


    I have resolved it!!!!!

    I have resolved the problem today!

    See if you can follow this -

    The day before I logged the problem I had (for security purposes) gone into DBA studio and changed all the passwords for system and for sys - and others. Just out of instinct I logged into DBA Studio 'today' just as I did before (as my username) then on that database I again got the error. So this time I connected as sys and password "change_on_install" as sysdba. Then I went into my username and "Aley looleeya" the system privilege Tab shows the sysdba!!!

    This is quite confusing as I could have sworn yesterday I was connecting in sqlplus as sys with changed passwd as sysdba as well and I got connected ok - Maybe I am totally wrong becasue I had not documented the steps. I guess one thing I can do to check if I am totally burmy or the system has gone screwy is to verify that the passwords were changed ok for the other database.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width