Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Upgrade Oracle 8.0.6(32 bits)(solaris 2.6)-> 8.1.7.3 (64 bits) solaris 2.8

Re: Upgrade Oracle 8.0.6(32 bits)(solaris 2.6)-> 8.1.7.3 (64 bits) solaris 2.8

From: Eve Höllwarth <evelyne_h_at_yahoo.de>
Date: Sun, 28 Jul 2002 01:28:05 +0200
Message-ID: <q2a6kukqpsn06vgnreinhuk3tcc4agtu29@4ax.com>


dominica_l_at_yahoo.com (Dominica Leung) wrote

>Hi All,
>
>I am slightly worry about my way of upgrade.
>Would like to double check.
>
>Source: 8.0.6 32 bits on solaris 2.6 (32 bits) platform
>Target: 8.1.7.3 64 bits on solaris 2.8 (64 bits OS)
>
>I am thinking about the following:
>
>1) shutdown oracle
>2) export db
>3) also cold backup db
>4) startup oracle, and run upgrade to 8.1.7. 32 bits on
>solaris 2.6 32 bits.
>5) pre-install solaris 2.8 (64 bits) on another new machine
>6) install oracle 8.1.7. 64 bits software on that new machine.
>7) shutdown source db
>8) copy all the dbf file to the new machine
>9) ??? this is the part, I want to make sure.
>I could copy the 8.1.7 32 bits dbf file to the new
>machine, I would like to make sure for the 8.1.7.2 64 bits
>server could read the 32 bits dbf datafiles.
>10) run @utlirp.sql to recompile the packages in the oracle
>server in 64 bits.

In short words: Grab Note:133920.1 from metalink, read it and also read the migration guide located in your oracle documentation. Shutdown your database and make a cold backup. Install oracle binaries 8.1.7 64 bit on the new host (don't forget to set the semaphores for 8.1.7 64 bit), copy your datafiles, init<SID>.ora, passwordfile to the new host. Then do the migration from 8.0.6.x to 8.1.7 on the new host. After that upgrade your oracle binaries and your instance from 8.1.7 to 8.1.7.3 (why not 8.1.7.4 - the latest patchset?). If it is possible test migration and upgrade with a small test instance before you migrate your production system

kind regards
Eve Received on Sat Jul 27 2002 - 18:28:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US