Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

while connecting to the auxiliary databse RMAN-04006: error from auxiliary

user607289May 29 2009 — edited May 29 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2009
Added on May 29 2009
2 comments
1,583 views