Oracle Catalog discovery

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：4分

    • The Discovery and Service Mapping Patterns application uses the Get Catalog info pattern extension of the Oracle DB on Unix and Oracle DB on Windows patterns to find Oracle Catalog objects. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

    Discovery uses the Oracle DB on Unix and Oracle DB on Windows patterns and the Get Catalog info pattern extension to run horizontal discovery.

    You can use this pattern on the ServiceNow AI Platform® using the Madrid release or later.

    For information on Oracle database discovery, see Oracle database discovery.

    Request apps on the Store

    Visit the ServiceNow Store to view all the available apps, and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

    Prerequisites

    Provide a user with permissions to run queries on ALL_TABLES
    Provide a user with permissions to run queries on ALL_TABLES.
    To view other users' tables in ALL_TABLES, a user must have any of the following permissions:
    • Object-level privileges, for example: SELECT.
    • Higher-level role, for example: SELECT ANY TABLE.
    Configure applicative credentials
    Configure applicative credentials for the Oracle instance [cmdb_ci_db_ora_instance] CI type. For more information, see Applicative credentials.
    Configure Windows credentials for Windows operating system (OS)
    For more information, see Windows credentials.
    Configure UNIX credentials for UNIX OS
    For more information, see SSH credentials.

    Data collected by Discovery during horizontal discovery

    Discovery populates the data in the CMDB when running the Get Catalog info Pattern extension.
    Table and field Description
    Oracle Catalog [cmdb_ci_db_ora_catalog​]
    database_instance The name of the database instance​ (SID​).
    name The name of the CI in the CMDB; schema and SID​.
    schema The name of the catalog object.
    The following is a dependency view of the relationship between an Oracle Catalog and an Oracle instance.
    CIs and connections on a Dependency Views map

    CI relationships

    This relationship is created to support Oracle Catalog discovery.
    CI Relationship CI
    ​Oracle Catalog [cmdb_ci_db_ora_catalog​] Contains::Contained by Oracle Instance [cmdb_ci_db_ora_instance]