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.
- cmd
- lsnrctl
- 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))
)
)
Thank you!
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.
Thank u
Thanks for the solution. Running Net configuration solved my problem.
Thanks it has help me
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?
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?
Thanks, worked for me.
thanks a lot !, this really helped.
Pingback: Oracle TNS Listener service not starting | OC KPP
thanks a lot !, this really helped.
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
Great work ……..