OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » TNS: No Listener

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS: No Listener [message #124157]

Thu, 16 June 2005 11:05

pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville

Senior Member

Sorry to post this again in a new thread... .

I have oracle9i client on my laptop.
I am trying to connect to DB server using SQL Plus. get ORA-12541 - TNS: NO listener. I do a tnsping on the dos prompt, I get the same error.

here it is......

D:\oracle\ora92\network\ADMIN>tnsping devl

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 15-JUN-20
05 10:33:48

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = devl)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = devl)
))
TNS-12541: TNS:no listener

D:\oracle\ora92\network\ADMIN>

........ One thing I noticed in the above.....
"Used Parameter files: " is empty ... I don't see the path mentioned...
Where as it correctly picks the tnsnames entry from tnsnames.ora file.

I checked on my machine. There are NO multiple clients other than SQLPLUS...

When I use sqlplus command on dos prompt. it logs in correctly to the database server. DATABASE is running absolutely fine. Using Unix I log in to the database and it works fine.

I am really tired to figure this out and at the same time I am desparete to resolve this.

PLEASE HELP!!!!!
Ravi

[Updated on: Thu, 16 June 2005 11:21]

Report message to a moderator

Previous Topic:	[PHP] ORA-28582: direct connection not allow [URGENT]
Next Topic:	changed the machine IP address on which database reside?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 23:32:04 CDT 2025