SV: Changing the DevTest databases from local MySQL instance to an Oracle instance

book

Article ID: 194893

calendar_today

Updated On:

Products

CLOUDTEST CA Application Test CA Cloud Test Mobile MOBILECLOUD Service Virtualization

Issue/Introduction

We will be changing the DevTest databases from the local MySQL instance to an Oracle instance on another server.

Can you please send me the steps to make that change on the config side to make sure that I don’t miss anything? 

 

Cause

 

N/A

Environment

Release : 10.5

Component : CA Service Virtualization

Resolution

Here is what you need to do to change your DevTest to use an Oracle database instead of a local MySQL database.

Below are the properties files that need to be changed:

DEVTEST_HOME\IdentityAccessManager\iam.properties (IAM)
DEVTEST_HOME\dradis.properties (Enterprise Dashboard)
DEVTEST_HOME\site.properties (Registry)

1. If wanting to keep the data in your MySQL database to be used in the new Oracle database, then your DBA must manually export the data from MySQL and import into Oracle. If you are not going to keep the data and starting with new schemas, then the Oracle USER being used for each database must have DBA Authority to create the tables.

DDL for IAM DEVTEST_HOME/IdentityAccessManager/database/ddl/oracle.ddl
DDL for Enterprise Dashboard DEVTEST_HOME/database/oracle_enterprisedashboard.ddl
DDL for Registry DEVTEST_HOME/database/oracle.ddl and oracle_cai.ddl

2. Bring all DevTest 10.5.0 components down on all machines.

3. Rename the lisatmp_10.5.0 folder to a backup or just delete the folder. This folder not only has the log files but it also keeps track of the communication between the DevTest components, so to also remove cached data, you will need to start with a fresh lisatmp_10.5.0 folder.

4. For IAM, update the iam.properties file and instead of targeting MySQL, target Oracle. We deliver the JDBC driver for Oracle, so for the iam.db.jdbc.driver.path property you can point to the ojdbc7-12.1.0.2.jar in the DEVTEST_HOME/lib/shared folder. (NOTE: we do not have a ${IAM_HOME}/database/drivers folder delivered, you would have to create that manually and copy the ojdbc7-12.1.0.2.jar file to that folder if you want to specify that path)

5. For the Enterprise Dashboard, update the dradis.properties file.

Comment out the below properties:

## ==================================================================================
## MySql
## ==================================================================================
## dradis.db.driverClass=com.mysql.jdbc.Driver
## dradis.db.url=jdbc:mysql://[DBHOST]:[DBPORT]/[DBNAME]
## dradis.db.user=[USER]
## dradis.db.password=[PASSWORD]

Uncomment the below properties and set the url, user and password values:

## ==================================================================================
## Oracle
## ==================================================================================
dradis.db.driverClass=oracle.jdbc.driver.OracleDriver
dradis.db.url=jdbc:oracle:thin:@[HOST]:1521:[SID]
dradis.db.user=[USER]
dradis.db.password=[PASSWORD]

6. For the Registry, update the site.properties file.

Comment out the below properties:

## ==================================================================================
## MySql
## ==================================================================================
## lisadb.pool.common.driverClass=com.mysql.jdbc.Driver
## lisadb.pool.common.url=jdbc:mysql://[DBHOST]:[DBPORT]/[DBNAME]
## lisadb.pool.common.user=[USER]
## lisadb.pool.common.password=[PASSWORD]

Uncomment the below properties and set the url, user and password values:

## ==================================================================================
## Oracle
## ==================================================================================
lisadb.pool.common.driverClass=oracle.jdbc.driver.OracleDriver
## Select one of the two connection URLs depending on usage of SID or SERVICE
## lisadb.pool.common.url=jdbc:oracle:thin:@[HOST]:1521:[SID] <== uncomment if Oracle using a SID (Oracle System ID)
## lisadb.pool.common.url=jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE <== uncomment if Oracle using a SERVICE (Oracle Database TNS Alias, the Service name is recorded in the tnsnames file.)
lisadb.pool.common.user=[USER]
lisadb.pool.common.password=[PASSWORD]

(your DBA will be able to tell you if the Oracle instance is using a SID or SERVICE)

7. Start your DevTest components in this order:

IAM, Enterprise Dashboard, Registry, Broker, Portal, Coordinator, Simulator, VSE.

I suggest to start all these services manually at first to make sure you do not have any errors connecting to the new database.

Additional Information