RMAN-04006: error from auxiliary database:ORA-12504: TNS:listener was not
884225Oct 1 2011 — edited Oct 3 2011Hiii...
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.