Oracle Database Upgradation(from 11.2.0.3 to 11.2.0.4 )
Steps to follow:
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