OraFAQ Forum: Networking and Gateways » ORA-12541

Home » RDBMS Server » Networking and Gateways » ORA-12541 - TNS: no listener

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

ORA-12541 - TNS: no listener [message #123925]

Wed, 15 June 2005 10:39

pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville

Senior Member

I really need help. Don't know what's wrong and where.
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>

..............

I use sqlplus command from dos prompt and it works.....

D:\oracle\ora92\network\ADMIN>sqlplus test@devl

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jun 15 10:35:41 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL>

.........
But it does not work when I use the SQLPLUS or 3rd party tool TOAD.... it gives me ORA-12541 error.....

I checked everything on my laptop.. don't find anything wrong. DB server is up and running....
there are no listener file in laptop..
There are no multiple tnsnames.ora files

What could be wrong. Can anyone help me please.
Thanks
Ravi

[Updated on: Wed, 15 June 2005 10:40]

Report message to a moderator

Re: ORA-12541 - TNS: no listener [message #123935 is a reply to message #123925]

Wed, 15 June 2005 11:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

seems there are multiple clients installed (sqlplus and toad).
Every client needs its own tnsnames.ora ( if not found by default, create one).
add the tnsentries in the tnsnames.ora (that belongs to the client you want to work with) and try again.

Report message to a moderator

Re: ORA-12541 - TNS: no listener [message #124368 is a reply to message #123935]

Fri, 17 June 2005 14:56

pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville

Senior Member

My firewall was on but invisible. At the very beginging I must have not allowed to connect, and then I forgot that I had firewall in my laptop (which of course feel stupid to forget like that).

I made the firewall visible and changed the setting to allow the SQLPLUS to connect.

It was small but very important thing to remember.

Thanks to all for the help that was provided.

I consider this issue is resolved.
Regards
Ravi.

Report message to a moderator

Previous Topic:	How can I connect client with oracle server
Next Topic:	oracle10g tools long time startup & network problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 23:22:10 CDT 2025