Oracle Exam 1Z0-066 Topic 5 Question 38 Discussion

Actual exam question for Oracle's 1Z0-066 exam

Question #: 38
Topic #: 5

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?

ACreate 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.

BConfigure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.

CSet 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.

DSet the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.

Show Suggested Answer

Suggested Answer: C

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

References:

http://www.oracle.com/us/solutions/sap/wp-ora4sap-dataguard11g-303811.pdf

by Shalon at May 05, 2022, 07:36 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-066 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!