Upgrade Oracle 10g to 11g

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>@?/rdbms/admin/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’;

No comments:

Post a Comment