This discussion is archived
1 Reply Latest reply: Nov 9, 2012 5:41 PM by mseberg RSS

ORA-01031: insufficient privileges - after entering CONNECT TARGET /

xoraclex Newbie
Currently Being Moderated
Hello Oracle gurus:
I'm practically a noob when it comes to utilizing RMAN (Recovery Manager). I've used RMAN many times but I've never set it up before, thus when I created a new database recently using the Database Configuration Assistant I set it to create a recovery area as well. However, I've never performed a startup mount or connected to a target before. I've researched these both as much as I've could with the few resources at my disposal and I'm getting no where.

I've got Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 64bit on Windows Server 2008. I've run into an archivelog issue where recovery_area_dest is all full, so I can't preform any further task against the database until I clear the archivelog recovery area. I've done this before plenty of times, though the problem this time is I didn't properly setup a connect target for RMAN so I am thus far unable to connect to successfully to RMAN in order to fix the archivelog recovery area.

From the command prompt entered:
rman

Then once in the recovery manager I performed the following RMAN command:
RMAN> CONNECT TARGET /

and i got the following results:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges

What are the steps I need to take in order to create a proper target with sufficient privileges so that I can correct the archivelog recovery area?

All help and advice is greatly appreciated.

Thank you.
  • 1. Re: ORA-01031: insufficient privileges - after entering CONNECT TARGET /
    mseberg Guru
    Currently Being Moderated
    Hello;

    Welcome to the forums.

    On Windows to solve this problem you can must connectby giving valid username username and password.
    RMAN> connect target sys
    
    target database Password:
    connected to target database: 
    OR
    % rman TARGET SYS/oracle@trgt NOCATALOG
    % rman TARGET / CATALOG rman/cat@catdb 
    http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta011.htm

    Excellent details for you first post by the way,

    Best Regards

    mseberg

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points