Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Using 11g Client with 10g Database

920779Apr 26 2012 — edited Apr 29 2012
Hi,

We have got a Oracle Database version 10.2.0.3.0 on 64 bit server and client OS is window 7.

I am wondering if i can use 11g Client 11.2.0.1.0 to connect to 10g server? Do i need Client 11.2.0.3.0?

I am running few tests and 10g client works fine but i need to test 11g client on window 7.

I have tried to install 11.2.0.1.0 client but when i access my application i get error saying SQL NET dll not found. I don't know if this is a oracle error or it is related to Oracle Clintrial software which we are currently using.

Is it true that Database and client version should be same becuase someone has mentioned in this fourm about compatability;

"Metalink 207303.1 is the client/server interoperability matrix. If by 11g you mean 11.2 and by 10g you mean 10.1, the 11.2 client will not work with a 10.1 database. If the client is 11.2 and the database is 10.2, it should be at least 10.2.0.2. If the client is 11.1, the database should be 10.1.0.5 or 10.2.0.2 or higher."

Comments

CloudDB
Hi,

Is it true that Database and client version should be same becuase someone has mentioned in this fourm about compatability;
YES

Regards
Hitgon
Helios-GunesEROL
Hi;

Please see:
Master Note For Oracle Database Client Installation [ID 1157463.1]
Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1]

Regard
Helios
806917
Not true. The client version and DB version do not have to match. I still use sqlplusw.exe 10.2.0.5 on my PC and connect to both 10g and 11g databases w no problems.
Mohammed Ali A. Syed
Hi,
Is it true that Database and client version should be same becuase someone has mentioned in this fourm about compatability;
Not true. The Database and client version need not be the same but it should be supported as per document

Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1] (Which you refered above).
"Metalink 207303.1 is the client/server interoperability matrix. If by 11g you mean 11.2 and by 10g you mean 10.1, the 11.2 client will not work with a 10.1 database. "
Here in the document it says not supported. This means if you get any issue Oracle is not going to investigate or provide a solution for you in the above case.

If the client is 11.2 and the database is 10.2, it should be at least 10.2.0.2. If the client is 11.1, the database should be 10.1.0.5 or 10.2.0.2 or higher.
Yes

Thanks
806917
One more comment - the client is incredibly stable. In my 17 years in the Oracle space, I have never logged an SR for a client issue. In general, if your client is within the last couple of major releases, you should not have any problems. Good luck!
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 27 2012
Added on Apr 26 2012
5 comments
6,837 views