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 2 discussion

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

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which will fulfill this requirement?

  • A. Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
  • B. Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
  • C. Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
  • D. Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
References:
http://docs.oracle.com/cd/B19306_01/server.102/b14239/scenarios.htm#i1054744
by Kamaelk at Oct. 10, 2019, 10:41 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
ScottL
1 year, 3 months ago
Answer B
upvoted 1 times
...
JESUSBB
2 years, 5 months ago
Answer: B
upvoted 2 times
...
Kamaelk
5 years, 3 months ago
How it is posssible to create service on standby db without clusterware? Right answer must be B, because of service creating on primary using DBMS_SERVICE.CREATE_SERVICE, and seting up trigger for starting service if ROLE is Primary.
upvoted 3 times
Kamaelk
4 years, 11 months ago
One more test. Let create service on standby... as saind in "A": DGMGRL> show configuration; Configuration - orcl_m2-1z0-066.ora.lab Protection Mode: MaxPerformance Members: orcl3 - Primary database orcl1 - Physical standby database orcl - Logical standby database (disabled) ORA-16661: the standby database needs to be reinstated SQL> select database_role,open_mode from v$database; DATABASE_ROLE OPEN_MODE ---------------- -------------------- PHYSICAL STANDBY READ ONLY WITH APPLY [oracle@m1-1z0-066 ~]$ srvctl add service -db orcl1 -service ora066 [oracle@m1-1z0-066 ~]$ srvctl start service -service ora066 -db orcl1 PRCD-1084 : Failed to start service ora066 PRCR-1079 : Failed to start resource ora.orcl1.ora066.svc CRS-5017: The resource action "ora.orcl1.ora066.svc start" encountered the following error: ORA-44786: Service operation cannot be completed. ORA-06512: at "SYS.DBMS_SERVICE", line 76 ORA-06512: at "SYS.DBMS_SERVICE", line 483 WTF?)) Упппссс
upvoted 2 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