OraFAQ Forum: Backup & Recovery » ORA-01031: insufficient privileges with RMAN

Home » RDBMS Server » Backup & Recovery » ORA-01031: insufficient privileges with RMAN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01031: insufficient privileges with RMAN [message #567399]

Mon, 01 October 2012 02:03

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

hello experts,

i want to backup my database from the RMAN, but it gives an error --
ORA-01031: insufficient privileges

i logged-in as normal user not as system administrator.


Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>rman target/@prodb

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 1 12:32:47 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  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:\Users\Administrator>

should i need to log-in as system administrator?
or other thing is missing?

and it will be applied for windows7 and windows server2008 os both

thanks in advance........

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567403 is a reply to message #567399]

Mon, 01 October 2012 02:23

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is the database local or remote?
Is your password file correct? (Does it exist?)

Regards
Michel

[Updated on: Mon, 01 October 2012 02:24]

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567411 is a reply to message #567403]

Mon, 01 October 2012 02:48

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks sir....

Michel Cadot wrote on Mon, 01 October 2012 02:23

Is the database local or remote?

this is local database on windows7.

Quote:

Is your password file correct? (Does it exist?)

Regards
Michel

sorry sir, i dont know. and how to know that is this correct or not.

thanks again....

[Updated on: Mon, 01 October 2012 02:52]

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567419 is a reply to message #567411]

Mon, 01 October 2012 03:15

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If it is a local database you don't need "@prodb", just set ORACLE_SID to the correct value, and you have to be windows connected as a member of ORA_DBA windows group.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567428 is a reply to message #567419]

Mon, 01 October 2012 04:45

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks sir...

RMAN gives error again although i log-in as administrator to my local system.


Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Neetesh>rman target/

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 1 15:23:37 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  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:\Users\Neetesh>

and 2-3 days before there were no such type of problem and i took backup successfully from RMAN on same system.
then now what is the problem , don't know.

thanks again....

[Updated on: Mon, 01 October 2012 04:47]

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567436 is a reply to message #567428]

Mon, 01 October 2012 05:48

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

have to be windows connected as a member of ORA_DBA windows group.

Check this.
And check you have the following line (not commented) in your sqlnet.ora file.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
And check if TNS_ADMIN environment variable is set or not.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567458 is a reply to message #567436]

Mon, 01 October 2012 08:18

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks alot sir.....

SQLNET.AUTHENTICATION_SERVICES was (NONE) then i set it (NTS).

thanks again..

and i want to know one more thing that - i have more than one database on my local system , then
can we connect with RMAN to the particular database without using @dbaname ? then how.

[Updated on: Mon, 01 October 2012 08:19]

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567459 is a reply to message #567458]

Mon, 01 October 2012 08:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>can we connect with RMAN to the particular database without using @dbaname ? then how.

SET ORACLE_SID=DBNAME

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Mon, 01 October 2012 08:24]

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567460 is a reply to message #567459]

Mon, 01 October 2012 09:02

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

thanks sir.....

i will follow the guidelines, sorry for that.

and will you please tell me that in which file ORACLE_SID parameter resides?

thanks again.......

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567463 is a reply to message #567460]

Mon, 01 October 2012 10:04

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The ORACLE_SID does not reside in any file.
On Windows you can know the different ORACLE_SID in the "Services" item on control panel.
All that are named OracleServiceXXXX are possible instances and XXXX is the ORACLE_SID.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges with RMAN [message #567560 is a reply to message #567463]

Wed, 03 October 2012 05:49

neetesh87
Messages: 280
Registered: September 2011
Location: bhopal

Senior Member

ok sir, thanks alot

Report message to a moderator

Previous Topic:	re-syncing physical stdby DB
Next Topic:	RMAN-04002: ocipi failed, ORA--1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 20:23:59 CST 2024