Friday, 9 June 2017

Oracle database upgrade from 11g to 12c

 Oracle upgrade from 11g to 12c 

Oracle upgrade from 11g to 12c :- There are foloowing ways to upgrade
1) DBUA
2) Manual Upgrade
3) Export/Import

DBUA (Database Upgrade Assistance):-Following steps need to perform
Note: Following Database versions can be directly upgraded to 12c

    a) Oracle Database 10g (10.2.0.5)
    b) Oracle Database 11g (11.1.0.7)
    c) Oracle Database 11g (11.2.0.2 or later)

1) Make directory structure & change the ownership
mkdir -p /u01/oracle/product/12.1.0.1/dbhome_1/
chown oracle:oinstall -R /u01/oracle/

2) Login to the Oracle User and Install 12c database software only

3) run the "preupgrd.sql" for pre-upgrade setup

SQL>@/u01/oracle/product/12.1.0.1/dbhome_1/RDBMS/ADMIN/preupgrd.sql

check the log file in path "/opt/oracle/cfgtoollogs/ora11g/preupgrade/" and run the "preupgrade_fixups.sql"

4) run the dbua from Oracle 12c home path

$cd /u01/oracle/product/12.1.0.1/dbhome_1/bin

$./dbua

5) After completion of DBUA , run the "postupgrade_fixups.sql"

No comments:

Post a Comment

Cloning database with RMAN

Below are the steps to clone production database(primedb) to UAT database(clonedb)   STEP1 :- Check the both servers are able to connect ...