Installing › Installing CA Service Catalog › Run the Setup Utility › 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. If necessary, 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 for it. Use this information to complete the fields in the next steps.
   • Parameters for MDB on SQL Server
   • Parameters for MDB on Oracle
3. Complete the fields for Database Connectivity section.

   This step verifies that you can connect to the database. If the connection fails, verify the preparation tasks and the parameter values, and 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. Create an application user.
6. Click Save.
7. (Optional) Review the log files, as follows:

   The log files are visible after you have completed all tasks on the installation or upgrade program and have clicked Done to exit the program.

   • 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.