Re^3: connecting toOracle7 and Oracle9 simultaneously

Disclamer: I haven't tried this with DBD::Oracle so I could be all wet.

At work we regularly connect to oracle databases of one version using clients of a different version (i.e. connecting to a 9i or 10g database using an 8 client). The only issue that I seem to recall was trying to access new 8i functionality with an older (7.2 I think) client.

As for which clients should work with which databases, there's a "Oracle Client / Server Interoperability Support" matrix out on the Oracle metalink site. Additionally, this note may also help clarify the OCI question a bit.

Hope that helps.

Comment on Re^3: connecting toOracle7 and Oracle9 simultaneously

Replies are listed 'Best First'.
Re^4: connecting toOracle7 and Oracle9 simultaneously by jhourcle (Prior) on Jun 03, 2005 at 18:35 UTC
The links only help those of us who have accounts on metalink, which is only available to people who know their company's support contract info with Oracle. (and I don't currently work for a company with a CSI) I've used 9.2 client to connect to an 8.1 database, and an 8.1 client to connect to a 7.3.4? (was 7, definately... for some reason, 7.3.4 comes to mind), and I know there are settings in the server so that you can allow older versions of the client to connect, but I don't know how severe the penalty is for doing it in 9.2	[reply]
Re^5: connecting toOracle7 and Oracle9 simultaneously by gsiems (Deacon) on Jun 03, 2005 at 19:30 UTC
Hmmm... too true regarding metalink availability (of course having metalink availability doesn't mean that you can actually find what you're looking for on metalink-- or if you did find it once that you'll ever find it again). Fortunately (in this case) Google to the rescue. WRT the OP, I guess I'd try compiling DBD::Oracle against either the 8.1.7 or 7.3.4 client and then try fauria's suggestion.	[reply]