Re: 32 to 64 Bit Upgrade -- need info
Title: Re: 32 to 64 Bit Upgrade -- need info Munish, Essentially, you can use the same datafiles, controlfiles, and redologfiles. All of the PL/SQL has to be recompiled (including STANDARD and DBMS_STANDARD, which makes the task something of a chicken-and-egg situation)... Short story: you need to set the parameters aq_tm_processes to 0 and _system_trig_enabled to FALSE and then run the script utlirp.sql, which resides in the directory $ORACLE_HOME/rdbms/admin in your software distribution. Longer story: read the MetaLink note on the topic (dont have the number, but search on keyword utlirp.sql) and be aware that the package UTL_RECOMP has a parallel option in addition to the default serial option. You may not have a problem with the elapsed time in most situations, but I did it with OraApps R11i, and it took 7 hours serially! Hope this helps... -Tim on 6/6/03 12:44 AM, Munish Bajaj at [EMAIL PROTECTED] wrote: Hi All, I'd like to get some information on how to upgrade a 9iR2 32 Bit Installation to 9iR2 64 Bit. Can I Upgrade just the software and use the same datafiles and control file etc. or do I need to create a new database again and do export/import of the old database. Thanks and Best Regards Munish Bajaj
32 to 64 Bit Upgrade -- need info
Hi All, I'd like to get some information on how to upgrade a 9iR2 32 Bit Installation to 9iR2 64 Bit. Can I Upgrade just the software and use the same datafiles and control file etc. or do I need to create a new database again and do export/import of the old database. Thanks and Best Regards Munish Bajaj Blank Bkgrd.gif
Re: 32 to 64 Bit Upgrade -- need info
read the migration guide Munish Bajaj wrote: Hi All, I'd like to get some information on how to upgrade a 9iR2 32 Bit Installation to 9iR2 64 Bit. Can I Upgrade just the software and use the same datafiles and control file etc. or do I need to create a new database again and do export/import of the old database. Thanks and Best Regards Munish Bajaj -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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).
64-bit upgrade
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).
RE: 64-bit upgrade
Terry - My principle is always if the database is small enough and the downtime window is large enough, use exp/imp. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 4: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: DENNIS WILLIAMS 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).
RE: 64-bit upgrade
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).