My Oracle Support Banner

OPSS - Unable set security Store getting unique constraint errors (Doc ID 2049671.1)

Last updated on DECEMBER 22, 2023

Applies to:

Oracle Platform Security for Java - Version 11.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

Having issues creating the DB security store during OIM 11.1.2.3.0 install/configure.

configureSecurityStore.py -d /<DOMAIN_HOME> -c IAM -p <PASSWORD> -m create -v

CLASSPATH=/<MW_HOME>/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/<MW_HOME>/patch_ocp371/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/u02/jdk1.7.0_80/lib/tools.jar:/<MW_HOME>/wlserver_10.3/server/lib/weblogic_sp.jar:/<MW_HOME>/wlserver_10.3/server/lib/weblogic.jar:/<MW_HOME>/modules/features/weblogic.server.modules_10.3.6.0.jar:/<MW_HOME>/wlserver_10.3/server/lib/webservices.jar:/<MW_HOME>/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/<MW_HOME>/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar::/<MW_HOME>/oracle_common/modules/oracle.jrf_11.1.1/jrf-wlstman.jar:/<MW_HOME>/oracle_common/common/wlst/lib/adfscripting.jar:/<MW_HOME>/oracle_common/common/wlst/lib/adf-share-mbeans-wlst.jar:/<MW_HOME>/oracle_common/common/wlst/lib/mdswlst.jar:/<MW_HOME>/oracle_common/common/wlst/resources/auditwlst.jar:/<MW_HOME>/oracle_common/common/wlst/resources/igfwlsthelp.jar:/<MW_HOME>/oracle_common/common/wlst/resources/jps-wlst.jar:/<MW_HOME>/oracle_common/common/wlst/resources/jps-wls-trustprovider.jar:/<MW_HOME>/oracle_common/common/wlst/resources/jrf-wlst.jar:/<MW_HOME>/oracle_common/common/wlst/resources/oamap_help.jar:/<MW_HOME>/oracle_common/common/wlst/resources/oamAuthnProvider.jar:/<MW_HOME>/oracle_common/common/wlst/resources/ossoiap_help.jar:/<MW_HOME>/oracle_common/common/wlst/resources/ossoiap.jar:/<MW_HOME>/oracle_common/common/wlst/resources/ovdwlsthelp.jar:/<MW_HOME>/oracle_common/common/wlst/resources/sslconfigwlst.jar:/<MW_HOME>/oracle_common/common/wlst/resources/wsm-wlst.jar:/<MW_HOME>/utils/config/10.3/config-launch.jar::/<MW_HOME>/wlserver_10.3/common/derby/lib/derbynet.jar:/<MW_HOME>/wlserver_10.3/common/derby/lib/derbyclient.jar:/<MW_HOME>/wlserver_10.3/common/derby/lib/derbytools.jar::

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Info: Domain directory is: /<MW_HOME>/user_projects/domains/<DOMAIN_NAME>
Info: Server Type is: DB_ORACLE
Info: JPS root is: cn=jpsroot
Info: Data source is: opss-DBDS
Info: Join flag is: false
Info: IDM flag: IDM
Info: Farm name: IAM
Info: Read domain configure file: /<DOMAIN_HOME>/config/config.xml
Info: Get target data source.
Info: Read data source file: /<DOMAIN_HOME>/config/jdbc/opss-jdbc.xml
Info: Data source list: [None]
Info: DB user name: <PREFIX>_OPSS
Info: DB JDBC driver: oracle.jdbc.OracleDriver
Info: DB JDBC URL: jdbc:oracle:thin:@<HOST>:<PORT>/<SID>
Info: JNDI name of data source: jdbc/OPSSDBDS
Connected:oracle.jdbc.driver.T4CConnection@3a97e1bc
Disconnect:oracle.jdbc.driver.T4CConnection@3a97e1bc
Info: Read domain: /<MW_HOME>/user_projects/domains/JEA_OIM
Info: Farm name: IAM
Info: jps-config.xml file path: /<DOMAIN_HOME>/config/fmwconfig/jps-config.xml
Info: Copy file from /<DOMAIN_HOME>/config/fmwconfig/jps-config.xml Info: Copy file to /<DOMAIN_HOME>/config/fmwconfig/jps-config-bak.xml
Info: Copy file from /<DOMAIN_HOME>/config/fmwconfig/jps-config-jse.xml Info: Copy file to /<DOMAIN_HOME>/config/fmwconfig/jps-config-jse-bak.xml
Info: Execute command: java -Xms512M -Xmx512M oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler -command setSecurityServices -servertype DB_ORACLE -domain IAM -admin <PREFIX>_OPSS -password '<PASSWORD>' -jpsroot cn=jpsroot -migration true -seedSchemaAndDIT true -jdbcurl 'jdbc:oracle:thin:@<HOST>:<PORT>/<SID>' -jdbcdriver oracle.jdbc.OracleDriver -path /<DOMAIN_HOME>/config/fmwconfig/jps-config.xml
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator] checkServiceSetup - done
Aug 24, 2015 3:44:11 PM oracle.security.jps.internal.config.ldap.LdapCredStoreServiceConfigurator schemaCompatibleHandler
INFO: Credential store schema upgrade not required. Store Schema version 11.1.1.9.0 is compatible to the seed schema version 11.1.1.9.0
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator] checkServiceSchema - Store schema has been seeded completely
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator] updateServiceConfiguration - done

Internal Exception: java.sql.BatchUpdateException: ORA-00001: unique constraint (<PREFIX>_OPSS.IDX_JPS_RDN_PDN) violated

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.