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 (don’t 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 Received on Mon Jun 16 2003 - 22:09:31 CDT