Previous Topic: Oracle ObjectsNext Topic: Oracle User Privileges

Managing Oracle Databases › Registering Oracle Databases

Registering Oracle Databases

To register and collect data from Oracle databases, follow these steps:

  1. You need at least one Windows managed computer with the Oracle ODBC driver and the Oracle client installed. CA SRM uses this computer as a Proxy Collector for Oracle. You need to select the Runtime option during the Oracle Client installation on the proxy machine.

    After you install the ODBC on the proxy machine, you need to reboot and then perform a Collect Now on that machine. This informs CA SRM that the ODBC is installed.

  2. You need an Oracle user for each managed instance that has enough privileges to retrieve the data collected by CA SRM. You can create this user by using the Registration wizard or you can manually execute the SQL script file located in the following directory of each Proxy Collector computer: 
    X:\CA SRM Data\database\configuration\CreateOracleUser.sql

    Where X:\ CA SRM Data specifies the location where you choose to put the configuration data.

  3. Make sure you have the appropriate privileges for your users. See the Oracle User Privileges section.
  4. Register the Oracle database using the CA SRM Oracle Registration Wizard. For information about registering the Oracle database, see Using the CA SRM Oracle Registration Wizard in this chapter.

For a list of supported versions see the latest Readme file on supportconnect.com

Note: If you want to cross-reference data between the Oracle data files and their related volumes in the file-system make sure you also have the Oracle server computer registered as a managed computer.