Identity Portal Installation with Oracle 12c fails

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Installing Identity Portal with JBoss/Wildfly and Oracle 12c fails with the error "Unable to build Hibernate SessionFactory".  The stack trace of the error in the log shows it is caused by "org.hibernate.tool.schema.extract.spi.SchemaExtractionException: More than one table found in namespace (, )" followed by the duplicate table name.

Environment

Release:
Component: SIGMA

Cause

The user configured for the database is configured with incorrect permissions.  It has DBA permission instead of just CONNECT and RESOURCE as specified in the CA Identity Suite documentation.  Having DBA allows the user to see all tables.  This causes the query used to update the schema during installation to fail since it expects to have only one table by a specified name.

Resolution

Ensure that a dedicated schema has been created for CA Identity Portal, and assign only the CONNECT and RESOURCE DB Roles to the schema user, then re-run the installation.