ORA-12541 Error Win2K - cannot create listener service in Admin Tools!

From: Phil Powell <soazine_at_erols.com>
Date: 13 Dec 2002 13:05:32 -0800
Message-ID: <1cdca2a7.0212131305.26baa344@posting.google.com>

I am getting ORA-12541 when I try to connect to my local db on my machine here. Error in the logs stipulate that the listener "DEADEV_LISTENER" points to an object that does not exist.

Here's the problem: DEADEV_LISTENER does not exist either!!!!

My syntax in my listener.ora file points to PHILDB_LISTENER, which does not have a service in my Win2K Admin Tools to start it! :(

# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\ADMIN\listener.ora # Generated by Oracle configuration tools.

SID_LIST_PHILDB_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = phildb.phil)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = phildb)

    )
  )

PHILDB_LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521)) )

based on what you see so far, why can I not have a phildb_listener service in my Admin Tools in order to start the service, and why does my old service, OracleOraHome92TNSListenerDEADEV_LISTENER, still persist even though it starts no actively existing listener?

Phil Received on Fri Dec 13 2002 - 15:05:32 CST