Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?
A.
Create a database service on the standby databases; automate the start of the service after a role change,
and modify the connection description on the clients to use that service.
B.
Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to
include both Primary and the Standby.
C.
Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to
use DB_NAME to connect to the primary database instance.
D.
Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default
listener on the primary database host.
Explanation:
Example of error:
TNS-12514
”TNS: could not resolve the connect identifier specified”
*Cause:
A connection to a database or other service was requested using a connect identifier, and the connect identifier
specified could not be resolved into a connect descriptor using one of the naming methods configured.
*Actions include:
– Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.
– If you are using local naming (TNSNAMES.ORA file):
– Make sure that “TNSNAMES” is listed as one of the values of the NAMES.DIRECTORY_PATH
parameter in the Oracle Net profile (SQLNET.ORA)
– Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.
– Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched
http://www.oracle.com/us/solutions/sap/wp-ora4sap-dataguard11g-303811.pdf
Correct Ans: A
Create database services then automate service startup by setting up a startup trigger to start the service on appropriate database when it is PRIMARY. Let your apps refer to the service defined for PRIMARY to make the connection successfully.
You may use B as well if your environment is RAC and data guard environment is maintained by broker. Question has no mention of RAC or Broker so B may not be a right answer.
Let me take it back…… It seems B is correct not A.
It is a Physical standby database which means you cannot “Create a database service on the standby databases” it should be created on the PRIMARY and let it propagate to the Standby.
Yes
B