Re: rman connection authorization

DA Morgan wrote:
> EdStevens wrote:
> > Platform: Oracle 10.2.0.1.0 on Win2k
> >
> > Logged on to the box with a local user that is a member of both the
> > local Administrators group and the local ora_dba group.
> >
> > Connection to db with sqlplus, using local credentials, is quite happy:
> >
> > C:\TEMP>sqlplus "/ as sysdba"
> > SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 13 12:23:12 2006
> > Copyright (c) 1982, 2005, Oracle. All rights reserved.
> >
> > Connected to:
> > Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
> >
> > But connecting to rman requires me to spell it out ...
> >
> > C:\TEMP>rman target / nocatalog
> >
> > Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 13
> > 12:23:26 2006
> >
> > Copyright (c) 1982, 2005, Oracle. All rights reserved.
> >
> > 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
> >
> > C:\Documents and Settings\1oraadmin>rman target sys/*********
> > Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 13
> > 12:50:38 2006
> > Copyright (c) 1982, 2005, Oracle. All rights reserved.
> > connected to target database: EPSREP (DBID=2061389341)
> > RMAN> quit
> > Recovery Manager complete.
> >
> > So, what am I overlooking? I've never before had a problem with "rman
> > target / nocatalog"
>
> Where did you get NOCATALOG?
>
> just: rman target / will get you in.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

He is getting the error on the *target* database, so nocatalog has no impact on his error, good or bad.

On Windows, this is usually an indication you are either not in the local ORA_DBA group. It could also be that if you are using a domain/AD account (i.e., NTS authentication in your sqlnet.ora), your privileges in this group have been revoked, or just aren't here. Check with your Windows guys.

Regards,

Steve Received on Wed Jun 14 2006 - 12:33:57 CDT