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