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!

ORA-12514 When trying to add the secondary physical database

894939Nov 14 2012 — edited Jan 22 2013
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2013
Added on Nov 14 2012
37 comments
7,588 views