OCP CBT Question 662

Please solve the following question.

You have a database instance ORCL that is configured without server parameter files (SPFILE) and therefore cannot dynamically register its services. Which configuration is required in listener.ora to ensure clients can connect to this instance using a specific service name ORCL_SERVICE?

## listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )
# Missing services section for static registration

Add USE_DEDICATED_SERVER = ON to the listener.ora file.

Add a SID_LIST_LISTENER section with an entry for ORCL and ORACLE_HOME.

Configure REMOTE_LISTENER in the database initialization parameter file.

Ensure LOCAL_LISTENER is set to LISTENER_ORCL.