Home » RDBMS Server » Backup & Recovery » RMAN-04006: error from auxiliary database - URGENT
RMAN-04006: error from auxiliary database - URGENT [message #74574] Sun, 09 January 2005 19:35 Go to next message
arun
Messages: 67
Registered: January 2000
Member
Hello,

I'm trying to clone new database from existing database, and both on same server. I'm getting following error while I try to initiate the command as shown below. Kindly help me resolving this.

[[inftw6800cd2:IFDEVL11i:oracle]]$ rman target sys/**** CATALOG rman/****@devrman AUXILIARY sys/****@IFMOON;

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: IFDEV11I (DBID=3906563803)
connected to recovery catalog database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
Re: RMAN-04006: error from auxiliary database - URGENT [message #74580 is a reply to message #74574] Mon, 10 January 2005 04:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
connection to targetDB is good.
connection to rmanDB is good.
connection to auxillaryDB is NOT good.

First make sure auxDB is in nomount stage and try dupication
later,
try recreating the passwordfile for aux.
Then
invoke a seperate session for testing.

$rman
connect target ../..
connect rcvcat ../..@rmandb
connect auxillary ../..@tnsforaux.

If your last step goes good, then you are all set.
Re: RMAN-04006: error from auxiliary database - URGENT [message #118590 is a reply to message #74580] Fri, 06 May 2005 04:47 Go to previous messageGo to next message
sharmahamu
Messages: 2
Registered: May 2005
Location: agra
Junior Member

try that
aux in momount stage
connect target 'sys/pass@service_target';
connect catalog 'user/pass@service_target';
connect auxiliary 'sys/pass'
target and auxiliary password is same
all these step done in auxiliary terminal
Re: RMAN-04006: error from auxiliary database - URGENT [message #336086 is a reply to message #74574] Thu, 24 July 2008 13:57 Go to previous messageGo to next message
teeroy65
Messages: 2
Registered: July 2008
Location: Terre Haute, IN
Junior Member
So both passwords much match. I am just now getting around to setting up our physical standby and I guess I forgot to create the password file the first time around back in April. Are there consequences if I reset the password on our primary so I can make them match?
Re: RMAN-04006: error from auxiliary database - URGENT [message #435103 is a reply to message #118590] Mon, 14 December 2009 05:42 Go to previous messageGo to next message
yempati
Messages: 1
Registered: December 2009
Junior Member
we have to connect from catalog DB i guess...how ever when tried to connect from catalog DB i was getting an error saying

RMAN-04006: error from auxiliary database: ORA-28547: connection to server failed, probable Oracle Net admin error

my listener and tnsnames.ora as follows

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Practice)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = yempati)
(ORACLE_HOME = /oraeng/app/oracle/product/11.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = yempati)
(ORACLE_HOME = /oraeng/app/oracle/product/11.1.0)
(SID_NAME = yempati)
)
)


LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Practice)(PORT = 1321))
)
)
)

SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = aux)
(ORACLE_HOME = /oraeng/app/oracle/product/11.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = yempati)
(ORACLE_HOME = /oraeng/app/oracle/product/11.1.0)
(SID_NAME = aux)
)
)


tnsnames.ora....

yempati =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.2.30)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = yempati)
)
)

auxll =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.2.30)(PORT = 1321))
)
(CONNECT_DATA =
(SERVICE_NAME = aux)
)
)



i am unable to connect to auxiliary DB.
Re: RMAN-04006: error from auxiliary database - URGENT [message #435116 is a reply to message #435103] Mon, 14 December 2009 06:45 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As you didn't tell us what you did (or better show us by copy and paste) we can't help.

Regards
Michel
Previous Topic: Data Recovery after SET UNUSED was performed on a column
Next Topic: RMAN to disk - no tape handling - procedure
Goto Forum:
  


Current Time: Sun Dec 22 17:48:56 CST 2024