How to add any missing Indexes/Procedures/Foreign Keys/Triggers back to the CA Service Desk Manager (SDM) MDB Oracle database?

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

Description:

Consider a scenario where you have setup a development CA SDM environment with a copy of the Production MDB. During this process, the database triggers did not get carried over. This document explains the steps to take to add them back into the MDB.

Solution:

  1. Access the file system of the MDB database server

  2. Take the back-up of the existing MDB database using normal DB backup procedures

  3. On the MDB server's file system, rename the existing directory "MDB" in the CA Shared Components directory to something else.

    1. If the MDB Server is a Unix/Linux based system, then the default CA SharedComponents directory is either /opt/CA/SC or /opt/CA/SharedComponents. Rename the directory /opt/CA/SC/Mdb or /opt/CA/SharedComponents/Mdb to /opt/CA/SC/Mdb_ORIGINAL or /opt/CA/SharedComponents/Mdb_ORIGINAL

    2. If the MDB Server is a Windows based system, then the default CA SharedComponents directory is C:\Program Files (x86)\CA\SC or C:\Program Files (x86)\CA\SharedComponents. Rename the C:\Program Files (x86)\CA\SC\Mdb or C:\Program Files (x86)\CA\SharedComponents\Mdb to C:\Program Files (x86)\CA\SC\Mdb_Original or C:\Program Files (x86)\CA\SharedComponents\Mdb_Original

  4. Mount the CA SDM DVD1 install media which contains the MDB setup program

  5. Run the CA SDM setup.exe or setup.sh program to launch the CA SDM Installer GUI

  6. Select the Product Installs tab

  7. Select the CA MDB option in the Product Installs tab (its option number 1 in the list)

  8. Fill out the appropriate details about your MDB and let the CA MDB installer finish

  9. Review the latest CA MDB install log file to verify that any missing triggers/foreign keys/procedures/indexes are added properly.

    • On Linux/Unix it is /opt/CA/SC/Mdb/logs/install_<OracleSID>_<Timestamp>.log file

    • On Windows it is C:\Program Files (x86)\CA\SC\Mdb\logs\install_<Timestamp>.log

  10. Execute CA SDM 'pdm_configure' program to complete the CA SDM Configuration.

Important Notes:

  1. Make sure to take a full MDB database backup before starting any process that effects the MDB.

  2. Make sure to use the correct release/version of CA SDM installer during this process. If you are intending to use SDM 12.6 CA SDM against the MDB, make sure you run the CA MDB Installer via the CA SDM 12.6 CA SDM DVD.

  3. Engage CA Support for further assistance if you are not sure which route to take.