Re: Move datafiles from 7.3.2 to 7.3.4

From: Alan Way <alanw_at_datacom.co.nz>
Date: Wed, 3 Mar 1999 16:11:47 +1300
Message-ID: <7bi9ch$bvn$1@titan.xtra.co.nz>

The installation guide for your OS should have a chapter devoted to doing just this. (I know the Unix's I've done it on all do.)

Basically its:
:shutdown
:backup !!!!!!!!
:check for symbolic links under old oracle_home
:copy init{sid}.ora to new oracle_home/dbs directory (and config{sid}.ora if
u use it)
:edit init{sid}.ora and change any hard coded directorys and any directorys
referenced by ? (eg ?/admin/dump) to poing to new oracle_home. Especially change the ? to hard code the path to the new oracle_home.
:check the location of the control files is Ok, and any ifiles.
:change your ORACLE_HOME to new directory
:upgrade database objects using the installer that came with the NEW
version.

The times I've done it it was pretty painless, apart from the stress levels ;-)

Good luck. Read the Installation Guide for your platform! That will give you the real go on what to do.

Sacs Received on Tue Mar 02 1999 - 21:11:47 CST