• Description: Administering RAC
• Passing Score: 0%
• Practice Test - Number of questions: 122 questions
• Simulation Test - Number of questions: 122 questions
• Simulation Test Duration: 120 minutes
• Has explanations: No

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. Exam Type Oracle What must be true to allow client-server connection to the DBA service? (Choose two.)

Answer(s)

1. The services must be started using the SRVCTL START SERVICE command.
2. The service must be started using the DBMS_SERVICE.START_SERVICE procedure.
3. The service must have at least one preferred or available instance that is running andaccepting logins.
4. All the listeners must be reloaded using LSNRCTL RELOAD to recognize the dynamicallycreated service.
5. The TNSNAMES.ORA file or a name server must contain the net service entries for the DBAservice.
6. The ALTER SYSTEM REGISTER command must be used to induce PMON to register theservice with the listeners.

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

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