Hi Dom!
I think you should install 8.1.7 32 bit oracle first on your 64 bit Solaris
and then move the files to this machine. Once you are able to open database,
close it and take a full backup. Next install 64 bit oracle and open the
database and run run catalog, catproc and utlirp scripts to convert your
dictionary and packages to 64 bit.
hth
santysharma
"Dominica Leung" <dominica_l_at_yahoo.com> 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
Received on Fri Jul 26 2002 - 18:52:50 CDT
