Home » Infrastructure » Windows » TNS: protocol adapter error (Oracle, 10g Express Edition, Windows Server 2003)
TNS: protocol adapter error [message #378189] Mon, 29 December 2008 05:14 Go to next message
clourenco
Messages: 4
Registered: December 2008
Junior Member
Greetings.
I'm currently working on a project that makes use of Oracle 10g Express Edition version, it is installed in a virtual machine running Windows Server 2003 and out of the domain we work on.
The application we are developing is a asp.net application and when we try to launch it, it gives us the error:

System.Data.OracleClient.OracleException: ORA-12560: TNS:protocol adapter error.

We are able to execute tnsping, we are able to connect via sqldeveloper and toad, even with a .udl file we are able to successfully establish a connection.
We are not using tnsnames.ora to make the connection, we have it all specified in the web.config file, like this:

<add name="SiteOracle" connectionString="User Id=eap;Password=EAP123;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.50.8.38)(PORT=1521))(CONNECT_DATA=(SID=XE)));"/>

We've already doubled checked everything, and apparently cannot find a reason why this is happening.
So we are asking for your help to identify the problem and possibly fix it.

Thank you.
Kind regards.

César Lourenço
Re: TNS: protocol adapter error [message #378196 is a reply to message #378189] Mon, 29 December 2008 05:42 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Im not an ASP programmer, but if this is an web application.
Verify that the your ASPNET account(security settings)has privileges on the oracle client , home and bin directories.
Re: TNS: protocol adapter error [message #378225 is a reply to message #378196] Mon, 29 December 2008 06:25 Go to previous messageGo to next message
clourenco
Messages: 4
Registered: December 2008
Junior Member
Thank you tahpush, but we've already done that.
Any more sugestions?

Thanks again.
Re: TNS: protocol adapter error [message #378230 is a reply to message #378189] Mon, 29 December 2008 06:36 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

clourenco wrote on Mon, 29 December 2008 12:14

<add name="SiteOracle" connectionString="User Id=eap;Password=EAP123;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.50.8.38)(PORT=1521))(CONNECT_DATA=(SID=XE)));"/>



Are you sure that your connect string should end with a semicolon ";"
Looks a bit strange to me
Re: TNS: protocol adapter error [message #378250 is a reply to message #378230] Mon, 29 December 2008 08:24 Go to previous messageGo to next message
clourenco
Messages: 4
Registered: December 2008
Junior Member
It makes no difference.
But once again, thanks.
Re: TNS: protocol adapter error [message #378258 is a reply to message #378250] Mon, 29 December 2008 08:59 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Just curious
Can you start sqlplus from the cmd prompt by using sqlplus "user/psw@youconnectstring"

ex.
H:\>sqlplus "scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lfd)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=e1.lfd)
))"

SQL*Plus: Release 10.2.0.1.0 - Production on Mo Dec 29 15:53:15 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>
Re: TNS: protocol adapter error [message #378265 is a reply to message #378258] Mon, 29 December 2008 10:55 Go to previous message
clourenco
Messages: 4
Registered: December 2008
Junior Member
Yes i can tahpush.
Previous Topic: could not install oracle
Next Topic: Oracle V11 on Windows Vista x64
Goto Forum:
  


Current Time: Thu Mar 28 07:58:53 CDT 2024