Home » Developer & Programmer » Precompilers, OCI & OCCI » ORA-12541: TNS:No listener (Oracle 9.2.0.6, XP )
ORA-12541: TNS:No listener [message #417551] Mon, 10 August 2009 03:41
sureshkumar.mtech
Messages: 1
Registered: August 2009
Location: Chennai
Junior Member
I am developing a small tool using Visual c#2005 which is used to get the Oracle Schema version. When I tested it in my machine it works fine. When my boss tested the same in his machine it brings out the message TNS-NO LISTENER. He says listener is running in his machine & says the problem is in the code (He is an Oracle DBA and a well experienced person). The code is just a few lines & I think there is nothing wrong in it. I don't know how to solve this problem. I have tested it in my machine at home, it works good there also.

I am a novice when it comes to Oracle & wondering where the problem could be. Please find below the connection strings I have used so far, all the below mentioned connection strings are working fine for my machine but not for my boss.

1) sconncectin = "Server = Servername; Uid = username; password = password";

2) sconncectin = "provider=MSDAORA;data source=TEST;user id=demo;password=demo123";

3)sconncectin = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOC OL=TCP)(HOST=MYHOSTNAME)(PORT=1251)))(CONNECT_DATA =(SERVER=DEDICATED)(SERVICE_NAME=TEST)));User Id=demo;Password=demo123;";

My boss says the connection method itself is wrong and said not to worry about port, host etc since TNSNAMES is available !!

Wondering how to fix this issue?

Can someone help me out??????
Previous Topic: passing parameters in a dynamic query
Next Topic: pro*c problem
Goto Forum:
  


Current Time: Thu Mar 28 05:35:00 CDT 2024