| TNS: No listener - Help ASAP Please [message #123097] |
Thu, 09 June 2005 18:01  |
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
|
Senior Member |
|
|
Database is running fine. No problem with it. Able to connect using the sqL Plus worksheet, BUT
getting error while connecting from SQLPLUS and TOAD(external software) as ORA-12541 TNS Nolistener.
Checked the TNSnames.ora. looks good.
checked the host file to make sure the IP is correct.
when checked the tnsping, getting the below error.
D:\Documents and Settings\rganti01>tnsping
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 09-JUN-20
05 17:53:59
Copyright (c) 1997 Oracle Corporation. All rights reserved.
TNS-03502: Insufficient arguments. Usage: tnsping <address> [<count>]
D:\Documents and Settings\x0101>tnsping csddb403
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 09-JUN-20
05 17:54:17
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
D:\oracle\ora92\network\admin\sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=csddb403))
(ADDRESS=(PROTOCOL=TCP)(HOST=db495)(PORT=1521)))
TNS-12541: TNS:no listener
Any help is greatly appreciated.
Regards
Ravi
|
|
|
|
|
|
|
|
| Re: TNS: No listener - Help ASAP Please [message #123107 is a reply to message #123097] |
Thu, 09 June 2005 19:17  |
DMcG
Messages: 51
Registered: May 2005
Location: Auckland, New Zealand
|
Member |
|
|
Seeing as you can't get to it using TNSPING, there's probably something wrong with the config files either on the client and/or on the server. Check you hostname, service definitions and your ports to make sure that everything is the same.
Dougie McGibbon
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
