Database Upgrade

Contents:- Database Upgrade

Oracle Database Upgrade Method

Direct Upgrade 10.2.0.5/11.1.0.7/11.2.0.2 Upgrade to 12.1.0.1

In-Place Upgrade  - Install Binaries in same ORACLE_HOME

Out-of-Place Upgrade – Install Binaries in new ORACLE_HOME (Recommend by Oracle)

Upgrade Using DBUA (Database Upgrade  Assistant) or Manual Upgrade

Indirect Upgrade

Migrate using Data pump Utility. (Migrate all database Objects using Data Pump utility)

Transportable Tablespace

Golden Gate Replication (From old database Version to new database Version)

         

Upgrade Oracle Database From 11.2.0.1.0 to 11.2.0.3.0 (Oracle Database Migration)

Here we upgrade database by using OUT-OF-PLACE Upgrade Method.

Steps

Check Oracle Release, Operating System Byte

$>cat /etc/oracle-release

$>uname –r

$>uname –p

Check Your Source Database Version

          $>cat /etc/oratab

Check location of oraInventory

$>cat $ORACLE_HOME/oraInst.loc     (This file contains location of oracle inventory and oracle inventory group name)

Check location of Previously Installed Oracle_home By using Following File

      $>cat /u01/app/oraInventory/ContentsXML/inventory.xml

Check Database Instance Status

      $> ps –ef | grep –i smon

      $>. Oraenv

Stc

$>sqlplus sys as sysdba

Sql>select instance_name,host_name,version,status from v$instance;

Sql>select comp_name,version,status from dba_registry;

$>unsip source_path –d target_path

$>mkdir –p /u01/app/oracle/product/11.0.3/db2

$>ll /u01/app/oracle/product/11.0.3/

$>export ORACLE_HOME=/u01/app/oracle/product/11.0.3/db2

Start Oracle Database Software 11.2.0.4 Installation into new home

$>. runInstaller

Then Start Database Upgrate from New Oracle Home

$> /u01/app/oracle/product/11.0.3/db2/bin/dbua &

Check your backup files in which there is stc_restore.sh script . that you can used to restore a database to an earlier version.

$>cat /etc/oratab

$> cat /u01/app/oraInventory/ContentsXML/inventory.xml

Copy listener.ora, tnsnames.ora file from old oracle home to new oracle home.

$> ps –ef | grep –i smon

$>. Oraenv

Stc

$>echo $ORACLE_HOME (make sure ORACLE_HOME pointing to new version location)

$>lsnrctl stop

$>lsnrctl start

$>lsnrctl status (Check listener version to new one, parameter file from new oracle home)

Check your Enterprise Manager Database Console Status

$>emctl status dbconsole

$>sqlplus sys as sysdba

Sql>select instance_name,host_name,version,status from V$Instance;

Sql>select comp_name,version,status from dba_registry;

Sql> select to_char(action_time,’DD-MON-YYYY HH24:MI:SS AM’) upgrade_date, comments source_version, version target_version from dba_registry_history where action=’UPGRADE’;

Deinstall old Oracle Home

$>cd /u01/app/oracle/product/11.0.3/db1/deinstall

$>./dinstall