ORA-12514 When trying to add the secondary physical database
894939Nov 14 2012 — edited Jan 22 2013Hi All,
I'm getting ORA-12514 when I'm trying to add my physical standby database in DGMGRL. Please find below my listner.ora configurations in both primary and secondary DB.
Primary
--------------
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = DGP.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = DGP)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = oracledgp)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = DGP)
(ORACLE_HOME = /oracle/DGP/112_64)
(GLOBAL_DBNAME=DGP.DGMGRL.oracledgp)
)
(SID_DESC =
(SID_NAME = DGP)
(ORACLE_HOME = /oracle/DGP/112_64)
(GLOBAL_DBNAME=DGR.DGMGRL.oracledgr)
)
)
Secondary
----------------------
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = DGP.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = DGP)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = oracledgr)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = DGP)
(ORACLE_HOME = /oracle/DGP/112_64)
(GLOBAL_DBNAME=DGR)
)
(SID_DESC =
(SID_NAME = DGP)
(ORACLE_HOME = /oracle/DGP/112_64)
(GLOBAL_DBNAME=DGP)
)
)
Please help I tried but as this is common error still I cannot find the specific error here...
Thanks,
Shanaka.