while connecting to the auxiliary databse RMAN-04006: error from auxiliary
Hello ,
Can anybody help me. It is appreciated. I am working on RMAN cloning to remote host . I am getting
RMAN-04006: error from auxiliary database: ORA-12505: TNS:listener could not resolve SID given in connect descriptor
while connectig to the auxiliary database.
oracle 9.2.0.5 enterprise edition
server HP-UX B.11.00
trget database: testhp9
catalog database: catdb1
auxiliary database; tduphp9
I can ping the database from both the server.
RMAN> connect catalog rman/xxx@catdb1
connected to recovery catalog database
RMAN> connect target sys/xxxne@testhp9
connected to target database: TESTHP9 (DBID=3063303886)
RMAN> connect auxiliary sys/xxxne@tduphp9
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-12505: TNS:listener could not resolve SID given in connect descriptor
my listener.ora
(SID_DESC=
(SDU=32768)
(TDU=32768)
(SID_NAME=tduphp9)
(ORACLE_HOME=/db/app/oracle/product/9.2.0.5)
)
tnsnames.ora
tduphp9 =
(DESCRIPTION =
(SDU = 32768)
(TDU = 32768)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = devhp6.hdc.bio-rad.com)(Port = 1521))
)
(CONNECT_DATA = (SID = tduphp9))
)
oracle@devhp6{tduphp9}/etc> tnsping tduphp9
TNS Ping Utility for HPUX: Version 9.2.0.5.0 - Production on 28-MAY-2009 17:19:35
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (TDU = 32768) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = devhp6.hdc.bio-r
ad.com)(Port = 1521))) (CONNECT_DATA = (SID = tduphp9)))
OK (0 msec)
oracle@devhp6{tduphp9}/etc>
auxilary database tduphp9 is in nomout state
oracle@devhp6{tduphp9}/db/app/oracle/dba/sql> sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.5.0 - Production on Thu May 28 16:42:44 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/db/app/oracle/admin/testhp9/pfile/inittduphp9.ora'
ORACLE instance started.
Total System Global Area 165114472 bytes
Fixed Size 737896 bytes
Variable Size 113246208 bytes
Database Buffers 50331648 bytes
Redo Buffers 798720 bytes
SQL> CREATE SPFILE FROM PFILE='/db/app/oracle/admin/testhp9/pfile/inittduphp9.ora';
File created.
SQL> startup force nomount
ORACLE instance started.
Total System Global Area 165114472 bytes
Fixed Size 737896 bytes
Variable Size 113246208 bytes
Database Buffers 50331648 bytes
Redo Buffers 798720 bytes
Thanks