What must be true to allow client-server connection to the DBA service?

You need to add a new service to your RAC database, called DBA, to account for all the work done by database administrator sessions performing routine maintenance, to make this visible in the v$service_stats view. The maintenance would be done at quieter times but restricted session is not an option due to round-the-clock access requirements.

The database administration team may connect locally or remotely to the RAC database. You decide to use DBCA to create the new service.

What must be true to allow client-server connection to the DBA service? (Choose two.)

You need to add a new service to your RAC database, called DBA, to account for all the work done by database administrator sessions performing routine maintenance, to make this visible in the v$service_stats view. The maintenance would be done at quieter times but restricted session is not an option due to round-the-clock access requirements.

The database administration team may connect locally or remotely to the RAC database. You decide to use DBCA to create the new service.

What must be true to allow client-server connection to the DBA service? (Choose two.)

A.
The services must be started using the SRVCTL START SERVICE command.

B.
The service must be started using the DBMS_SERVICE.START_SERVICE procedure.

C.
The service must have at least one preferred or available instance that is running and accepting logins.

D.
All the listeners must be reloaded using LSNRCTL RELOAD to recognize the dynamically created service.

E.
The TNSNAMES.ORA file or a name server must contain the net service entries for the DBA service.

F.
The ALTER SYSTEM REGISTER command must be used to induce PMON to register the service with the listeners.



Leave a Reply 0

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