Upgradation and Migration

 

Upgradation and Migration

               

                               

Upgradating database 11g to 12c version:

                                   

                                    Steps:

1.      Apply patchset 3 or timezone interim patch on oracle software and upgrade the data dictionary and recompile the invalid objects.

2.      Run utlu121i.sql(pre upgrade script) at 11g database to check weather

The database is ready for upgradation.

Loc:/u01/home/product/12.1.0/db_1/rdbms/admin/utlu121i.sql

3.      Create an env file for 12c just specify the path of 12c ORACLE_HOME in this env file.

4.      Check oratab file for entry of database that is going to be upgraded on 12c , if it is not there than make a entry in that file for

Ex. Open following file from root user

      $vi /etc/oratab

             Tech:/u02/Techzone/oracle/product/11.2.0/db_1:no

                                                   : x  //save the file

                                        5.    Copy parameter file of 11g database to 12c ORACLE_HOME/dbs

5.      run dbua utility from 12c oracle home terminal

$dbua                                              (interactive mode)

 

$dbua –dbname   <database name> …     (non-interactive mode)

 

6.      After ugrading database just check the database by running utlu121s.sql (post upgradation script) at 12c terminal.

Sql>@$ORACLE_HOME/rdbms/admin/utlu121s.sql

 

Migrating database from window platform to Linux Platform:

Steps:

1.      Take full database export using expdp utility.

2.      Than copy generated dump file to Linux machine.

3.      Create a fresh database (of same size) at target machine and import the source database from dumpfile.