Pages

Saturday, May 3, 2014

Upgrade the OPSS schema using Patch Set

Upgrade the OPSS schema using Patch Set 


The following tasks needs to be performed to upgrade the opss schema using patch set. They are

Go to the oracle_common/bin directory.

Execute the ./psa file and it will open the following screen.


Click Next.


Select Oracle Identity Manager Check Box and it will display the following screen.



Click Next.



Enter the Connection String, DBA User Name, and DBA password. The example values are shown above screen shot. Click Next.



Leave the Schema User Name is default value and enter Schema Password. Click Next.


If the password is same, leave the default value for Schema User Name and Password. If the password is different for each user, you need to enter schema password for each user. Click Next.


If the password is same, leave the default value for Schema User Name and Password. If the password is different for each user, you need to enter schema password for each user. Click Next.


If the password is same, leave the default value for Schema User Name and Password. If the password is different for each user, you need to enter schema password for each user. Click Next.


If the password is same, leave the default value for Schema User Name and Password. If the password is different for each user, you need to enter schema password for each user. Click Next.

After clicking the Next button, it will upgrade the Oracle Platform Security Services.




Click Next.



Click Upgrade button and It will upgrade the OPSS schema.


Click Next.


Click Close button and it will close the window.

Verify the Schema Upgraded with version numbers in Oracle Data Base.


Login as a sysadmin and Select the table schema_version_registry. All status should be valid and OPSS user Upgraded flag should be Y. The verified query is given below in the screen shot. 


No comments:

Post a Comment