Re: Cannot connect to DB error

2002-06-14 Thread KENNETH JANUSZ 

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 [EMAIL PROTECTED]
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.1localhost (original entry)
 
  127.0.0.1DC0X4411 (Oracle generated name for KEN db manually added)
 
  127.0.0.1PARTS (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: [EMAIL PROTECTED]

 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Cannot connect to DB error

2002-06-13 Thread KENNETH JANUSZ 



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

Re: Cannot connect to DB error

2002-06-13 Thread Joe Testa 

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.1localhost (original entry)

 127.0.0.1DC0X4411 (Oracle generated name for KEN db manually added)

 127.0.0.1PARTS (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).