bobde6_at_hotmail.com (Bob) wrote in message news:<9cae39d7.0411230129.17d5ed81_at_posting.google.com>...
> Eberhard Niendorf <eberhard.niendorf_schrott_at_t-online.de> wrote in message news:<cnt89j$uor$05$1_at_news.t-online.com>...
> > Bob wrote:
> >
> > > Hi I would much appreciate help
> > >
> > > We have a 150-200GB database on Oracle 8.1.7 which resides on a HP-UX
> > > 32-bit machine. We are upgrading the HP-UX machine to 64-Bit.
> >
> > Hi,
> >
> > a) Do you want to upgrade Oracle-Software from 32bit to 64bit? On Solaris, I
> > know 32bit Oracle-Software runs also on 64bit Solaris, but I don't know
> > about HP-UX.
> >
> > b) If you want or have to switch to Oracle 64 bit, then use can use the new
> > 64bit oracle software on the "old" database, but you have to recompile all
> > PL/SQL-procedures, no more. No exp/imp is necessary.
> > - install 64bit Oracle-Software in a new $ORACLE_HOME
> > - switch all environments to 64bit oracle and use it now
> > - sqlplus "/ as sysdba"
> > sql> startup restrict
> > sql> @?/rdbms/admin/utlirp;
> > sql> shutdown immediate
> > sql> startup
> > sql> @?/rdbms/admin/utlrp;
> > sql> exit;
> >
> > --> ready!
> >
> > Eberhard
>
> Thanks for the quick reply
>
> a) Yes we are upgrading the Oracle Software to 64-bit
>
> b) What I would like to do is use the backup of the database on the
> HP-UX 11.00 32-Bit machine (cold backup in this case) and use it on
> the HP-UX 11.00 64-bit machine. I have been told by our unix team
> that we can't use a 32-bit oracle backup of the database on a 64-bit
> version of Oracle. Is this correct ?
It is.
32-bit and 64-bit filesystems are not compatible.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Nov 23 2004 - 09:36:48 CST
