Re: rman connection authorization

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"

Do you have a password file? Can you come in remotely as sysdba? That's just my kneejerk response to 1031. Perhaps the RMAN user needs to have privilege (RECOVERY_CATALOG_OWNER role, sysdba...seriously, try it for this problem, see
http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta017.htm ) granted to access the PL packages it needs to run. Perhaps catproc had errors - does anybody ever check? Maybe you should screw up package SYS.DBMS_BACKUP_RESTORE and see if you get a different error... apologies if any of these thoughts don't apply to 10.

jg

--
@home.com is bogus.
Google, like the Borg, needs to learn basic transaction usage.
http://www.nytimes.com/2006/06/14/technology/14search.html?ei=5088&en=c96a72bbc5f90a47&ex=1307937600&adxnnl=1&partner=rssnyt&emc=rss&adxnnlx=1150326563-WzIpwF1JJud9MXqu1YFtwQ