RE: DB Connecting Problem

From: Michael P Sale <Michael.Sale_at_oracle.com>
Date: Fri, 21 Jun 2002 07:48:56 -0800
Message-ID: <F001.004842F7.20020621074856@fatcity.com>

Ken,  

Try starting your listener from the command line: C:\> lsnrctl start  

This will likely give you a better error message you can work from. If that doesn't make it clear enough then check your listener.log (you'll find that in the Oracle Home's network\log directory). If that still isn't enough then you may need to turn tracing on the listener and engage Oracle Support.

Regards,

Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626

-----Original Message-----
JANUSZ
Sent: Friday, June 21, 2002 7:58 AM
To: Multiple recipients of list ORACLE-L

I'm having a problem of logging on to my two DB's. When I check "services" I notice that the listener is not running. I startup the listener and it shuts down immediately. The listener will not stay up.

When I try to log into the DB's I get these errors.

KEN database - Oracle generated name is DC0X4411 ORA-12154: TNS: could not resolve service name

PARTS database
ORA-12541: TNS: no listener

My DB is 9.0.1 on XP Prof.

Any ideas as to what could be causing this?

Thanks much,
Ken

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Michael P Sale
  INET: Michael.Sale_at_oracle.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 21 2002 - 10:48:56 CDT