Upgrade 11g to 12c
Oracle upgrade from 11g to 12c :- There are foloowing ways to upgrade1) 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