You can upgrade to 64-bit 9.2 from 8.1.7.4 32-bit even though Oracle says you have to do the 32-bit to 64-bit conversion separately. We went from 8.1.7 (32-bit) to 9.2.0.1 (64-bit) on Solaris without having to go to 9.2.0.1 (32-bit). Oracle's official position is that you can do directly but it's not supported. If you want to save yourself some time, then try going directly from 8.1.7.4 32-bit to 9.2 64-bit on a dev environment first to see if it works. Just remember to run $ORACLE_HOME/rdbms/admin/utlirp.sql as a final step. Also, document any invalid objects prior to upgrade process so that you know what was invalid to begin with.
A couple of gotchas to watch out for: Need to drop any Ixora views X_$... except for X_$KSPPI, X_$KSPPSV, and X_$KSQST (these are used by statspack). Going from 32-bit to 64-bit, you'll have to adjust shared pool accordingly. The following Metalink notes are helpful: 62290.1 and 209766.1. Keep in mind that these notes will also say that you have to do the 32-bit to 64-bit conversion separately. HTH, Gerardo -----Original Message----- Sent: Thursday, May 29, 2003 2:05 PM To: Multiple recipients of list ORACLE-L We currently have a database on Solaris 8. The database is 8.1.7.4 32-bit. The vendor wants us to upgrade to 9.2 and change to 64-bit. In reading the documentation from Metalink, I find that I have to do the upgrade seperate from the change to 64-bit. Does anyone have any recommendations for the order of this. Should I change 8.1.7.4 to 64-bit and then upgrade to 9.2? Or should I upgrade to 9.2 and then switch to 64-bit. Any insights, horror stories, etc. are appreciated. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
