Q

Questions about Oracle 9i to Oracle 10g upgrade

We are using Oracle 9i Database on a server with Oracle 9i Client on nodes with third-party software. When we upgrade our 9i server to 10g, can we connect to 10g from our existing 9i client nodes?

I have the following queries:
  1. Does any third-party application running on Oracle 9i Enterprise Edition need to be changed when we migrate from 9i database server to Oracle Standard One Edition 10g?
  2. What's the difference between Oracle 9i Enterprise and Oracle Standard One Edition 10g?
  3. We are using Oracle 9i Database on a server with Oracle 9i Client on nodes with third-party software. When we upgrade our 9i server to 10g, can we connect to 10g from our existing 9i client nodes? Slowly we can upgrade all 9i clients to 10g clients. Otherwise, all the machines in the company need to be changed to 10g client and work will suffer a lot, as this upgrade job cannot be done in a single day.
Please advise.

If you are using third-party applications in your environment that rely on an Oracle database, I would suggest

contacting the vendor prior to upgrading to 10g. First, you will want to ensure that their application(s) is certified on Oracle 10g before you upgrade. Second, the vendor will be able to tell you specifically what will change in an upgrade from Oracle9i to 10g since they are very familiar with their application.

With respect to your question regarding the differences between Oracle9i Enterprise Edition versus Oracle Database 10g Standard One … are you referring to the differences in features? If so, I would recommend reading through the Oracle Database 10g Release 2 (10.2) New Features Guide. Another good reference is the Oracle Database 10g Release 2 (10.2) Upgrade Guide.

Finally, with respect to your question about using Oracle9i client with a 10g database, once again I would contact the vendor of the third-party software you are using and ask this question. Technically, an Oracle9i client will connect to an Oracle 10g (R1 and R2) database provided the client is at least at release 9.2.0.4. The vendor will be able to advise you on whether your clients must be upgraded to Oracle 10g immediately or whether they can stay at Oracle9i and be migrated in phases.

This was first published in April 2007

Dig deeper on Oracle data and application integration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close