Upgrade Oracle database from 11.2.0.2.0 to 11.2.0.3.0
upgrade Oracle database from 11.2.0.2 to 11.2.0.3
PURPOSE: All
documents are provided on this Blog just for educational purposes only. Please make sure that you run it in your test
environment before to move on to production environment.
Precheck:
Precheck:
Check the compatibility parameter of the diskgroup.
Login to ASM Instance:
sqlplus / as sysasm
select name,state
from v$asm_diskgroup;
NAME STATE
------------------------------
-----------
DATA1 MOUNTED
col COMPATIBILITY
form a10
col DATABASE_COMPATIBILITY form a10
col NAME form a20
select group_number,
name, compatibility, database_compatibility from v$asm_diskgroup;SQL>
SQL> SQL>
GROUP_NUMBER
NAME COMPATIBIL
DATABASE_C
------------
-------------------- ---------- ----------
1 DATA1 11.2.0.0.0 10.1.0.0.0
Create pfile from spfile
create pfile='/users/oracle/initFASDBPRD.ora_update11203' spfile;
Edit the pfile
Start DB Update:
Login to database(11.2.0.2.0) as sys user and run utlu112i.sql from
oracle 11.2.0.3.0 database software location
utlu112i.sql script will perform as pre upgrade checks.
SQL> spool
/tmp/upgrade_11.2.0.3.log
SQL>
@/app/oracle11/product/11.2.0.3/db/rdbms/admin/utlu112i.sql
Check if the the prerequests are fine, go-ahead and proceed with the
upgrade.
Before that, we should purge the DBA_RECYCLE BIN as suggested in the
spool script.
PURGE DBA_RECYCLEBIN
EXECUTE
dbms_stats.gather_dictionary_stats;
Copy the initfile from 11.2.0.2 home to the 11.2.0.3
home
shutdown db 11.2.0.2
shutdown immediate;
Log in to the system as the owner of the Oracle Database 11g Release 2
(11.2.0.3)
Start the instance by issuing the following command:
Make sure you edit the pfile before you create spfiel.
create spfile from
pfile='/users/oracle/initFASDBPRD.ora_update11203';
STARTUP UPGRADE
spool
/tmp/catupgrd.log
@/app/oracle11/product/11.2.0.3/db/rdbms/admin/catupgrd.sql
After completing the catupgrd.sql, Startup the instance and run
Post-Upgrade Status Tool utlu112s.sql
sqlplus / as sysdba
startup;
spool
/tmp/utlu112s.log
@/app/oracle11/product/11.2.0.3/rdbms/admin/utlu112s.sql
spool off;
Run catuppst.sql.
spool
/tmp/catuppst.log
@/app/oracle11/product/11.2.0.3/rdbms/admin/catuppst.sql
spool off;
@/app/oracle11/product/11.2.0.3/rdbms/admin/utlrp.sql
Verify that all expected packages and classes are valid:
SQL> SELECT
count(*) FROM dba_invalid_objects;
SQL> SELECT
distinct object_name FROM dba_invalid_objects;
Important:
Make sure, that you change the compatible Version 11.2.0.3.0
Also change the compatible version on disgroup.
On DB.
SQL> show
parameter compatible;
NAME TYPE VALUE
------------------------------------
----------- --------------
compatible string 11.2.0.0.0
On DB:
alter system set
compatible='11.2.0.2.0' scope=spfile;
shutdown immediate;
startup
On ASM:
select name, state
from v$asm_diskgroup;
alter diskgroup DATA
SET attribute 'compatible.asm'='11.2.0.2.0';
...
...
col COMPATIBILITY
form a10
col
DATABASE_COMPATIBILITY form a10
col NAME form a20
select group_number,
name, compatibility, database_compatibility from v$asm_diskgroup;
GROUP_NUMBER
NAME COMPATIBIL
DATABASE_C
------------
-------------------- ---------- ----------
1 DATA1 11.2.0.2.0 11.2.0.2.0
Done!
