RMAN suddenly wont connect to target

[bookouri]

NO changes have been made to the target db, or the rman repository database or the RMAN user, but suddenly yesterday I started getting these errors from rman when i try to connect to any of our target databases. Ive looked up the errors but havnt found any real answer to what might have happened or where to look.

I can still connect to the rman database
rman catalog rman/rman@myrmandb

but then when it do the "connect target live" or either of our other databases in the catalog I get this:


RMAN-00571: ===============================================
RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===============================================
ORA-01031: insufficient privileges

RMAN>

What happened? any suggestions?

thanks

 

[Thargy]

bookouri,

I know that the RMAN account is highly privileged, but i suggest you take the oracle warning at face value.

Log into rman as sys, and see what happens.

Go on the server as a member of the ora_dba group, and say

RMAN target /@myrmandb

and see what happens. If sys has insufficient privileges, then I'd be amazed. You could then at least do a backup, to keep things safe, whilst you then investigate under less stress.

Regards

Tharg

Grinding away at things Oracular

 

[bookouri]

thanks, Ill give that a try.. still nothing working so far.