I am facing a wierd issue. When I am trying to connect to oracle through SQLPlus from my laptop, I receive a ORA-12541: TNS:no listener error. The wierd thing is I could connect oracle thorugh Toad and its working fine. Also other applications(Siebel) are able to find tnsnames.ora and connect to the database.

I have installed and uninstalled Oracle multiple times and i recieve the same error. I am using the same tnsnames.ora thats used by my other team mates, which is working fine for them.

I'm assuming your using Windows. What are the values for your PATH and ORACLE_HOME environment variables?

They should point to the location you installed the client and under which your tnsnames.ora file is located.

11-07-2006, 01:46 PM

s_premkumar

Thanks for the response.

Yes I am using windows client and the following are the details:
Path=C:\oracle\product\9.2.0\client_3\bin
ORACLE_HOME=C:\oracle\product\9.2.0\client_3 (Infact I created this ORACLE_HOME variable since it was not installed default, but still toad was working).

Thanks

11-07-2006, 01:54 PM

KenEwald

Well, one thing is sure, Toad is not using the same connection driver.

Can you ping the host listed in your tnsnames.ora file?

Both client and server are 9.2.x, right?

11-07-2006, 02:11 PM

s_premkumar

I can ping the host listed in tnsnames.ora and only thsping gives me the same error.

The server version of Oracle is 10.2 and every one in the team is using Oracle 9.2.x client to connect since its compatable with Toad (the version we use) and everybody else is able to connect.

11-07-2006, 02:50 PM

KenEwald

Something is different!

Maybe I'm smokin crack here, but it looks like the server rejected the request (according to Oracle's published error text):

ORA-12541: TNS:no listener
Cause:
The connection request could not be completed because the listener is not running.
Action:
Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file.

11-07-2006, 03:22 PM

s_premkumar

Is there a way that we can track as what exactly is going wrong apart from the normal tracing?

11-08-2006, 04:54 AM

Bore

Is the database installed on your laptop or it is on another machine (server).
The TOAD maigth connect using other protocol or if it is TCP/IP the port where the listener listens could be different.
Log to the server and issue
lsnrctl status
(If it is windows do it in dos window)
see where exactly the listener listens ( protocol host port) and fix that in the tnsnames.ora

Good Luck

11-08-2006, 04:56 AM

Bore

I even see the error in your trace
port resolved to 1522

Usually the listener listens on 1521

Change that in the tnsnames

11-08-2006, 03:20 PM

s_premkumar

the database is running on a different box and the port is configured to listen only at 1522. The listerner is up and running and I could connect with the same tnsnames.ora from other client machines as well.