Installation of a Remote Oracle MDB

Installation of CA ITCM › Management Database (MDB) › Preparing to Work with an Oracle MDB › Installation of a Remote Oracle MDB

Installation of a Remote Oracle MDB

To install a remote oracle MDB, you must first create an oracle instance using the Oracle Database Configuration Assistant on a remote computer running a Sun Solaris operating system

To install the Oracle MDB

Log on to the Solaris host as the "root" user and navigate to DVD_mount/SolarisProductFiles_MDB/remotemdb.
Run sh ./setup.sh
Select the Choose Language Setup option.
Available languages for the installation wizard are English, French, German, and Japanese.
Select New Instance and follow the instructions in the wizard.
Important! Make note of the values and passwords you enter in the following steps because you will need them later when configuring the DSM manager.
You must read and accept the End User License Agreement before the installation wizard will continue.
For the ORACLE_HOME environment variable, enter the path of the Oracle installation that you want to use for the MDB.
The installer checks the hardware platform and ORACLE environment. If any tests fail, then installation will not take place. Only if all testing is successful will the user be able to progress through the installation wizard.
Select a "product instance name" for the current installation. Usually this is the same name as the ORACLE instance (SID).
The Product Name Selection drop-down list displays names that are already used. The product instance name must be unique.
Enter the password for the MDB user name (ca_itrm).
The password is set during installation and confirmation is requested. The password should be remembered.
Enter the DB Administrator name (default name "sys") and the DB Administrator password. The DB Administrator is a username that has been given the SYSDBA privilege in the Oracle instance.
Note: For more information, see the MDB Overview, which is part of the CA ITCM documentation set (Bookshelf).
Specify whether to install the compatibility mode.
Note: The Compatibility mode check box must be selected if you are going to install a new MDB 1.5 as shipped with the product and you have planned to later install another CA Technologies product that only supports MDB 1.0.4. If the Compatibility mode check box is not selected, the installation of any follow-up product that does not support MDB 1.5 will fail.

Default: Compatibility mode is not selected.
In the MDB Database field, enter the SID of the Oracle database instance you want to use for the MDB.
The value of this field defaults to the product instance name entered on the previous wizard page.
Specify the database port number.
Default: 1521

Important! The port number you enter here depends on the port number used when the database was created. If a non-default port number was used at the time of database creation, then the same port number must be entered while installing the MDB. Otherwise, do not change the default database port number.
Enter the table space path, that is, the directory where Oracle creates the database files. All directories along this path must already exist, except the last one. For example, in the default path preset in the wizard, the directory "mdb" must not exist.
Default: /opt/CA/SharedComponents/oracle/mdb
In the MDB Administrator Password field you must supply the password of the MDBADMIN user.
The MDBADMIN database user is used to create the MDB schema and is the owner of the schema.
At the Install MDB stage in the wizard process, you must confirm the installation by clicking the Install button.
Only after this confirmation does the MDB schema get created in the Oracle database.

Important! If you are using a remote Oracle MDB, an Oracle 11g Client must be available on the manager and on every system where a DSM engine or the DSM Reporter is running. Make sure that the Oracle 11g client of type "Administrator" is installed.

More information:

Oracle MDB Maintenance