Move from Derby to Oracle

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

I've been unable to find documentation on moving our Service Virtualization from derby to Oracle.

Can you point use in the right direction?

Environment

All Supported DevTest releases.

Cause

N/A

Resolution

We do not have a tool to export the data from Derby and import it into Oracle.

You will need to start your DevTest components with a clean Oracle database and make sure it is UTF-8.

What you will need to do is to add the following properties in the iam.properties file:

iam.db.vendor=oracle
iam.db.jdbc.driver.class=oracle.jdbc.driver.OracleDriver
iam.db.url=jjdbc:oracle:thin:@YourHostGoesHere:PortOracleRunningOnGoesHere:OracleDatabaseInstanceGoesHere
iam.db.user=IAMOracleUserGoesHere
iam.db.password=IAMOraclePasswordGoesHere
iam.db.jdbc.driver.path=FullyQualifiedPathofWheretheOracleDriverjarFileIs

Then make these changes in the dradis.properties file:

dradis.db.internal.enabled=false

dradis.db.driverClass=oracle.jdbc.driver.OracleDriver

dradis.db.url=jdbc:oracle:thin:@YourHostGoesHere:PortOracleRunningOnGoesHere:OracleDatabaseInstanceGoesHere

dradis.db.user=EnterpriseDashboardOracleUserGoesHere

dradis.db.password=EnterpriseDashboardOraclePasswordGoesHere

Then make these changes in the site.properties file:

 

lisadb.pool.common.driverClass=oracle.jdbc.driver.OracleDriver

isadb.pool.common.url=jdbc:oracle:thin:@YourHostGoesHere:PortOracleRunningOnGoesHere:OracleDatabaseInstanceGoesHere
lisadb.pool.common.user=RegistryOracleUserGoesHere

lisadb.pool.common.password=EnterpriseDashboardOraclePasswordGoesHere

lisadb.internal.enabled=false

 

NOTE:

The User for IAM, Enterprise Dashboard and Registry must have DBA Authority unless you DBA is creating the tables.

Once the property files are configured, bring down all of your DevTest components.

Then start all of your DevTest components.

Additional Information

Refer to the document sections for what release you are on:

External Enterprise Dashboard Database for Oracle

External Registry Database for Oracle