Which two statements are true about database service ad…

Which two statements are true about database service administration in a RAC environment?

Which two statements are true about database service administration in a RAC environment?

A.
When services are created with srvctl, tnsnames.ora is automatically updated.

B.
When services are created with srvctl, the service is not started automatically.

C.
Service attributes can be modified, unless an instance hosting the service is in restricted mode.

D.
When the DBMS_SERVICE package is used to modify a service, the CRS resource is automatically
synchronized with the changes.

E.
When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR.

F.
When services are started with srvctl, they are automatically added to the data dictionary of the hosting
database if not already defined.

Explanation:
B: To start the service you need to use the START_SERVICE procedure.
F: When the service is started by Oracle Clusterware or Oracle Restart, the service is modified in the database
to match the resource defined to either Oracle Clusterware or Oracle Restart.
Incorrect Answers:
A: Srvctl manages CRS (OCR), but does not modify tnsnames.ora.
C: Users can modify the edition attribute while the service is up and running
D: If you are using Clustered Managed Services with Oracle Clusterware, or using Oracle Restart with your
single instance database, you must modify services using the srvctl command rather than DBMS_SERVICE.
E: You cannot use the DBMS_SERVICE.DELETE_SERVICE subprogram if your services are managed by
Oracle Clusterware, Oracle Restart, or Oracle Global Data Services.
Note: Oracle Clusterware is the cross platform cluster software required to run the Real Application Clusters
(RAC) option for Oracle Database.

https://docs.oracle.com/database/121/ARPLS/d_serv.htm#ARPLS68022



Leave a Reply 1

Your email address will not be published. Required fields are marked *