Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Could not start the TNSListener service on Local Computer

661470Sep 25 2008 — edited Sep 26 2008
I installed Oracle 10g rel 2 under Windows 2000. The computer is DHCP, so I installed the MS loop adapter, and am able to successfully the new IP address.

SQL*Plus returns this error:

ORA-12541: TNS:no listener

When I try to start the listener via control panel > services, I get this Microsoft Management Console error:

Could not start the OracleOraDb10g_home1TNSListener service on Local Computer. The service did not return an error. This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator.

My full computer name (via control panel) is dimension4100.ora.newmiddleclass.com and it is a member of workgroup WORKGROUP.

C:\WINNT\system32\drivers\etc\hosts contains (I added the 2nd line):

127.0.0.1 localhost
192.168.255.255 dimension4100.ora.newmiddleclass.com dimension4100

# listener.ora Network Configuration File: C:\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 = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = ora.newmiddleclass.com)(PORT = 1521))
)
)

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

HCM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora.newmiddleclass.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HCM.ora.newmiddleclass.com)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

My SID is HCM.

Can someone please suggest a solution? Thanks.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 24 2008
Added on Sep 25 2008
39 comments
29,066 views