Re: Can't Connect to DB

Hi Ken,

Is your listener started??

That appears to be the case based on this message. Go to your services and see
if the Oracle<orahomename>listener service is started. If not then start this service
and try to connect then. If you are getting an error when attempting to start the
service you will need to go to the dos prompt to get a more meaningful error and attempt to start the service with the command

lsnrctl start

It will probably still not start but you should get a better error.

Good luck,
John Hough

kjanusz_at_att.net wrote:

> Oracle 9i on XP Prof.
>
> DB is on a single PC.
>
>
>
> When I try to do a DB connection I get this error. Yesterday I
> created a second DB on my PC and was able to connect successfully to
> either of them. This morning I rebooted my PC and now I cannot connect.
>
>
>
> Any idea what the problem is?
>
>
>
> TIA,
>
> Ken Janusz, CPIM
>
>
>
> ---------------------------------------------
>
>
>
> ORA-12541: TNS:no listener
>
>
> Details:
> Building Oracle HOMES List
> HOME Name OraHome90 added to list.
> Found multiple homes, searching each HOMEx for valid PATH
> searching in SOFTWARE\ORACLE\HOME0
> Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!
> oci.dll found
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: orantdba_at_netscape.net

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