| 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 #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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
