Home » RDBMS Server » Backup & Recovery » ORA-01031: insufficient privileges with RMAN
ORA-01031: insufficient privileges with RMAN [message #567399] Mon, 01 October 2012 02:03 Go to next message
neetesh87
Messages: 274
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........
Re: ORA-01031: insufficient privileges with RMAN [message #567403 is a reply to message #567399] Mon, 01 October 2012 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 57608
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
neetesh87
Messages: 274
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 Go to previous messageGo to next message
Michel Cadot
Messages: 57608
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01031: insufficient privileges with RMAN [message #567428 is a reply to message #567419] Mon, 01 October 2012 04:45 Go to previous messageGo to next message
neetesh87
Messages: 274
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 Go to previous messageGo to next message
Michel Cadot
Messages: 57608
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01031: insufficient privileges with RMAN [message #567458 is a reply to message #567436] Mon, 01 October 2012 08:18 Go to previous messageGo to next message
neetesh87
Messages: 274
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 Go to previous messageGo to next message
BlackSwan
Messages: 21941
Registered: January 2009
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 Go to previous messageGo to next message
neetesh87
Messages: 274
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.......
Re: ORA-01031: insufficient privileges with RMAN [message #567463 is a reply to message #567460] Mon, 01 October 2012 10:04 Go to previous messageGo to next message
Michel Cadot
Messages: 57608
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01031: insufficient privileges with RMAN [message #567560 is a reply to message #567463] Wed, 03 October 2012 05:49 Go to previous message
neetesh87
Messages: 274
Registered: September 2011
Location: bhopal
Senior Member
ok sir, thanks alot
Previous Topic: re-syncing physical stdby DB
Next Topic: RMAN-04002: ocipi failed, ORA--1
Goto Forum:
  


Current Time: Fri Apr 18 03:06:18 CDT 2014

Total time taken to generate the page: 0.13689 seconds