My Oracle220.127.116.11 is installed on linux server. My Biztalk2006R2 is installed on Windows Server 2003 R2 x64. I have already installed BizTalk Adapter for Oracle on the Biztalk server and now require to install Oracle Client to make Biztalk able to retrieve data from Oracle18.104.22.168 using the oracle client.
From the following link,
I came to know that the only oracle clients compatible with Biztalk adapter for oracle are as below:
1) Oracle client 8i
2) oracle client 9i
3) oracle client 10i
Now I need to install an oracle client on biztalk server in order to make biztalk talk to oracle and retrieve data from it. Question1: which of the above clients should i install on biztalk server that is compatible with both Oracle22.214.171.124 as well as Biztalk server 2006 R2? Question2: How to install and configure this client to make it work correctly?
The 10g (there is no such thing as 10i) client can talk to an 11 server, so that's going to be the one you want since Biztalk also supports it. You're probably going to have to ask on a Biztalk forum for help setting that up if it's anything beyond "create an ODBC connection".
The Biztalk Adapter interface with Oracle software has information, requirements per referenced document that does not make sense.
E.g. "10i" does not exist and the requirement "Oracle ODBC driver 126.96.36.199.4" means that only 9.2 Client can be used. (Mixing parts from one Database Client product version with another version is not allowed/supported/certified.)
Btw, does that machine happen to have Itanium hardware? (probably no, since you stated x64)
For Oracle's OS requirements, 2003 was certified with/from 188.8.131.52 (and likely also terminal patch set version 184.108.40.206). Not sure about Server 2003 R2, 32 or 64-bit. I'm pretty sure 10.2 was certified on 2003 R2, but the note likely refers to 10.1 versions (before it was known it would be labeled 10g, g for grid replacing the i ).
This FAQ may have some more information: http://www.oracle.com/technetwork/database/windows/faq-100614.html
For Oracle client - server interoperability and certification, there's a support matrix on MOS. See doc id 207303.1.
It seems 9.2 is supported on the wire to operate with 11.2 server, but Client with at least patch set 220.127.116.11 is required.
So, I guess best bet is to find updated requirements.
If you manage to get hold of 18.104.22.168, after verifying that 2003 R2 is ok, then it looks like the puzzle could be put together for a complete picture.
For ease of install, take a look at the Instant Client. (However, there's no 9.2 IC, that type of client install came later)
some corrections, specially about 9.2 version