Documentation Center

Activating the Oracle Listener service

You must start the Oracle listener service so incoming client connection requests are received and sent to the database server.

Procedure

  1. Open a command prompt window and set the ORACLE_HOME variable.
    For example, in the command prompt window, enter: set oracle_home=c:\oracle\product\11.2.0\dbhome_1
  2. In the same command prompt window, enter lsnrctl start.
    This ensures that an OracleOraDb<nn>g_home1TNSListener service exists in the Services Control Panel. Where <nn> is the Oracle version number.
    For example:
    • OracleOraDb11g_home1TNSListener
  3. Access Windows Administrative Tools then click on Services and locate the OracleOraDb<nn>g_home1TNSListener service. Make sure it is set to Automatic.
  4. Restart the OracleOraDb<nn>g_home1TNSListener service.

    If your database and application server are not able to communicate with each other, it is typically because the two-way communication is blocked by a firewall or security settings are not matching. Refer to the topic about security and firewall configuration for more information.