Home > Ask the Oracle Experts > (Archive) Database Installation and Upgrade Questions & Answers > Upgrade gotchas
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Upgrade gotchas

Dan Norris EXPERT RESPONSE FROM: Dan Norris

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 21 March 2005
We are researching upgrading to a 10g for database and developer tools. The database is currently 8.0.6 and we use Oracle Forms 5.0.6.8.0; Oracle Reports 3.0.5.8.0; and precompile Pro*C/COBOL programs with the 8.0.4.4 environment. There appears to be quite a bit of information on the database upgrade. I am looking for Forms and Reports data as well as Pro*C and Pro*COBOL. The platform is currently AIX 4.3.3 ML11 and we will be upgrading to AIX 5.2.5 prior to the database upgrade. Are you aware of good reference materials? Are there any land mines I should be concerned with? Is this possible? Would going to 6i or 9i for Developer be an option if 10g is not?

>
EXPERT RESPONSE
The biggest concern I would have for this undertaking is the application using precompilers. While your Forms and Reports versions are also quite dated, there is a migration tool that can be used to upgrade them. The applications relying on a precompiler may likely see their API interfaces change (possibly multiple times) between 8.0.4 and 10.1.0. Don't get me wrong, the other components pose some significant risks as well, but any problems found with them should be easily addressed.

With so many changes to be made at once, testing will be the most important part of your project. The desired environment will need to be created and tested thoroughly by the end users of the application(s). Additionally, if all functionality tests out fine, some load testing should be conducted on both the current (for a baseline comparison) and new/test versions. It is certain that some of the SQL statements will have very different execution plans and some of them may not perform well.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
(Archive) Database Installation and Upgrade
Starting database automatically
Database Upgrade Assistant error
9.2 versus 9i
Empty error dialog window from the Database Configuration Assistant after install
Looking for 8.1.7 as stepping stone to 9.2
Command-line installation of 8.1.7?
Oracle 10g migration guide
Oracle 7.0 vs. higher Oracle versions
Export and import
Oracle migration problem

Oracle database installation, upgrades and patches
Oracle extends Real Application Testing to 10g, 9i
Third-party Oracle database tools remain an attractive option
Enterprise search a key component of Oracle portal project
Oracle Enterprise Manager leverages multiple environments for pharmaceutical giant
Oracle 11g upgrade veteran offers step-by-step advice
Oracle Database 11g gets early use at Burlington Coat Factory
Oracle database upgrades require soul searching
With software upgrades, pain leads to gain
How do I do that in Oracle?
The Oracle Database user's guide to Oracle OpenWorld 2007

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
10g  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2003 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts