Solved

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

Posted on 2001-07-19
4
735 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
dbms_crypto.decrypt   errors out 6 40
error doing substr 3 33
Oracle Query to Find number of process consumed by a session 15 52
return value based on substr 10 44
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

679 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