FIX: The Oracleoradb10g_home1tnslistener service on the local computer stops after it starts

Original address: http://justsee.iteye.com/blog/1320059

Start a problem manually: stop after the Oracleoradb10g_home1tnslistener service on the local computer starts. Some services stop automatically when they are not being used by other services or programs.

When looking for solutions on the Internet, we found that many people have encountered this problem, but none of them have been solved. Keep a record of the following, save a backup, convenient for next check

Question 1: First check your "network\admin" Directory of "Tnsnames.ora" and "Listener.ora" The two files, my path is: D:\oracle\product\10.2.0\db_1\NETWORK\ ADMIN, and then look inside the "HOST" information to see if it is your current IP address, if you are not trying to change the 2 files to your IP address, or directly to the 127.0.0.1 (or computer name):

Java code

1.LISTENER =  2.  (Description_list =  3.    (DESCRIPTION =  4.      (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))   5.      (ADDRESS = (PROTOCOL = TCP) (HOST =127.0.0.1) (PORT = 1521))  6.    )   7.  )

And then start the listener just fine.

But also found that there is a first unsuccessful friend, then try the second step :

Issue 2: In the registry

Hkey_local_machine/system/currentcontrolset/services/oracleoradb11g_home1tnslistener
Replace the ImagePath in the following:

D:\oracle\product\10.2.0\db_1/bin/tnslsnr. EXE (previous. exe not followed)

Question three: in environment variables

Oracle_home instead of: D:\oracle\product\10.2.0\db_1