Users' questions

What is an Oracle listener?

by Rhyley Bryan

What is an Oracle listener?

Oracle Net Listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server. This chapter describes how to configure the listener to accept client connections.

How do I bring up the Oracle listener?

Do the following:

  1. Log on to the host where the Oracle database resides.
  2. Change to the following directory: Solaris: Oracle_HOME/bin. Windows: Oracle_HOME\bin.
  3. To start the listener service, type the following command: Solaris: lsnrctl START. Windows: LSNRCTL.
  4. Repeat step 3 to verify that the TNS listener is running.

How do I create a listener Ora file?

Configuring Access to Oracle JServer

  1. Start Oracle Net Manager.
  2. In the navigator pane, expand Local > Listeners.
  3. Select a listener.
  4. From the list in the right pane, select Listening Locations.
  5. Click Add Address.
  6. Select the TCP/IP or TCP/IP with SSL protocol from the Protocol list.

How to check if the Oracle listener is running?

Open a command window

  • nolog. You´ll get a SQLPLUS> prompt.
  • as ssysdba
  • Type startup

    • What does the Oracle listener status?

    myserver

  • HOME variable to restart the listener.
  • Start the BI Publisher database listener (LISTENER).
  • Start the OCSDMDW database listener (LISTENER2).
  • lsnrctl status

    • What is database listener?

    The database listener runs on the database server listening for connections. Once the listener detects a connection request, it sets up any needed processes on the server to get the connection up and running. Once the user or application is connected to the database, the listener hangs around listening for new connection request.