Upgrade RCU Schemas to 11.1.1.6.0 in Oracle

Recently I have come through the Patch Upgradation from OBIEE 11.1.1.5.0 to 11.1.1.6.0. For a caues, before running Patch set assistant to upgrade the RCU schema from older version to latest, I have taken the back up of two database schemas (DEV_MDS, DEV_BIPLATFORM) to a Dump file.


Here I am sharing what are all the tasks I have done before running Upgrade Patch Assistant


Step1:
Make your Oracle database is up and running and the schema we want to upgrade are at version that are supported to upgrade. that is It must be older version from the version we are going to upgrade.


Login into oracle with 'SYS' account in sqlplus and type the below command to know the current version of RCU Schema and Its owner name.


SQL> SELECT OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY;

So in my case the version 11.1.1.5 going to be upgraded to 11.1.1.6.


Step2:
we have to recompile the database objects before running Patch Set Assistant to check for invalid objects before the upgrade. with oracle database installation a .sql script file is coming default to recompile the database objects. The file is utlrp.sql and available in the below oracle installed path:
D:\app\Bose\product\11.1.0\db_1\RDBMS\ADMIN
So run this script file to recompile the database objects for validation by entering the command like below in sql.


SQL> @?RDBMS/ADMIN/utlrp.sql

 After execution of the script we will get screen like below:

Step3:

After running utlrp.sql, and before you upgrade your schema, issue the following query to ensure there are no longer any invalid database objects:


SQL> SELECT OWNER, OBJECT_NAME FROM ALL_OBJECTS WHERE STATUS='INVALID';

So we are not having any invalid objects in our database. Now we are ready to Patch Set Assistant. But if we are running the same query with status='VALID', We will come to know the valid database objects.


Step4: 
For a cause I have exported RCU schema to separate dumps .To export the database go to Run->type 'cmd'. The command prompt utility will be opened:
Execute the below command one by one to export both schema:


C:\> EXP DEV_MDS/Admin123 file=RCU_MDS.dmp log=mds.log


C:\> EXP DEV_BIPLATFORM/Admin123 file=RCU_BIPLATFORM.dmp log=biplatform.log

Now come to Drive where we are running the export command. We will get two dump files RCU_MDS, RCU_BIPLATFORM. Cut and paste in some other drive for a record.


Step5:
Now come to the below path and double click on psa.bat batch file. It will open GUI called 'Oracle Fusion Middleware Patch Set Assistant'. 


Drive:<BIHome>\oracle_common\bin\psa.bat

Follow the steps one by one with the above screen to upgrade the RCU Schema.
Patch Set Assistant Screens:


Cheers!
Bose