1: "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. ”
Workaround: Dynamic IP, service Oracleoradb10g_home1tnslistener will fail to start, modify D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
LISTENER =
(Description_list =
(DESCRIPTION = www.2cto.com
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP) (host = change to hostname here) (PORT = 1521))
)
)
2. Unable to start the Oracleoradb10g_home1tnslistener service on the local computer error 3: The system cannot find the path specified.
Workaround: First run regedit to start Registry Editor, under hkey_local_machine/system/controlset002/Services and currentcontrolset/ Services found Oracleoradb10g_home1tnslistener entry, right-click in the right window, new/string, named ImagePath.
Double-click the new key and enter E:\oracle\product\10.2.0\db_2\BIN\TNSLSNR in the value data item. EXE (modified according to your own actual situation), determine completion.
Double-click on the service again to open the Oracleoradb10g_home1tnslistener service to see its "path to executable" column has shown its correct value. Then you can start listening.
3. The Listener.ora file \oracle\product\10.2.0\db_1\network\admin on the disk is replaced with the following (where the middle section is the extra code)
# Listener.ora Network Configuration File:e:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools. Sid_list_listener =
(Sid_list =
(Sid_desc =
(sid_name = Plsextproc)
(oracle_home = E:\oracle\product\ 10.2.0\db_1)
(program = extproc)
)
)
(sid_dese=
(GLOBAL_DBNAME=ORCL)
(oracle_home=/app/oracle/ oracle/product/10.2.0/db_1)
(SID_NAME=ORCL)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(address = (PROTOCOL = IPC) (KEY = EXTPROC1))
(address = (PROTOCOL = TCP) (HO ST = 192.168.123.24) (PORT = 1521))
)
)