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