Ask the Expert

Questions about Oracle 9i to Oracle 10g upgrade

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: