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