|
DATE :-- 1st Sep 2014
|
RMAN-04006
:-- RMAN Duplicate Standby Creation Active Database
Error Detail
released channel: p3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/01/2014 02:24:14
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
RMAN> exit
Issue
Tnsnames.ora
Entry
######################
STANDBY ##############################
DBSTP11G =
(DESCRIPTION =
(ADDRESS
= (PROTOCOL = TCP)(HOST = 192.168.56.163)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBSTP11G)
(UR = A)
)
)
DBPR11G =
(DESCRIPTION =
(ADDRESS
= (PROTOCOL = TCP)(HOST = 192.168.56.161)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBPR11G)
)
)
Listener.ora Entry
# Generated by Oracle
configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.161)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC
=
(GLOBAL_DBNAME = DBPR11G_DGMGRL)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = DBPR11G)
(SERVICE_NAME = DBPR11G)
)
(SID_DESC
=
(GLOBAL_DBNAME=DBSTP11G_DGMGRL)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
(SID_NAME=DBSTP11G)
(SERVICE_NAME=DBSTP11G)
)
)
ADR_BASE_LISTENER =
/u01/app/oracle
Solution
_DGMGRL should not be
part of GLOBAL_DBNAME .. GLOBAL_DBNAME should be same as tnsnames.ora file
entry
After changing the
above my issue resolved
No comments:
Post a Comment