Database Oracle 7 open with 8.1.6 client

Michael,

I had this problem with needing to mix O7 and O8 in the past and Oracle support advised the following :

install O7 first.
install O8 into the SAME oracle home as O7.

This causes any O7 dlls to be overwritten by the O8 ones - but this is ok, because they will still be compatible. Any new dlls required for an O8 connection will not affect the O7 stuff.

You might need a TNS_ADMIN key in HKLM/Software/Oracle but as they are using the same oracle home, I doubt it.

You need to use the O8 listener for both.

Hope this helps,

Norman.

PS. If you totally get rid of O7 and just install O8, then you can still access O7 databases. I have 33 separate instances to look after some O7 and some O8 and I have only the O8 client installed on my NT workstation. All you have to do is make sure that the O7 details are configured into the O8 tnsnames.ora file and all should be well.

ND

-----Original Message-----
From: MICHAEL GILLET [mailto:michael.gillet_at_waika9.com] Posted At: Thursday, January 18, 2001 9:14 PM Posted To: tools
Conversation: Database Oracle 7 open with 8.1.6 client Subject: Database Oracle 7 open with 8.1.6 client

Hello,

I'm currently using PHP 4.0 on windows NT to access in different oracle servers (one is oracle 7 database and the second one is oracle 8).

I must access at the same time on a Oracle 7.3 and an oracle 8.0.5 database.

With PHP4, the client 8.1.6 is required to access on Oracle 8.x.x database
but with this version i don't manage to open my oracle 7.3 database.

Do you have an idea to solve the problem ?

Thanks per advance

Michael Received on Fri Jan 19 2001 - 17:46:05 CET