ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-066 All Questions

View all questions & answers for the 1z0-066 exam
Go to Exam

Exam 1z0-066 topic 1 question 56 discussion

Actual exam question from Oracle's 1z0-066
Question #: 56
Topic #: 1
[All 1z0-066 Questions]

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.
Show Suggested Answer Hide 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 Kamaelk at Oct. 25, 2019, 2:43 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
oraexam12
2 years, 5 months ago
using role-based database services introduced in 11.2. To use role-based services, Oracle Clusterware must be installed and active on the primary and standby sites for both single instance (using Oracle Restart) and Oracle RAC databases. oracle (Doc ID 1429223.1) --the answer is B
upvoted 1 times
...
Kamaelk
5 years, 3 months ago
Right answer is B
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago