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

Good question. Must have been having a DSA.

<insert dope slap here>
"Thanks. I needed that"

It would appear that, since NOCATALOG is not a valid parm, it was interpreting it as part of the connect credentials. Received on Wed Jun 14 2006 - 17:56:07 CDT