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

book

Article ID: 17662

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

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

    <Please see attached file for image>

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

    <Please see attached file for image>

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

    <Please see attached file for image>

    Figure 3
  7. Select ORACLE NATIVE DRIVER and click OK

    <Please see attached file for image>

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

    <Please see attached file for image>

    Figure 5
  9. Restart the SIA process via the CCM

    <Please see attached file for image>

    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.

Environment

Release:
Component: SDBOXI

Attachments

1558709315004000017662_sktwi1f5rjvs16rey.gif get_app
1558709313061000017662_sktwi1f5rjvs16rex.gif get_app
1558709311353000017662_sktwi1f5rjvs16rew.gif get_app
1558709309483000017662_sktwi1f5rjvs16rev.gif get_app
1558709307811000017662_sktwi1f5rjvs16reu.gif get_app
1558709304128000017662_sktwi1f5rjvs16ret.gif get_app