Oracleoradb10g_home1tnslistener cannot start

Source: Internet
Author: User

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))
)
)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.