This post will cover simple step for database upgrade from 11201 to 11204 on Linux-64bit
- Old Database: – 220.127.116.11
11-DB version 2-Release 0-Application release 1-Component release/patch release
- New Database: – 18.104.22.168
11-DB version 2-Release 0-Application release 4-Component release/patch release
The below mentioned diagram will give the idea of upgrade patch release with component details.
>> Download the Software from My oracle Support with Patch No:13390677
>> Check the status of source database version:
>> Take back-up of source database22.214.171.124:
>> Unzip the below zip files:
There are 7 files available, so that we need only first two files for database upgrade.
Go to the below step only if your database is created using DBCA method:
replace it with
>> Export new ORACLE_HOME in bash_profile:
>> Install Oracle 11g Software (126.96.36.199) on server with separate ORACLE_HOME:
Click Skip Software update and Click next
Select Install database software only and Click
Click Single instance database installation and Click Next
Select Enterprise Edition and Click Next
Verify the ORACLE_BASE and ORACLE_HOME and Click next
Select dba and Next
Installation of Oracle software is in progress…..
Execute configuration scripts with login as root user
Click Close to finish the installation.
Note:-Follow all above step one by one because screenshot is not attached.
>> Source database is up and running:
>> Start upgrade database using DBUA (ie New ORACLE_HOME)
Select Database Name and Click Next
Browser the parameter file path: and Click Yes
Untick Configure the database with OEM and Click Next
Database Upgrade is in progress……..
Check the summary of database upgrade
>> Run utlrp.sql to recompile Invalid objects:
Go to the directory $ORACLE_HOME/rdbms/admin
>> Verify that all expected packages, procedures and objects are valid:
SQL> SELECT count (*) FROM dba_invalid_objects;
>> Check status of upgraded database:
SQL>select * from v$version;
SQL>Col COMP_NAME format a20
SQL>Col VERSION format a20
SQL>Col STATUS format a20
SQL>Select COMP_NAME,VERSION,STATUS from dba_registry;