Solved

Oracle Client Version 7.x, 8.x 8i Compatibility

Posted on 2001-07-19
4
728 Views
Last Modified: 2008-03-17
Hi,

dbrower's response seems to relate to my question.  Here's my story:

I work in a large enterprise that runs several Oracle based applications.  All apps must peacefully co-exist on a single NT 4.0 PC workstation.   All PC based Oracle clients access a shared Oracle home located on a network drive.  (i.e. All Oracle apps on the PC are configured to look at a single NT registry key Oracle_Home = X that defines the network directory in which all Oracle client components are stored.)  Presently, applications using Oracle client versions 7.x and 8.X are running off the shared Oracle home.  A new application running 8i is to soon come on line.  My task is to upgrade the shared Oracle home in such a fashion as to add function of the 8i client while retaining function of the 7.x and 8.x clients.

 I first attempted to "upgrade" the shared home by directing the 8i installation program to install into the directory that holds the 7.x and 8.x components.  This attempt failed because I "attempted to install into an Oracle home that was created with an older, incompatible version of the Oracle installer."   OK. That seems straight forward.  It doesn't work that way- I'll try something else.

I then installed all 8i components into a separate directory and replaced the older shared home.

I wound up with an 8i home out of which I can successfully tnsping all databases, 7.x, 8.x and 8i Oracle versions.  An application requiring an 8i client connects to its database and runs properly. However, an application running Oracle version 8.0.5.2.1 cannot connect its database.  The failing app returned Oracle error ORA-12154.  

I am under the impression that 8i is backward compatible and should support the earlier Oracle client versions.  Am I wrong on that?  Is there some specific manner in which I should build an 8i home that will also support the earlier Oracle clients?  Any other suggestions?

Thanks for considering this question,
Jay Johnson



Thanks,
Jay Johnson
0
Comment
Question by:jjohnsn
4 Comments
 
LVL 2

Expert Comment

by:jbever
ID: 6298726
No, not that i know off.
j.
0
 
LVL 3

Expert Comment

by:UsamaMunir
ID: 6298758
Hi!
No You need seperate Oracle homes for all of them. Each home has  required support files with it, the old software can't use the new one, and the new software can't use the old ones, hence you need a sepearate home for all of it.

Regards
UsamaMunir
0
 
LVL 1

Expert Comment

by:saschek
ID: 6299087
BTW this is the reason why multiple HOMEs are a big advantage for developers!
0
 
LVL 1

Accepted Solution

by:
dbrower earned 50 total points
ID: 6299203
It is true that each version will require a separate home as stated above. However, in most instances the newer version of the client is backwards compatable to the database (if properly configured). The Oracle 8.1.6 client will work with a 7.3 or 8.0 database.

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to take different types of Oracle backups using RMAN.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now