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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: What is the best and the easiest method to upgrade an instanc

RE: What is the best and the easiest method to upgrade an instanc

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Wed, 27 Sep 2000 08:37:21 -0500
Message-Id: <10632.117985@fatcity.com>


Hi,
 Assuming UNIX ....
 Take full backups of all 7.3.3 databases (cold or hot.)  Change oratab file to reflect new 7.3.4 ORACLE_HOME for the instances.  Change any other hard coded ORACLE_HOME in profiles/scipts etc. to the new one..
 Create initSID.ora file in the 7.3.4 $ORACLE_HOME/dbs directory.. Set the 'compatible' parameter is set to 7.3.4.  Set up env for 7.3.4 and startup the instance in restricted mode..  Run $ORACLE_HOME/rdbms/admin/cat7304.sql as INTERNAL. This script should be

in 7.3.4 $ORACLE_HOME/rdbms/admin to migrate 7.3.3 to 7.3.4 database. Pl
take a look at the script to see what it does..
 I would run catalog, catproc etc.. after that.. 
 Backup the databases again.
 Install new tnsnames.ora and listener.ora in 7.3.4 home, or modifiy those if already exist, for your SIDs that were just upgraded..  Restart the listener and open the database for all to use..  If everything works out fine, you can remove 7.3.3....... else its time to look at cat7304d.sql.. (to downgrade to prev level)...  HTH.. and Good luck.
- Kirti

> -----Original Message-----
> From: ALEMU Abiy [SMTP:abiy.alemu_at_criltechnology.com]
> Sent: Wednesday, September 27, 2000 2:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: What is the best and the easiest method to upgrade an
> instance fr
>
> I would like to upgrade 3 instances from Oracle 7.3.3 to Oracle 7.3.4.
> Both
> softwares already exist but I would like simply to upgrade all instances
> from 7.3.3 to 7.3.4 before removing the 7.3.3 version ?
>
> --------------------------------------------------------------------------
> --
> --------
> @biy @lemu
> abiy.alemu_at_criltelecom.com <mailto:abiy.alemu_at_criltelecom.com>
> Cril Telecom Software
> France
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Sep 27 2000 - 08:37:21 CDT

Original text of this message

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