BMC Cloud Lifecycle Management (CLM) : How to modify CLM applications to point them to the new Database ?

Product

Cloud Lifecycle Management

Component

Cloud Lifecycle Management

Applies to

BMC Cloud Lifecycle Management 4.6x, 4.7

Question

How to migrate Database schemas and how to modify CLM components to points them to the new Database?

Answer

Below are the changes that needs to be done on each CLM components :

1) On Enterprise AR server VM:
a. Stop EAR service
b. Update /data1/product/11.1.0/client_1/network/admin/tnsnames.ora file and change database details with new details.
For Example:
ITSMARDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Oracle Server host>)(PORT = <DB Port>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <Inst1 Service name>)
)
)
c. Start EAR service.
d. Check EAR service is started properly by logging into the EAR using AR User tool.

2) On Cloud AR VM:
a. Stop CAR service
b. Update /data1/product/11.1.0/client_1/network/admin/tnsnames.ora file and change database settings with the new database settings.
c. Start Cloud AR service.
d. Check Cloud AR service is started properly by logging into the CAR using AR User tool.

3) On AtriumWS VM:
a. Stop AtriumWS service
b. Update context.xml file located at /opt/bmc/AtriumWebRegistry/shared/tomcat/conf and change Database settings with new database settings.
c. Update AtriumCoreInstalledConfiguration.xml file located at /opt/bmc/AtriumWebRegistry/ and change Database settings with new database settings.
d. Start AtriumWS service.
e. Check AtriumWS service is started properly by logging into the AtriumWS administrator console

Note: Atrium Web Services 8.x uses Apache Derby as its Registry. So no database changes are require for Atrium Web Services

4) On BNA (BMC Network Automation) VM:
a. Stop BBNA service
b. Update database details in "/opt/bmc/BCA-Networks-Data/database.properties" file
Locate property name "javax.jdo.option.ConnectionURL"
c. Update database details in "/opt/BMC Software/BCA-Networks/tomcat/conf/server.xml" file
Locate property name "connectionURL"
d. Update database details in ""/opt/BMC Software/BCA-Networks / BcanInstalledConfiguration.xml" file
Locate property name "DATABASE_PORT_NUMBER" and "DATABASE_URL"
e. Start BBNA service
f. Check BBNA service is started properly by logging into the BBNA web console.

5) On BSA (BMC Server Automation) VM:
a. Stop BBSA app server
b. Launch blappcon by running /opt/bmc/bladelogic/8.1/operationsManager/NSH/bin/blappconf -s config_deployment_clm-bbsa
c. Update database details with new database settings
d. Repeat step b. and c. for job_deployment_clm-bbsa, jobserver1 and jobserver2 like:
/opt/bmc/bladelogic/8.1/operationsManager/NSH/bin/blappconf -s job_deployment_clm-bbsa
/opt/bmc/bladelogic/8.1/operationsManager/NSH/bin/blappconf -s jobserver1
/opt/bmc/bladelogic/8.1/operationsManager/NSH/bin/blappconf -s jobserver2
e. Restart BBSA service
f. Check BBSA service is started properly by logging into the BSA client.

6) On BPPM Leaf Server:

Make following changes in BPPM leaf servers to point them to the new database as follows.

a) Go to command prompt or BPPM pw command prompt and use following commands:-

In order to change DB configuration , please use the following command.

pw dbconfig set -database oracle -host <DB Hostname>:1521 -sid <BPPMC> -username <username> -password <password> -repusername <username> -reppassword <password>

b) Below command will test the input parameters in the command

pw dbconfig test -database oracle -host <hostname>.<domain.com>:<port no> -sid <Oracle SID> -username <username> -password <password> -repusername <report username> -reppassword <report password>

c) Check if new DB configurations are set correctly using below command

pw dbconfig list

d) Now start the BPPM service

pw sys start

e) Check whether all services are started.

7) On BPPM Central server:

Make following changes in BPPM Central server to point them to the new database as follows.

a) Go to command prompt or BPPM pw command prompt and use following commands:-

In order to change DB configuration , please use the following command.

pw dbconfig set -database oracle -host <DB Hostname>:1521 -sid <BPPMC> -username CPROACT -password clmAdm1n -repusername CREPORT -reppassword clmAdm1n

b) Below command will test the input parameters in the command

pw dbconfig test -database oracle -host <hostname>.<domain.com>:<port no> -sid <Oracle SID> -username <username> -password <password> -repusername <report username> -reppassword <report password>

c) Check if new DB configurations are set correctly using below command

pw dbconfig list

d) Now start the BPPM service

pw sys start

e) Check whether all services are started.

pw sys status

f) Login to the admin console of BPPM Central and Leaf Servers using credentials.

8) On BCO VM:

a: Stop BCO service

b: Modify following files and update DB connection with new Database hostname and instance name:

Change CLM-DB2 (old DataBase host) with new Oracle DB hostname

Change BCODB with new DB instance name

Here are the files:

- /web/conf/ds.properties

- /web/conf/ds_dash.properties

- /datahub/jboss/server/all/deploy/caplan-ds.xml

- /datahub/conf/ds.properties

- /env.sh

- /scheduler/conf/ds.properties

- Update /data1/product/11.1.0/client_1/network/admin/tnsnames.ora file update TNS entry with new Database hostname and service name/Instance name.

Example:

BCO =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = <Oracle Server host>)(PORT = <DB Port>))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = <Inst1 Service name>)

)

e: Start BCO service.

f: Check BCO service is started properly by logging into the BCO console.

g: After logging into the console go to Administration->System->Configuration

h: Select General tab

i: Click on Edit and update new DB details in Database JDBC URL field.

j: Provide dummy/actual values for SMTP Server and Administrator Email fields.

k: Click on Save button.

Related Products:

BMC Cloud Lifecycle Management

Knowledge Article