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!

RMAN-04006: error from auxiliary database:ORA-12504: TNS:listener was not

884225Oct 1 2011 — edited Oct 3 2011
Hiii...

i was doing my dataguard setup , my primary side is a 2 node RAC and my stand by is a single node.
Im using 11gR2 grid infrastruture and database.

when i try to connect to standy by system from priamry side using RMAN im getting the folowing error.

*[*oracle@rac2 ~]$ rman target / auxiliary sys/sys@to_std**

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 29 20:39:04 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: RAC (DBID=2346715690)
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-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


my tnsnames.ora file is the folowing

to_std =
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=datagrd)(PORT=9999))
)
(CONNECT_DATA=
(SERVICE_NAME=STB.msftpnq.com)
)
)


and my listsner.ora file is the folowing

list_std =
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=datagrd)(PORT=9999))
)
)
SID_LIST_list_std =
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=STB.msftpnq.com)
(SID_NAME=STB)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
)
)


plz can anyone help me in resolving the issue.


Thanks in advance.
This post has been answered by Ehtiram Hasanov on Oct 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2011
Added on Oct 1 2011
13 comments
2,892 views