How to reconfigure CA Business Intelligence (CABI) to use the new single node Oracle DB server for the Central Management Server (CMS) database

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

Summary:

How to reconfigure CA Business Intelligence (CABI) to use the new single node Oracle DB server for the Central Management Server (CMS) database

Environment:

SDM 12.7, 12.9

Instructions:

  1. Backup existing CABI CMS database from Oracle RAC environment
  2. Restore CABI CMS database to new single node Oracle DB server. Ensure that the users and permissions are restored as well.
  3. On CABI server, ensure that the proper ODBC connection(s) are created to communicate successfully via ODBC and TNS Name.
  4. On the CABI server, launch the Central Configuration Manager (CCM) and stop the SIA process

    Figure 1
  5. Click on the 'Specify New Data Source' icon on the menu bar

    Figure 2
  6. Select 'Update Data Source Settings' and click OK

    Figure 3
  7. Select ORACLE NATIVE DRIVER and click OK

    Figure 4
  8. Enter proper connection details for new Oracle DB server

    Figure 5
  9. Restart the SIA process via the CCM

    Figure 6
  10. Wait a few minutes to allow for all the CABI processes to fully initiate
  11. Test accessing CABI Central Management Console and running CABI reports via Infoview.