Jump to content
NigelDams

sysdba lacks privileges

Recommended Posts

Hi everyone - I've just created a new oracle database, using 11.2g on windows, and I logged into SQL*Plus using "sys/xxx as sysdba".    All good so far.    Then I entered 'archive log list' and it said 'insufficient privileges'.       I've done this kind of thing for years and years and this is the first time sysdba has lacked that privilege.   If I log in as 'sysoper' the command works.

I'm using the same database creation scripts I always use and can't think of anything that could possibly be different .... any ideas?

Is there some way I can 'grant sysdba to sys' or something like that?

Share this post


Link to post
Share on other sites

Hi Nigel,

That’s weird, as SYS should be granted the SYSDBA role.

The fact that SYS connected as SYSDBA indicates that SYS has that role!

Of course, you should be able to grant sysdba to SYS, but I’m concerned why it is not already enabled.

Do you have the windows ora_dba group set up:

http://www.dba-oracle.com/t_ora_dba_group.htm

Let’s start by seeing all privileges and roles that are granted to SYS:

http://www.dba-oracle.com/t_display_show_all_privileges_for_user.htm

Please advise.

Share this post


Link to post
Share on other sites

Hi Donald, thanks for your reply.    I actually fixed it in the meantime, the only way I could think of was to go in to rman and 'grant sysdba to sys' which did the trick.

But this raises another issue ... before doing this, I could get into rman by typing

rman target /

as I've done a thousand times before.   Now, for the first time, I get this:

 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

??????

If I do "rman target sys/<pwd>" I can get in - but any other username gets the same reply as above
                                   

Share this post


Link to post
Share on other sites

Hi Nigel,

This is also a privilege problem.

Can you connect okay when manually entering the user/password?

I would also look at the environmental settings, and verify that you are on the OS as the desired user.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×