CA Identity Suite - Oracle Connector

[William Cheang]

Hi Team,
CA Suite 14.3 vapp setup using Non-Prod env using external db (MSSQL).
When Connecting to Oracle Server as Endpoint encountered the error below

But when i check the jcs log on vapp connect log file.
It show the error "ERROR - failed loading Oracle Driver class 'oracle.jdbc.driver.OracleDriver': Check classpath....

any steps i missing out ??

regards,
William

[Larry Kasten]

We can't see which table it's not finding but it seems like the driver is connecting to the DB but there are insufficient table permissions. You might try adding all admin permissions and see if you can access the table.

[William Cheang]

Hi Larry,
do u know what is the min. privileges require for manage Oracle Account ?
Customer have provided the service id, which i tested able to login to oracle db with Oracle SQL Developer client.

I tried search the documentation, can't find for oracle db connector
https://docops.ca.com/ca-identity-manager-and-governance-connectors/1-0/EN/connectors/oracle-connectors/oracle-server-connector

regards,
William

[Nicole Goldstein]

Hi William,

Please refer to the following document which outlines the permissions for the Oracle connector. 

https://docops.ca.com/ca-identity-manager-and-governance-connectors/1-0/EN/connectors/oracle-connectors/oracle-server-connector/security-configuration-and-limitations

Thank you,
Nicole