Home » Infrastructure » Unix » Upgrade from 8.1.7.2 32-bit to 9.2.0.3 64-bit on Solaris 5.8
Upgrade from 8.1.7.2 32-bit to 9.2.0.3 64-bit on Solaris 5.8 [message #98237] Fri, 21 May 2004 00:52 Go to next message
AK
Messages: 7
Registered: July 2001
Junior Member
Hi,

I have directly upgraded the database from 8.1.7.2 (32-bit) to 9.2.0.3 (64-bit) on Solaris 5.8. I have performed the following steps:

a. Install 9.2.0.1 software

b. Upgrade 9.2.0.3 patch

c. Run u0801070.sql

I have read elsewhere there are different comments on direct upgrade and having to run word-size (utlirp.sql). I would like to check whether

a. My upgrade path is correct?

b. Do I need to run script to change word-size or it is done from u0801070.sql?

Thanks for any help,

AK
Re: Upgrade from 8.1.7.2 32-bit to 9.2.0.3 64-bit on Solaris 5.8 [message #98310 is a reply to message #98237] Tue, 13 July 2004 09:21 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Yes you path is correct. In fact the 'word' change occurs when you install the base Oracle, which is 64 bit.

Points:
1. Make sure you have a 64-bit hardware to support the App.
2. Make sure you install the 64-bit Oracle 9.2.0 base installation (will be diff CDs)
3. Get patch for the 64-bit Oracle 9.2.0.3. Infact I think patch 5.0 is out (not sure on that)

Yes you do have to run utlirp.sql. The main difference is that this script INVALIDates all objects and then compiles (VALIDates) them, so make take some extra time.

I am pretty sure you have researched Metalink on this, coz you are talking about utlirp.sql....

I upgraded 8.1.6 (32) to 8.1.7 (64) in AIX 4.3.3 env. Then later again 8.1.7 (64) to 9.2.0 (64). And in fact I again did 9.2.0 (AIX 4.3.3) to 9.2.0 (AIX5L). All works fine.
--
Sanjay
Previous Topic: pls send 1507768 patch
Next Topic: ORA-12545 error on startup nomount
Goto Forum:
  


Current Time: Sun Sep 27 02:54:40 CDT 2020