Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rman connection authorization

Re: rman connection authorization

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 14 Jun 2006 12:30:23 -0700
Message-ID: <1150313428.418258@bubbleator.drizzle.com>


Steve Howard wrote:

> 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

I agree. But if memory serves me correctly he indicated he had verified ORA_DBA group membership. Perhaps I mixed up the OP's post with another.

-- 
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
Received on Wed Jun 14 2006 - 14:30:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US