Wednesday, October 5, 2011

ORA-12154: TNS:could not resolve the connect identifier specified

ORA-12154: TNS:could not resolve the connect identifier specified

DGMGRL> add database 'BHUVAN' as connect identifier is ‘BHUVAN_DG’ maintained as physical;
Error: ORA-12154: TNS:could not resolve the connect identifier specified

when i was trying to add the database to the DG broker, i was getting this issue in oracle 11gR2.

SOLUTION:
1) Check whether you have proper configured on both the nodes

A) LOCAL LISTENER -- it should be your VIP of the node

B) REMOTE_LISTENER -- it should be your SCAN name for the cluster database

C) LISTENER_NETWORK -
A network may contain multiple local and remote listeners. By default, all listeners are cross-registered with each other. By specifying a set of listeners in the LISTENER_NETWORKS initialization parameter, you can designate a subset of local listeners with a subset of remote listeners. Listeners specified by the LISTENER_NETWORKS parameter should not be specified by the LOCAL_LISTENER and REMOTE_LISTENER parameters.
The syntax of LISTENER_NETWORKS is as follows:
LISTENER_NETWORKS = '((NAME=network_name)
                      (LOCAL_LISTENER=["]listener_address[,...]["])
                      [(REMOTE_LISTENER=["]listener_address[,...]["])])'
NOTE: Listeners specified by the LISTENER_NETWORKS parameter should not be used in
the LOCAL_LISTENER and REMOTE_LISTENER parameters. Otherwise, cross registration will happen and connections will be redirected cross networks.

D) Check the listener status.

No comments:

Post a Comment