Need Steps for Configuring IAM to use an External Oracle Database

Products

• CLOUDTEST
• CA Application Test
• CA Cloud Test Mobile
• MOBILECLOUD
• Service Virtualization

Issue/Introduction

We are also looking into possibly having IAM no longer use the embedded database and instead connect to the Oracle database.

Can you provide the necessary steps we will have to take in order to accomplish that?

 

Cause

 

N/A

Environment

Release : 10.4 and later

Component : CA Service Virtualization

Resolution

Here is what you need to do to change your IAM to use an Oracle database instead of the Embedded database:

1. Your DBA will have to create a new schema with no tables for IAM.
2. Create new folder DEVTEST_HOME/IdentityAccessManager/database/drivers     (note: this is not in the docs, it is what I do.)
3. Copy file DEVTEST_HOME/lib/dradis/ojdbc7-12.1.0.2.jar to folder DEVTEST_HOME/IdentityAccessManager/database/drivers.
4. Update DEVTEST_HOME/IdentityAccessManager/iam.properties file.
5. Add these lines to the file: (USER must have DBA Authority to create the tables)

iam.db.vendor=oracle
iam.db.url=jdbc:oracle:thin:@[HOST]:1521:[SID]   or jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE-NAME
iam.db.user=[USER]
iam.db.password=[PASSWORD]
iam.db.jdbc.driver.class=oracle.jdbc.driver.OracleDriver
iam.db.jdbc.driver.path=DEVTEST_HOME/IdentityAccessManager/database/drivers/ojdbc7-12.1.0.2.jar

6. Stop all DevTest components.
7. Delete all the log files in /opt/CA/DevTest10.5/IdentityAccessManager/standalone/log
8. Start all DevTest components.
9. Login to IAM to verify.

 

where DEVTEST_HOME is the home folder of where DevTest is installed.

where ojdbc7-12.1.0.2.jar is the Oracle JDBC driver we deliver with DevTest.