oracle upgrade 10g to 11g
Oracle 10g database is upgrade to oracle 11g database.This upgrade support from 10.2.0.4.0 to 11.1.0.6.0 version only. Step -1 Pre Request:- 1. Check the database version. SQL> select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – Prod PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 – Production NLSRTL Version 10.2.0.4.0 – Production 2. Check the packages validity. SQL> select comp_name, version, status from sys.dba_registry; COMP_NAME VERSION STATUS ———————————————– ———— —— Oracle Database Catalog Views 10.2.0.4.0 VALID Oracle Database Packages and Types 10.2.0.4.0 VALID 2 rows selected. 3. Check whether objects are valid SQL> select object_name,status from dba_objects where status='INVALID'; no rows selected. 4. Check whether any datafile is in backup mode SQL> select * from v$backup where status='ACTIVE'; FILE# STATUS CHANGE# TIME --------- ---...