Identity Portal remains as "starting" while deploying the IMAG Virtual Appliance using an external Oracle DB.

Document ID : KB000005744
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When deploying the Virtual Appliance using an external Oracle database. The only item that does not finish to deploy is Identity Portal. 

Checking the Identity Portal logs the following error appears: 

java.sql.SQLSyntaxErrorException: ORA-02267: column type incompatible with referenced column type 

 

The DB user configured has the DBA role and all the required permissions. 

 

Environment:
IMAG Virtual Appliance r14.0 with patches VA-14.0.0-PRE-CP and CP-IP-140000-0001
Cause:

The cause is worng permissions provided to teh Database user.

The permissions should be RESOURCE and CONNECT only and not any other permission.

Adding more permissions will cause the deployment to fail.

This is specified in the documentation (in teh Virtual Appliance Web UI -> help -> Prerequisites for configuring the vApp with an external database), and also on the same page where you configure the database credentials during setup)

Oracle:  

------- 

a. Create an Identity Portal database. 

b. Create a user with CONNECT and RESOURCE privileges on the Identity Portal database. 

 

Resolution:

Change the database user permissions to include only RESOURCE and CONNECT.

Additional Information:

https://docops.ca.com/ca-identity-suite/14-0/EN/installing/installing-ca-identity-portal/ca-identity-portal-installation-process/installing-a-database#InstallingaDatabase-OracleDatabase