Tuesday 10 June 2014

oracle database upgradation from 11.2.0.3 to 11.2.0.4 (11.2.0.3-11.2.0.4)


Oracle Database Upgradation(from 11.2.0.3 to 11.2.0.4 )

Steps to follow:
1.Download patch  13390677 (11.2.0.4) from metalink  or any provided link for 11.2.0.4 DB 
2.Take backup of old DB(11.2.0.3)
3.Start installing 11.2.0.4 DB on server with separate home .
4.export new ORACLE_HOME in bash_profile  for permanent setting.
note:Since database version is same no need to create listener for new DB.
6.Start ./dbua from $ORACLE_HOME/bin(Check whether the database is up or not from old home)
PATH to Upgrade:
Old DB: 11.2.0.3--> 11(DB version).2(Release).0(application release).3(component release/patch release)
New DB: 11.2.0.4-->11(DB version).2(Release).0(application release).4(component release/patch release)
It clearly says need to upgrade patch release with component.
as shown in example below:

Installation of new DB software only and upgrade to new patch version:




























To resolve the above error  :
Root cause database was not started start DB and proceed
'













































After upgradation check for INVALID object for dba_objects check before and after run utlrp.sql scripts.
utlrp.sql script to recompile invalid object. 

No comments:

Post a Comment