Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
> 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).Received on Fri Jun 14 2002 - 09:38:25 CDT
![]() |
![]() |