upgrade question

  • From: "Sweetser, Joe" <Joe.Sweetser@xxxxxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 10 Aug 2006 10:11:32 -0700

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: