Cannot connect to DB error

From: KENNETH JANUSZ <kjanusz_at_att.net>
Date: Thu, 13 Jun 2002 09:53:49 -0800
Message-ID: <F001.0047D720.20020613095349@fatcity.com>

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: 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 Thu Jun 13 2002 - 12:53:49 CDT