OraFAQ Forum: Backup & Recovery » RMAN 04006 - error from auxiliary database insufficient privileges

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)

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

RMAN 04006 - error from auxiliary database insufficient privileges [message #450802]

Fri, 09 April 2010 05:26

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.

Report message to a moderator

Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #450804 is a reply to message #450802]

Fri, 09 April 2010 05:30

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

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

John Watson
Messages: 8960
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 ?

Report message to a moderator

Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #450853 is a reply to message #450802]

Fri, 09 April 2010 13:28

John Watson
Messages: 8960
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 ?

Report message to a moderator

Re: RMAN 04006 - error from auxiliary database insufficient privileges [message #451037 is a reply to message #450802]

Mon, 12 April 2010 04:15

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.

Report message to a moderator