WebCenter Capture 11.1.1.8 Cluster - Creating OPSS schema for using Database Based Security Store

WebCenter Capture 11.1.1.8 Cluster - Creating OPSS schema for using Database Based Security Store

When using Database Based Security Store, follow steps below for OPSS schema creation.

- Download 11.1.1.8 RCU Patch 17068284
- Invoke RCU from /SID/fmw/product/111/oracle_common/bin ) and create OPSS schema

OPSS schema creation

i) Select Create

ii) DB connection Details:
- Host:
- Port:
- Service type:
- Username: system
- PASS: system_password
- Role: SYSDBA.

iii) On Select Components:


- Select "Select an existing Prefix" and verify SID is selected.
- Components:
Open "As Common Schemas" and select "Oracle Platform Security Services"


iv) On Schema Password, select "Use same passwords for all schemas" and enter password of "SID_MDS" schema

v)  Proceed further till OPSS schema gets created.

Related Posts:

WebCenter Capture 11.1.1.8 Cluster - Using Database Based Security Store

WebCenter Capture 11.1.1.8 Cluster - Workspace created or imported on one node is not visible on the other node and workspace gets deleted on restart of cluster node

WebCenter Capture 11.1.1.8 Cluster - Using OID Based Policy Store

WebCenter Capture 11.1.1.8.0 - reassociateSecurityStore(domain="your_domain", servertype="DB_ORACLE",datasourcename="jdbc/opss-ds", jpsroot="cn=jpsTestNode", join="false") fails with error JPS-00027: There was an internal error: java.sql.BatchUpdateException: ORA-00904: "ATTRKIND": invalid identifier