RE: Upgrading from 8.0.5 to 8.1.7 - Please help

This is all covered in great detail in the 8.1.7 Migration Guide - Chapter 7 titled "Upgrading from a Previous Version 8 Release to the New Oracle8i Release"

There is no need to install 8.0.5 on the target server.

Just load the cold backup files, adjust init.ora and follow the steps from the guide.

Take another cold backup after the upgrade is done.

BTW, Oracle calls this an Upgrade, not a Migrate... :)

• Kirti

-----Original Message-----
Sent: Tuesday, February 12, 2002 11:44 AM To: Multiple recipients of list ORACLE-L

This is definitely not a production db. I was just told by Oracle that it is possible to migrate the 8.0.5 datafiles using 8.1.7 software. They say I do not need to install 8.0.5 on the "new" server. Finding instructions in a document covering this is not easy! -fs

>From: Rick_Cale_at_teamhealth.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Upgrading from 8.0.5 to 8.1.7 - Please help
>Date: Tue, 12 Feb 2002 09:08:34 -0800
>
>
>Obviously this WAS not a production database.
>If you were not aware that a new OS was being installed and that Oracle was
>being wiped out then
>step 1 Get a competent SA
>
>I do not know UNIX but I would think you have to
>re-install 8.0.5,
>do backup
>restore 8.0.5 datafiles,redo,controlfiles,etc.
>Modify controlfile to point to restored files
>
>Once database is started then you can proceed to upgrade to 8.1.7
>
>I do not think you can do
>"can I simply install 8.1.7 and perform a migration using
>8.1.7 on the old 8.0.5 datafiles?"
>
>Rick
>
>
>
> "Fred Smith"
> <fred_fred_1_at_ho To: Multiple recipients of
>list ORACLE-L <ORACLE-L_at_fatcity.com>
> tmail.com> cc:
> Sent by: Subject: Upgrading from
>8.0.5 to 8.1.7 - Please help
> root_at_fatcity.co
> m
>
>
> 02/12/2002
> 10:28 AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
>Hello list,
> I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the
>old
>
>8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of
>the database. The SA then did a rebuild on the server to upgrade the OS to
>
>SunOS 5.8. There is no Oracle software or data on the server now.
> My question is: Now that I want to go to 8.1.7, do I have to first
>install 8.0.5 and bring the database up prior to installing 8.1.7 and
>upgrading, OR ... can I simply install 8.1.7 and perform a migration using
>8.1.7 on the old 8.0.5 datafiles? How does this work?
>
>Thanks in advance,
> -Fred S.
>
>_

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

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).