RE: Cannot connect to DB error

cat $ORACLE_HOME/network/admin/listener.ora cat $ORACLE_HOME/network/admin/tnsnames.ora

and mail to list, will see

> -----Original Message-----
> From: KENNETH JANUSZ [mailto:kjanusz_at_att.net]
> Sent: Friday, June 14, 2002 6:38 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Cannot connect to DB error
>
>
> Joe:
>
> Good question. I checked services and it was not running.
> So I started it. But I still get these errors.
>
> PARTS database - ORA-12541: TNS: no listener
>
> KEN database - ORA-12154: TNS: could not resolve service name.
>
> Any idea what the problem is?
>
> Thanks,
> Ken
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, June 13, 2002 8:03 PM
>
>
> > ok i'll ask the obvious, is the listener running?
> > if so you better go and catch it.
> >
> > joe
> >
> >
> > KENNETH JANUSZ wrote:
> >
> > > I have installed 9.0.1 on my Dell PC with XP Prof.
> > >
> > >
> > >
> > > When I installed it I installed the demo DB and everything worked
> > > fine. Now I have installed a second DB and I cannot connect. I
> > > made changes to listener.ora and tnsnames.ora as recommended by
> > > others on this list.
> > >
> > >
> > >
> > > I also added the IP addresses to the HOSTS file as such:
> > >
> > > 127.0.0.1 localhost (original entry)
> > >
> > > 127.0.0.1 DC0X4411 (Oracle generated name for KEN db
> manually added)
> > >
> > > 127.0.0.1 PARTS (new DB name manually added)
> > >
> > >
> > >
> > > Here is what I get when I try to connect.
> > >
> > >
> > >
> > > KEN database - Oracle generated name is DC0X4411
> > >
> > > ORA-12154: TNS: could not resolve service name
> > >
> > >
> > >
> > > PARTS database
> > >
> > > ORA-12541: TNS: no listener
> > >
> > >
> > >
> > > Any help I can get to solve this problem will be greatly
> > > appreciated.
> > >
> > >
> > >
> > > Thanks much,
> > >
> > > Ken Janusz, CPIM
> > >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Joe Testa
> > INET: jtesta_at_dmc-it.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: KENNETH JANUSZ
> INET: kjanusz_at_att.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: BELOV
  INET: ib_at_monb.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).