OraFAQ Forum: Windows » TNS: protocol adapter error

Home » Infrastructure » Windows » TNS: protocol adapter error (Oracle, 10g Express Edition, Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS: protocol adapter error [message #378189]

Mon, 29 December 2008 05:14

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

Report message to a moderator

Re: TNS: protocol adapter error [message #378196 is a reply to message #378189]

Mon, 29 December 2008 05:42

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.

Report message to a moderator

Re: TNS: protocol adapter error [message #378225 is a reply to message #378196]

Mon, 29 December 2008 06:25

clourenco
Messages: 4
Registered: December 2008

Junior Member

Thank you tahpush, but we've already done that.
Any more sugestions?

Thanks again.

Report message to a moderator

Re: TNS: protocol adapter error [message #378230 is a reply to message #378189]

Mon, 29 December 2008 06:36

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

clourenco wrote on Mon, 29 December 2008 12:14

Are you sure that your connect string should end with a semicolon ";"
Looks a bit strange to me

Report message to a moderator

Re: TNS: protocol adapter error [message #378250 is a reply to message #378230]

Mon, 29 December 2008 08:24

clourenco
Messages: 4
Registered: December 2008

Junior Member

It makes no difference.
But once again, thanks.

Report message to a moderator

Re: TNS: protocol adapter error [message #378258 is a reply to message #378250]

Mon, 29 December 2008 08:59

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>

Report message to a moderator

Re: TNS: protocol adapter error [message #378265 is a reply to message #378258]

Mon, 29 December 2008 10:55

clourenco
Messages: 4
Registered: December 2008

Junior Member

Yes i can tahpush.

Report message to a moderator

Previous Topic:	could not install oracle
Next Topic:	Oracle V11 on Windows Vista x64

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 06:20:13 CDT 2025