ORA-12560: TNS:protocol adapter error

[ralle1]

Dear Devart Team!

One of my customer has the following problem:
When trying to connect to the oracle database with TOraSession, the following error occurs:
“ORA-12560: TNS:protocol adapter error”

I just can’t reproduce this error on my development environment, so I hope you can give me a hint how to solve this problem.

The software is written in Delphi 2007 and I’m using Devart ODAC 6.90.0.60 for Delphi 2007 for Win32.

The customer uses the following hardware:
Client:
- Citrix 4.5 Server on Windows 2003 Server (32Bit) (Dual Xeon, 4GB Ram, 30GB VDisk)
- ORACLE 10g Client

DB Server:
- ORACLE 10g Real Applikation Cluster


Many thanks in advance for your help!

[AlexP]

hello,

There are rather a lot of reasons for this error occurrence. For eaxample, enabled FireWall, incorrectly set records in tnsname.ora or in sqlnet.ora. To localize the error. Try connecting to the Oracle server using a standard SQLPlus application. If you get the same error - this problem is client-side.

[ralle1]

Thank you for your tipps. We will try it with an SQLPlus application.

I forgot to mention that we already tried to connect with an older Delphi BDE Application which is using TDatabase/TQuery (BDE native Oracle Driver). This Application connects without problems on the same environment. can you explain that?

Thank you !

[ralle1]

I've got some further information:

1. The Applications connects without problems on a windows client, the problem just occurs on citrix.

2. They can't start SQLPlus on Citrix. But the Tool "Toad for Oracle" runs on citrix and it connects without problems.

Please help me.

[AlexP]

hello,

Unfortunately, we haven't tested our products on Citrix 4.5 Server, however, if the application can connect to Oracle from Windows, then most possibly the problem is due to the Citrix settings directly, since work with Oracle client libraries runs equally.