betweenGo

Oracle TNS Listener service not starting

by on Apr.18, 2008, under Oracle

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

Related posts:

  1. ORA-12514 and ORA-27101
  2. Running JBoss with Oracle
  3. Apache not starting because of Skype
  4. Installing the Microsoft Loopback Adapter
  5. Questions to Consider When Starting an eCommerce Site

:

5 Comments for this entry

  • Assad ALI
    May 29th, 2011 on 11:50 PM

    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.

  • shivakumar
    October 26th, 2011 on 8:24 PM

    Thank u

  • srikanth
    December 27th, 2011 on 11:35 PM

    Thanks for the solution. Running Net configuration solved my problem.

  • suresh
    January 5th, 2012 on 10:16 AM

    Thanks it has help me

Leave a Reply

 

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!