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

dominica_l_at_yahoo.com (Dominica Leung) wrote in message news:<5f8af180.0207261428.268a0c22_at_posting.google.com>...
> 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.
>
> Thanks in advance,
>
>
> Dominica

You also may want to search the Metalink regarding an issue which relates to migrating a dump file between platforms (typically 32 bit to 64 bit) that have different byte order "little Endian or Big Endian". I don't know if Solaris 2.6 and 2.8 have different byte order but if it is, then you can search the article on Metalink using keyword "Endian". I read this article a while back and don't have the DocID...sorry. -:)

HTH
//Rauf Sarwar Received on Sat Jul 27 2002 - 18:06:43 CDT