Administering the Listener

You can use DBaaS Monitor to administer the listener, including troubleshooting unknown service name errors.

Viewing Listener Status Information

The Oracle Net Listener (the listener) is a process that resides on the server. It listens for incoming client connection requests and manages traffic to the server.

To review listener status information:

  • On the DBaaS Monitor home page, click Listener. Or in the Database drop-down menu, click Listener.

    The RDBMS Listener page displays.

The RDBMS Listener page shows the following information:

  • Status of the listener, including start time

  • Protocol addresses the listener is configured to listen on

  • Summary of the database services registered with the listener and the service handlers allocated to each service

  • Registered database services (service name), database instance associated with the service, and connection status

Starting the Listener

By default, an Oracle Net listener is automatically started in your database deployment. If you have shut it down or it has crashed, you can use DBaaS Monitor to start the listener by performing the following steps:

  1. On the DBaaS Monitor home page, click Listener. Or in the Database drop-down menu, click Listener.
  2. In the Listener page menu, click Turn on to start the listener.

Stopping the Listener

To stop the listener:

  1. On the DBaaS Monitor home page, click Listener. Or in the Database drop-down menu, click Listener.
  2. Click Turn off to stop the listener.

Verifying that the Listener Knows of a Service

An "ORA-12514: Listener Does Not Currently Know of Service Requested in Connect Descriptor" error indicates that the specified service name is unknown by the Oracle Net Listener process. You can verify that the specified service name is configured with the listener by performing the following steps:

  1. On the DBaaS Monitor home page, click Listener. Or in the Database drop-down menu, click Listener.
    The RDBMS Listener page displays.
  2. Review the information displayed to determine whether the requested service name is listed.