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
- Yes we are upgrading the Oracle Software to 64-bit
- 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 ?
Received on Tue Nov 23 2004 - 03:29:26 CST
