Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> upgrade question

upgrade question

From: Sweetser, Joe <Joe.Sweetser_at_infocrossing.com>
Date: Thu, 10 Aug 2006 10:11:32 -0700
Message-ID: <5CF4A34EE1FEA144B7474DC97E2F73A9D1BDE5@MAPI.iconnection.com>


Wanting to go from 32-bit Windows 10gR1 to 64-bit Windows 10gR2.

Saw this in the upgrade manual:

If you are installing 64-bit Oracle Database 10g software but were previously using a 32-bit Oracle Database installation, then the databases will automatically be converted to 64-bit during the upgrade to Oracle Database 10g except when upgrading from Release 1 (10.1) to Release 2 (10.2).

Note:
The process is not automatic for the release 1 to release 2 upgrade, but is
automatic for all other upgrades. This is because the utlip.sql script is not run during the release 1 to release 2 upgrade to invalid all PL/SQL objects. You must run the utlip.sql script as the last step in the release 10.1 environment, before upgrading to release 10.2.

All fine and dandy. Here's my question: Can I install 10gR1 64-bit on the new server, copy a cold backup over from the 32-bit system, bring up the database, run the utlip.sql script and then proceed with the upgrade. I have a TAR (er, uh, SR) open with Oracle about this but figured I'd ask here too. If not, I can probably find space on 32-bit 10gR1 server but that would double my copying and it's a fairly large database.

Thanks,
-joe
--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 10 2006 - 12:11:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US