Patch OPSS Schema to upgrade to version 11.1.1.7.2

This post explains steps to Patch OPSS Schema to upgrade to version 11.1.1.7.2 . By applying the this patch previous versions of Oracle Fusion Middleware 11g schemas upgraded  to version 11.1.1.7.2

Steps to Patch OPSS Schema to upgrade to version 11.1.1.7.2

Navigate to $Middleware_Home/Oracle_common/bin and run ./psa as shown below

Before running the patch assistant you can check the current version of OPSS schema by running the below query against database.

      SELECT VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY WHERE OWNER=’schema_name’;

eg: SELECT VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY WHERE OWNER=’DEV_OPSS’;

This will give you the current version of OPSS schema.

VERSION                        STATUS      UPGRADED
—————————— ———– ——–
11.1.1.7.0                     VALID       N

 

Installation and Configuration steps for Oracle Identity Manager 11GR2 PS2 Patch OPSS Schema to upgrade to version 11.1.1.7.2

 

 

 

 

 

In the next screen , select Oracle Platform Security Services check box and click on Next

 

Installation and Configuration steps for Oracle Identity Manager 11GR2 PS2 1 Patch OPSS Schema to upgrade to version 11.1.1.7.2

 

 

 

 

 

 

 

 

 

 

 

 

 

Select the check boxes and click on Next to  continue

 

Installation and Configuration steps for Oracle Identity Manager 11GR2 PS2 2 Patch OPSS Schema to upgrade to version 11.1.1.7.2

 

 

 

 

 

 

 

 

 

 

 

 

 

In the OPSS Schema page , enter the OPSS schema details and click on Next

 

Installation and Configuration steps for Oracle Identity Manager 11GR2 PS2 4 Patch OPSS Schema to upgrade to version 11.1.1.7.2

 

 

 

 

 

 

 

 

 

 

 

 

 

In the next page , enter the password of OPSS schema account. Click on Next to continue

 

Installation and Configuration steps for Oracle Identity Manager 11GR2 PS2 5 Patch OPSS Schema to upgrade to version 11.1.1.7.2

 

 

 

 

 

 

 

 

 

 

 

 

 

In the Examine page schema examination status will be displayed.  , click Next to continue.

 

Installation and Configuration steps for Oracle Identity Manager 11GR2 PS2 7 Patch OPSS Schema to upgrade to version 11.1.1.7.2

 

 

 

 

 

 

 

 

 

 

 

 

In the Upgrade Summary page, the summary of schemas that will be upgraded will be displayed. Click on Upgrade to continue

 

Installation and Configuration steps for Oracle Identity Manager 11GR2 PS2 8 Patch OPSS Schema to upgrade to version 11.1.1.7.2

 

 

 

 

 

 

 

 

 

 

 

 

 

Upgrade status will be displayed in the next page. Click on Close to complete the patching.

Now confirm that the schema version is upgraded to version 11.1.1.7.2 using the below query .

      SELECT VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY WHERE OWNER=’schema_name’;

eg: SELECT VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY WHERE OWNER=’DEV_OPSS’;

 

VERSION                        STATUS      UPGRADED
—————————— ———– ——–
11.1.1.7.2                     VALID       Y

This shows that the OPSS schema is upgraded to version 11.1.1.7.2.

Also you can check the <MIDDLEWARE_HOME>/oracle_common/upgrade/logs directory for the logs .

eg: /u01/app/oracle/Middleware/oracle_common/upgrade/logs

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>