- 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?
- What's the difference between Oracle 9i Enterprise and Oracle Standard One Edition 10g?
- 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.
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 220.127.116.11. 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.
Dig Deeper on Oracle data and application integration
Related Q&A from Maria Anderson
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading