Application setup requirements for Oracle database discovery

Last published : Jun 19, 2026
For Oracle database discovery, ensure that InfoScale Operations Manager Management Server environment and Oracle database are properly configured. For the supported versions of Oracle database, refer to the InfoScale Operations Manager Hardware and Software Compatibility List (HSCL).
Oracle database discovery prerequisites
For InfoScale Operations Manager to discover Oracle database, the home directory of the Oracle database must be accessible. To access the home directory of the database, one of the following prerequisites must be met. If none of the two prerequisite are met, no detail about the Oracle database is discovered. It is also applicable to the discovery of Oracle Real Application Clusters (RAC).
  • The Oracle database is clustered using Cluster Server.
  • For Oracle database discovery on Unix/Linux operating systems, the oratab file must have the Oracle database listed along with its proper home directory. For Windows operating system, InfoScale Operations Manager agentlet reads the Windows registry to get the Oracle database configuration details.
Permissions to system tables
When you perform discovery of Oracle databases, ensure that you have the right permission to the following system tables:
ALL_ARGUMENTS ALL_TAB_COMMENTS DBA_TS_QUOTAS
ALL_CATALOG ALL_TRIGGERS DBA_USERS
ALL_COL_COMMENTS ALL_TRIGGER_COLS DBA_VIEWS
ALL_CONSTRAINTS ALL_TYPES DICTIONARY
ALL_CONS_COLUMNS
ALL_DB_LINKS ALL_UPDATABLE_COLUMNS DICT_COLUMNS
ALL_ERRORS
ALL_INDEXES ALL_USERS GLOBAL_NAME
ALL_IND_COLUMNS ALL_VIEWS NLS_DATABASE_PARAMETERS
ALL_LOBS DATABASE_COMPATIBLE_LEVEL NLS_INSTANCE_PARAMETERS
ALL_OBJECTS DBA_DB_LINKS NLS_SESSION_PARAMETERS
ALL_OBJECT_TABLES DBA_ERRORS PRODUCT_COMPONENT_VERSION
ALL_SEQUENCES DBA_OBJECTS ROLE_TAB_PRIVS
ALL_SNAPSHOTS DBA_ROLES SESSION_PRIVS
ALL_SOURCE DBA_ROLE_PRIVS SESSION_ROLES
ALL_SYNONYMS DBA_SOURCE SYSTEM_PRIVILEGE_MAP
ALL_TABLES DBA_TABLESPACES TABLE_PRIVILEGES
ALL_TAB_COLUMNS DBA_TAB_PRIVS TABLE_PRIVILEGE_MAP
ALL_TAB_COL_STATISTICS DBA_TRIGGERS -
Oracle database discovery
InfoScale Operations Manager discovers the Oracle database using the following methods:
  • Automatic discovery: It is the default discovery method. After you install the VRTSsfmh package, and add the host to the InfoScale Operations Manager Management Server domain, the database family of InfoScale Operations Manager automatically gathers Oracle configuration information. The agentlet uses sysdba user account for the discovery. If the password exists for sysdba user account, InfoScale Operations Manager agentlet fails to perform the automatic discovery. If required, you can stop the automatic discovery of Oracle database, as described in the following procedure.
  • Manual Discovery: If the automatic discovery is not possible (since the password is required), the database is listed in the Server perspective of the Management Server console with the discovery state as Partial (needs credentials). In this scenario, right-click the database, and select Set Credentials. Enter the user name and password for the Oracle database connection.
You can stop the automatic discovery of Oracle database if you do not want the InfoScale Operations Manager database agentlet to automatically discover the database.
To stop the automatic discovery of Oracle database
  1. In the Home page on the Management Server console, click Settings.
  2. Click Host.
  3. In the host listing page, select the host for which you want to stop the database discovery.
  4. Right-click the host and then select Properties.
  5. Click the Discovery families tab.
  6. For the DB family, click the pause button. It will stop the subsequent discovery of the database family on the host. Once you pause the family, the Frequency column shows the status as Paused. Click the play button to restart the database discovery.
More Information
SQL queries used for the discovery of Oracle database
Oracle database discovery in Solaris zones