
	Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Best approach for upgrading from 8i to 10g

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Best approach for upgrading from 8i to 10g

EXPERT RESPONSE FROM: Maria Anderson

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 30 August 2005
Later this year we will be undertaking upgrades for a client from Oracle 8i to Oracle 10g on Solaris platforms.
Currently we are running the Oracle 8.1.7.4 Enterprise Edition database product, Oracle Reports Server 2.5 with Apache 2 (compiled independently).
We are not looking to add extra functionality, only a straight upgrade to 10g.
These upgrades will be done in-situ on single servers, i.e., there will be no staging servers used.
Can you advise us on what components of Oracle 10g and IAS we need to install as a minimum, as well as the best approach for upgrading? We have attempted this successfully last year on a test server but we imported an 8i DB to a 10g DB shell. We probably won't have that luxury on some 8i servers requiring the upgrade.

Any assistance would be greatly appreciated!

It would be difficult for me to say which components you should install since I have no information about your environment or which products are currently utilized. The one thought that does occur to me about your upgrade strategy is that you should test this upgrade in your non-production environment in the exact same manner that you are planning to do it in production. You had mentioned testing this by performing an export/import, yet, in production, the plan is to upgrade in place. If the plan is, in fact, to upgrade in place, I would test this several times in a non-production environment. Upgrading from 8i to 10g is a pretty big step so you will want to test the entire process several times if possible.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Oracle database installation, upgrades and patches
	Oracle's Java database continues push into embedded database market
	How to use the Oracle Database Upgrade Assistant (DBUA)
	Oracle delivers database fixes in Critical Patch Update
	How to get the most out of Toad for Oracle 10
	Coca-Cola Bottling swaps out Oracle for DB2
	Oracle renews push into embedded open source software market
	Oracle releases new database, says 11g upgrade will cut costs
	Comparing servers for Oracle database 11g upgrades
	Choosing the right server hardware is all about choosing the right software
	The best of the Oracle 11g-ready servers

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
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Oracle White Papers: Fusion Middleware

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2003 - 2009, TechTarget \| Read our Privacy Policy