Stop after the Oracleoradb11g_home1tnslistener service on the local computer starts

When I played Oracle today, I suddenly encountered a problem: the Oracleoradb11g_home1tnslistener service on the local computer stopped after it started. Some services stop automatically when they are not being used by other services or programs.

Find a solution on the internet when, found a lot of people have encountered this problem, the first solution did not solve my problem, the following self record, leave a backup, convenient next visit convenient

First step: First check your "network\admin" directory under the "Tnsnames.ora" and "Listener.ora" The two files, my path is: D:\app\Oracle11g\dbhome_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 this 2 files to your IP address, because I just play with Oracle, for convenience, directly changed to 127.0.0.1:


[Plain] View plaincopyprint?
01.LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
06.)
07.)
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
And then start the listener, incredibly well.

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


1: In the registry

Hkey_local_machine/system/currentcontrolset/services/oracleoradb11g_home1tnslistener
Replace the ImagePath in the following:
D:/oracle_11g/product/11.1.0/db_1/bin/tnslsnr. EXE (previous. exe not followed)

2: In Environment variables

Oracle_home to: D:/oracle_11g/product/11.1.0/db_1 (previously empty)

This is a direct copy of others, I was the first to try this way, but did not pass, but not guarantee that this is not the problem, or record