Friday, 14 July 2017

step by step upgrade Oracle 10g to 11g

Below are steps need to perform to upgrade Oracle 10g to 11g :-
1) Create a Directory structure for Oracle Home for 11g
 mkdir -p /u01/app/oracle/oracle/product/11.1.0
2) Run the run Installer for software installation of 11g
./runInstaller
3) Pre-Upgrade Utility (Login to 10g Database and run the below sql)
 SQL>@/u01/app/oracle/oracle/product/11.1.0//rdbms/admin/utlu111i.sql
Note:-This sql will give the output in the form of recommendations to be implemented before starting the upgrade.
4) Executing the recommended steps
5) run the pre-upgrade utility again

Note:-Now no critical warning should be there
6) Set the ORACLE_HOME, ORACLE_SID,PATH for oracle 11g
7) connect sys as sysdba for database 11g (idle instance will started) and run the upgrade command

SQL>startup upgrade
8) After completion run the catalog upgrade sql
 SQL>@catupgrd.sql
Note:-Once the upgrades finishes. It will shut down the database automatically.
Login again as sysdba and startup in normal mode.Check the dba_registry for the components and its status
9) Post-Upgrade StepsOnce the upgrade completes, restart the instance to reinitialize the system parameters for normal operation.
SQL> STARTUP
10) Run utlu111s.sql, catuppst.sql and utlrp.sql sqls to complete upgrade and validate objects
SQL> @?/rdbms/admin/utlu111s.sql
SQL> @?/rdbms/admin/catuppst.sql
SQL> select count(*) from dba_objects where status = ‘INVALID’;
SQL> @?/rdbms/admin/utlrp.sql
SQL> select count(*) from dba_objects where status = ‘INVALID’;


Related Topics :-
Step by Step Installation of Oracle-11g in Linux RHEL 7.0 
Step by Step Oracle database upgrade from 11g to 12c 

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 ...