Installing › Installing CA Service Catalog › Run the Setup Utility on All CA Service Catalog Computers › Set Up the Database

Set Up the Database

Set up the database so that CA Service Catalog users and the Catalog system can function correctly.

Follow these steps:

1. Log in to the setup utility and click Database on the left menu.

   The utility displays the page for connecting to the database and configuring it.

2. Select the DBMS that you are using and review the parameters:
   • Parameters for MDB on SQL Server
   • Parameters for MDB on Oracle

   Use this information to complete the fields in the next steps.

3. Complete the fields for the Database Connectivity section.

   This step verifies that you can connect to the database. If the connection fails, perform these actions:

   1. Verify the parameter values.
   2. Verify that you prepared the catalog database and the DBMS.
   3. Try the test again.
4. In the Database Settings section, specify the name of the CA Service Catalog database, typically MDB.

   This step installs or upgrades the MDB, if necessary. This step also configures the CA Service Catalog database in the MDB.

5. Complete the remaining database fields.
6. Specify the details for the application user that you created earlier.
7. Save and confirm your updates.

   The database deployment starts.

8. (Optional) Review the log files, as follows:
   • For log information for SQL Server, see the following sources:
     • See the install_mdb.log file in your MDB target installation directory. This directory is specified in %TEMP%\MDB1.5, where %TEMP% is a Windows environment variable. If the MDB installation fails, review the log files in this location.
     • After a successful installation of the MDB, the install_mdb.log file is copied to the %ProgramFiles%\CA\SC\Mdb\Windows\logs folder. This log file is renamed to install_mdb_mm-dd,hh_mm_ss.log (for example, install_mdb_12-03,15_29_05.log).
     • See the view.log file. Its default location is the C:\Program Files\CA\Service Catalog\logs folder.
   • For log information for Oracle, see the following sources:
     • See the install_connectionID.log file in your MDB target installation directory. For example, if the connection ID is myhost_orcl, the install_connectionID.log file name is install_myhost_orcl.log. The MDB target installation directory is specified in %TEMP%\MDB1.5, where %TEMP% is a Windows environment variable. If the MDB installation fails, review the log files in this location.
     • After a successful installation of the MDB, the install_connectionID.log file is copied to %ProgramFiles%\CA\SC\Mdb\Windows\logs. This log file is renamed to install_ connectionID_mm-dd,hh_mm_ss.log, for example, install_myhost_orcl_12-03,15_29_05.log.
     • See the view.log file. Its default location is the C:\Program Files\CA\Service Catalog\logs folder.

You have set up the database. Next, you configure CA EEM.