Solved

Oracle 9i Client vs. 10g Client

Posted on 2006-10-24
4
10,344 Views
Last Modified: 2013-12-11
I'm a database developer who needs to connect to both Oracle 9i and 10g servers. Which client software would be the best version to use on my development workstation? Are the 9i/10g clients cross-compatible with 9i/10g servers? Would it be possible to have both 9i client and 10g client installed simultaneously and switch between them? If so, how's that done?

Scott.
0
Comment
Question by:JonahGroup
  • 2
4 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17795905
you should always use the most recent client to connect, to ensure full functionality is guaranteed...
hence, use client of 10 version
0
 
LVL 6

Expert Comment

by:chedgey
ID: 17802900
Scott,

I agree with angelIII that you should pick the latest version as backwards compatability (one version) is guarranteed but forwards compatability may cause problems.

To answer your second question: Yes, you can have both 9i and 10g clients installed, just install them under different Oracle homes. When you wish to move between them go into Universal Installer and change the order of the homes which alters your PATH variable. You will have to set up your Oracle Net configuration for both.

Regards

Chedgey
0
 

Author Comment

by:JonahGroup
ID: 17803100
Thanks for the responses. The information I've read seems to agree with both of you -- use the 10g client to connect to new and older versions of Oracle server. However, I've already run into some problems with that strategy. When I attempted to use the "imp" utility on the 10g client to load a 9i server, the tool gagged. Wouldn't do it. When I moved to another machine having the 9i client, it worked fine. So there are hidden compatibility issues, and this is what I want to know about. These issues appear to be undocumented.

Scott.
0
 
LVL 6

Accepted Solution

by:
chedgey earned 125 total points
ID: 17803168
Yes, you have to be careful with imp and exp. Look at the link below to see the details (especially the compatability table) I gave in answer to a similar question yesterday which should help to explain:

http://www.experts-exchange.com/Databases/Oracle/Q_22035595.html#17797217

You should be able to use 9i client for both initial export and subsequent import or 9i client for export tthen 10g client for import. This is one of those annoying little things that Oracle sometimes throw at us. 6/10 could try harder Oracle.

Regards

Chedgey
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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle 11g 23 107
Oracle collections 15 27
Checking for column width 8 29
Migration from sql server to oracle 5 25
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

860 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