How To Convert a WCC 11.3.x DB to Oracle

Document ID : KB000010291
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

This document provides the steps necessary to convert the WCC 11.3.x database from either Derby or MS SQL to Oracle. These steps apply to WCC versions 11.3.5, 11.3.6, and 11.4 only.

Instructions:

 

1. Create the Oracle Schema

While WCC will automatically create the objects for its database, the schema must first be created by your Oracle DBA using the following guidelines...

  • Do not specify an administrator as the database user.
  • The database user must have Connect, Create/alter table, Create/Drop Index and Create Sequence permissions for the database.
  • A copy of the tnsnames.ora file will need to exist on the WCC server if the Oracle DB is on a different server.
  • The user that owns and runs the WCC services must have read permissions on the tnsnames.ora file on the WCC server.
  • SYS is not a valid user name
  • When you create the database schema for CA WCC, we recommend that you specify at least 100 MB for the tablespace. Alternatively, you can specify tablespace autoextending.

 

2. Backup Configuration and Monitoring Data

Since WCC configuration and monitoring view data are stored in the database, you will need to backup this data from the current database so that it can be imported into the new Oracle schema. If you are running multiple WCC servers as part of an HA environment, you will only need to run these commands on one of the servers.

To backup the configuration, run...

For UNIX/LINUX...

<WCC_INSTALL_DIRECTORY>/bin wcc_config.sh -u <user> -p <password> -x wcc_cfg.txt -plainpwd

For Windows...

<WCC_INSTALL_DIRECTORY>\bin wcc_config.bat -u <user> -p <password> -x wcc_cfg.txt -plainpwd

To backup the monitoring data, run...

For UNIX/LINUX...

<WCC_INSTALL_DIRECTORY>/bin wcc_monitor.sh -u <user> -p <password> -x wcc_mon.txt -plainpwd

For Windows...

<WCC_INSTALL_DIRECTORY>\bin wcc_monitor.bat -u <user> -p <password> -x wcc_mon.txt -plainpwd

The <user> and <password> specified in the commands above can be any WCC user that has Commander-level permissions.

Save the .txt files to be used to import the data into the new Oracle database.

 

3. Point WCC to the new Oracle database.

Stop all of the WCC services. If you have multiple WCC servers as part of an HA environment, stop the services on all WCC servers.

Run the following command to change the WCC database configuration...

For UNIX/LINUX...

<WCC_INSTALL_DIRECTORY>/bin/wcc_config.sh -u <user> -p <password> --dbplatform ORACLE --dbuser <db_user> --dbpassword <db_password> --dbtnspath <tnsnames.ora path> --dbtnsname <tns_alias>

For Windows...

<WCC_INSTALL_DIRECTORY>\bin\wcc_config.bat -u <user> -p <password> --dbplatform ORACLE --dbuser <db_user> --dbpassword <db_password> --dbtnspath <tnsnames.ora path> --dbtnsname <tns_alias>

where...

<user> - any WCC user with Commander-level permissions

<password> - password for the WCC user

<db_user> - Oracle user that owns the WCC schema

<db_password> - Oracle password for <db_user>

<tnsnames.ora path> - path to the tnsnames.ora file on the WCC server. This must include the filename.

<tns_alias> - TNS alias for the Oracle database.

NOTE: If you have multiple WCC servers as part of an HA environment, this command must be run on each server.

 

4. Create WCC objects in Oracle

To create the database objects in the new Oracle database, you will just need to restart the WCC services. The objects will be created automatically since they do not yet exist. If you have multiple WCC servers as part of an HA environment, only start the services on one of the servers initially. Do not start the services on the other servers until you are able to successfully login to WCC on the first server.

 

5. Import Configuration and Monitoring Data

Once you have verified that you are able to successfully login to the WCC server(s) with the new database configuration, you are ready to import the configuration and monitoring data that was backed up prior to the change. If you are running multiple WCC servers, you will only need to run the import on one of the servers.

To import the configuration using the files created in step 2, run...

On UNIX/LINUX...

<WCC_INSTALL_DIRECTORY>/bin wcc_config.sh -u <user> -p <password> -i wcc_cfg.txt

On Windows...

<WCC_INSTALL_DIRECTORY>\bin wcc_monitor.sh -u <user> -p <password> -i wcc_mon.txt

<user> and <password> will be the same WCC Commander-level user that you have been using throughout this procedure.

 

Your WCC should now be using Oracle and have all of the configuration and monitoring data restored.