Home » RDBMS Server » Backup & Recovery » RMAN 04006 - error from auxiliary database insufficient privileges (oracle 11 g enterprise edition 11.1.0.6.0, MS windows server 2003)
RMAN 04006 - error from auxiliary database insufficient privileges [message #450802] Fri, 09 April 2010 05:26 Go to next message
rrlsudha
Messages: 2
Registered: April 2010
Junior Member

We are trying to implement dataguard on 2 different servers. As per the steps we have set up primary, standby etc., We have checked tnsping for standby . It works. Proper entries have been made in listner.ora, tnsnames.ora. The password file was created and copied to standby server in dbs folder. remote.... option is also exclusive. But still we get the above error. What else should we verify? Please suggest.
Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #450804 is a reply to message #450802] Fri, 09 April 2010 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN-04006: error from auxiliary database: %s
 *Cause:  Oracle error signaled by auxiliary database.
          This message should be accompanied by other error message(s)
          indicating the cause of the error.
 *Action: Check the accompanying errors.

If you did ALL correctly then it works.

Regards
Michel

[Updated on: Fri, 09 April 2010 05:31]

Report message to a moderator

Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #450851 is a reply to message #450802] Fri, 09 April 2010 13:24 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I have had exactly this problem when using a case sensitive password file. Did you create it with ignorecase=y ?
Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #450853 is a reply to message #450802] Fri, 09 April 2010 13:28 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Actually, I think there may be something more obvious: you are using Windows, does that mean that your password file should be in %ORACLE_HOME%\database, not %ORACLE_HOME%\dbs ?
Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #451037 is a reply to message #450802] Mon, 12 April 2010 04:15 Go to previous messageGo to next message
rrlsudha
Messages: 2
Registered: April 2010
Junior Member

Hello John

Thank you. I copied the password file to %ORACLE_HOME%\database folder. Then it connected to auxiliary in rman and started working. I had created it with ignorecase=y. Only confusion for me was didn't understand the filename to be given. Whether it is oraowdxxxx or PWDxxxx. Its windows os. anyway I created with both names and copied as I didn't want to stop here to understand for more days. RMAN successfully connected and copied files.
Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #451047 is a reply to message #451037] Mon, 12 April 2010 04:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The correct name and location is specified on the documentation.

Regards
Michel
Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #451063 is a reply to message #450802] Mon, 12 April 2010 05:12 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
IN windows, it is pwd<sid>.ora
Previous Topic: Backup going fine or not
Next Topic: RMAN Duplicate database
Goto Forum:
  


Current Time: Fri Mar 29 08:17:48 CDT 2024