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

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>

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

   <Please see attached file for image>

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

   <Please see attached file for image>

   
7. Select ORACLE NATIVE DRIVER and click OK
   
   

   <Please see attached file for image>

   
8. Enter proper connection details for new Oracle DB server
   
   

   <Please see attached file for image>

   
9. Restart the SIA process via the CCM
   
   

   <Please see attached file for image>

   
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