Oracle migration

You may want to review metalink doc id 188061.1 entitled "Upgrading Directly to an 8.1.7 Patch Set". We followed this for an 8.1.6.0 upgrade to 8.1.7.4. on Solaris.

However, this does require setting up a new oracle_home. A summary of the steps are:

1. Install the base 8.1.7.0.0 directory tree in a new oracle home. Do NOT use the installer program to upgrade/migrate your existing database, and do NOT create a new 8.1.7.0 database.
2. Download the patch, unzip it, untar it. Use the installer to apply the patch to the new oracle_home.
3. Upgrade the old database to the new database; basically, you copy the old init.ora to the new oracle_home, startup restrict, run the appropriate upgrade script.
4. Clean-up: move all datafiles, rbs, redo, control, dump dirs, from old oracle_home to new oracle_home.

This wasn't simple. We practiced this procedure on two test instances before we upgraded our production instance, but it worked OK.

We did run into two problems after upgrading. ORA-00164: autonomous transaction disallowed within distributed transaction. Search metalink for ORA-000164 if you'es using pl/sql code with autonomous/distibuted transactions.
The other problem happened because we changed character sets to WE8ISO8859P1, and did not have NLS_LANG defined in our export scripts. This resulted in EXP-00041, but was easy to fix by defining NLS_LANG.

Hope this helps.

>>

Ken:

My Two Cents'...

It seems to me that you're gonna have to install the 8.1.7.0.0 code in order to apply the 8.1.7.2 patch. So where's the problem? You install 8.1.7, upgrade the DB, apply the .2 patch, and it's Miller Time.

Cheers,
Mike

-----Original Message-----
Sent: Thursday, July 18, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L

List,

One of the DBA's here needs to migrate a fairly sizeable database from 8.1.6.0 to 8.1.7.2 on Solaris. The doc's state that it is advisable to migrate to 8.1.7.0 and then go to 8.1.7.2 but we don't have 8.1.7.0 installed and don't want to install it unless we really have to. Anyone know if it is possible to migrate directly to 8.1.7.2 (docs don't explicitly say it can't be done but don't seem to suggest it either).

Ken

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Becker
  INET: beckerb_at_mfldclin.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).