OracleOraDb10g_ How to solve the problem that the home1tnsslistener service cannot be started

Time:2020-11-22

The result is oracleoradb10g_ The home1tnsslistener service cannot be started. There may be three situations:

One listener.ora Unable to start due to file configuration error

2. The related environment variables are not set properly

3. When deleting the client, the server’s relevant registry information will be deleted by mistake, resulting in the failure to start

Unable to start the pop-up information box to display information:“Oracleoradb10g on local computer_ The home1tnsslistener service starts and stops. Some services will stop automatically when they are not used by other services or programs. “

because listener.ora The solution to the problem of unable to start due to file configuration error: check whether the computer name has been modified, if it is host, change it to the correct computer name of the computer; whether the host of the configuration file is set to dynamic IP, if it is changed to the computer name or 127.0.0.1; modify directly listener.ora File, or recreate the monitor through the net manager tool. Here’s me listener.ora For file configuration, please refer to the following:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = E:\oracle\product.2.0\db_1)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(address = (protocol = TCP) (host = own computer name) (Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)

If you still can’t start through the above steps, please check the registry configuration:

First run regedit to start the registry editor

In HKEY_ LOCAL_ Find oracleoradb10g under services and currentcontrolset / services under machine / system / controlset002 /_ Home1tnsslistener, check whether there is an imagepath entry. If not, create one. The value setting is: your own installation directory \ \ dB_ If it still fails to start, try to modify it to your own installation directory, DB_ 1\BIN\ TNSLSNR.exe Try, some netizens said that because of this setting value after the space, did not add. Exe caused. As shown in the figure:

If you can’t start oracleoradb10g through the above_ For the home1tnsslistener service, my suggestion is to reload Oracle and do cold backup to restore the database if allowed.

I installed an 11g client in the company’s server (the original 10g server) and then used its own uninstall tool to uninstall, resulting in Oracle oradb10g_ Home1tnsslistener service exception failed to start. After struggling for a day, I still couldn’t start it, and then I implemented the re installation of Oracle. Because the company has 50g of data in that server, there is no way to delete Oracle to re install. That is to say, when I uninstall, I found that there is no Oracle product to be uninstalled, and then I suddenly realized.

If you have a database in Oracle and need to be restored, you should make relevant preparations before re installation, such as backing up the original database files and control files. Generally, there is Oracle ﹣ product ﹣ 10.2.0 ﹣ oradata

For example: you originally installed it in E: Oracle. After deleting Oracle perfectly, you can change e: Oracle to e: Oracle_ Old; then restart the computer and install Oracle according to the original installation directory_ The folder orcl in the old directory, which is the folder of “product \ \ 10.2.0” oradata, is copied to the new installation directory, and the cold backup recovery is basically realized.

The above is an introduction to Oracle oradb10g_ Home1tnsslistener service can not start the solution, I hope to help you!