| 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  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
