Re: Upgrade from v7.2.2 to v7.3.4

From: Alexey M. Reshetov <real_at_kpbank.ru>
Date: 26 Aug 1998 04:27:27 GMT
Message-ID: <6s02rf$jh3$3@home.kpbank.ru>

Winnie Liu (poohland_at_hotmail.com) wrote:
: Due to the upgrade the OS from Dynix 2.6 to Dynix 4.0. As the same time, we
: want to upgrade the Oracle database from v7.2.2 to v7.3.4. Here is the
: procedure:

: 1. Do a cold backup of the whole database
: 2. Install v7.3.4 to another ORACLE_HOME directory
: 3. Copy the control files, init.ora file to a new directory
: 4. edit the init.ora file to point to the new controlfile
: 5. start svrmgrl and connect as internal
: 6. mount (or nomount?) the new version of the database
: 7. Run the script cat734.sql (?) <-not sure about the name of the script,
: need help here
: to update the data dictionary from v7.2.2 to v7.3.4.
: 8. Open the database

: Can any one tell me if I miss any important step here at all?

: Any advice is welcome! =>

: Winnie

Why you will to recreate control files? You can do the next:

1. Create a cold backup of the whole database.
2. You can shutting down existing database, install new software on the same place without creating database objects.
3. start svrmgrl and connect as internal Run $ORACLE_HOME/rdbms/install/rdbms/upgrd<ORA_SID>.sql

   ---

Alexey Reshetov
real_at_kpbank.ru Received on Tue Aug 25 1998 - 23:27:27 CDT