Problems with incompatible Oracle Clients

[Adelson Smania]

Hi, everybody.

I've face several problems with my customers when they have different Oracle versions in client and server (client 9.2.0.1 with server 10.2.0.3, for instance).

My question: is there any way to became DOA independent of the client version installed in the machine?

 

[Marco Kalter]

A 9.2 client should be able to work on a 10.2 server. What exactly goes wrong?

 

[Adelson Smania]

Hi, Marco.

We have a history of problems that were solved updating the Oracle client from 9.2.0.1 to 9.2.0.7, for instance. Reading Oracle documentation (Metalink 207303.1 Doc, for instance) we see that not all the client/server combinations are valid. That's why I have this concern.

 

[Adelson Smania]

In addition, you can see a discussion in Oracle forums regarding this subject: http://forums.oracle.com/forums/thread.jspa?messageID=2678580

So, to avoid problems, I see the "client / server exact version" as a best practice.

 

[Adelson Smania]

Marco:

Is it possible to do what I want? I mean, make DOA independent of client version installed in the machine, or anything like that?

Thanks!

 

[Marco Kalter]

I don't think so. It seems like an Oracle Client/Server compatibility issue, and Direct Oracle Access can only use the client versions that are installed on the PC.