Oracle TNS Listener service not starting

Whenever I tried to start my local TNS Listener service, OracleOraDb10g_home1TNSListener, I would get an error like this.

The OracleOraDb10g_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service.

This forum thread, Can’t start Oracle service, suggested I do the following to diagnose the problem.

  1. cmd
  2. lsnrctl
  3. start

This worked and I saw the following error which showed my Oracle install had not been properly done, the listener was pointing to the wrong server.

LSNRCTL> start
System parameter file is
  C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Error listening on:
  (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bad.betweengo.com)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
    32-bit Windows Error: 1004: Unknown error

In C:\oracle\product\10.2.0\db_1\network\admin\listener.ora the listener is improperly configured for bad.betweengo.com.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bad.betweengo.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

I ran Oracle’s Net Configuration Assistant and updated the Listener configuration which fixed the above listener to point to my server. Now C:\oracle\product\10.2.0\db_1\network\admin\listener.ora points correctly to good.betweengo.com.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = good.betweengo.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )


Share

12 thoughts on “Oracle TNS Listener service not starting

  1. my name is assad ali my question is that i installed oracle with developer in the system and my plsql plus properly work in the system and dba pawwored corretly wrking in the system but my oracle developer of TNS servieces is not properly work and oracle builder of plsql plus is not accepted the passoword correctly you describe my how i can start TNS listner in oracle application then i can work properly if you help me i thank full to you for this deed of kindness thanks.

  2. According to your suggestion, I started the net configuration assistant and selected ‘directory usage configuration’ on first page. In the next step I selected ‘oracle internet directory’. In the next step it asks for the host name where the directory service is located. Can you please tell me what this is? I tried entering the name of my computer but it is giving me an error. Can you please explain the detailed steps and tell me where I am goin wrong?

  3. Omair, sorry but I don’t know what you should put for the host name where the directory service is located. Maybe you can skip it, i.e. leave blank?

  4. Pingback: Oracle TNS Listener service not starting | OC KPP

  5. We had a similar problem after we changed work location. Original IPs were changed and listener was using the old IP.

    We changed it to the new IP.

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>