Use > Discovery Modules > Database > Oracle Database Server Discovery > Oracle Database Topology by SQL Adapter

Oracle Database Topology by SQL Adapter

This section includes details about the adapter.

ClosedID

Oracle database topology by SQL

ClosedInput CIT

Oracle

ClosedInput TQL

ClosedTriggered CI Data

Name

Value
credentialsId ${SOURCE.credentials_id}
ip_address ${SOURCE.application_ip}
port ${SOURCE.application_port:NA}
sid ${SOURCE.name:NA}
ClosedUsed Scripts

  • SQL_Dis_Oracle.py

ClosedDiscovered CITs
  • Composition
  • Containment
  • DB Client
  • DB Data File
  • DB Job
  • DB Link Object
  • DB Scheduler Job
  • DB Snapshot
  • DB Tablespace
  • DB User
  • DBA Object
  • DB_Archive File
  • DB_Control-File
  • DB_Re-do File
  • DB_Re-do File group
  • Dependency
  • IpAddress
  • IpServiceEndpoint
  • Membership
  • Node
  • Oracle
  • Oracle CDB
  • Oracle PDB
  • Oracle RAC
  • Oracle Schema
  • Oracle Service Name
  • Oracle TNS Listener
  • Ownership
  • Process
  • Realization
  • Resource
  • Usage
ClosedParameters
  • comprehensiveDiscovery. If false, the DBA Object, DB Job and DB User are not retrieved. The default value is false. If the parameter is set to false, changing other parameters has no effect on the discovery process (DBA Objects are not discovered).

  • discoverDbLinks. If true, DB links are discovered. The default value is true.

  • discoverFunctions. If false, functions are not retrieved. The default value is false.
  • discoverPackageBody. If false, package bodies are not retrieved. The default value is false.
  • discoverPackages. If false, packages are not retrieved. The default value is false.
  • discoverProcedures. If false, procedures are not retrieved. The default value is false.
  • discoverReportPageSize. The maximum amount of query result objects that can be sent in one bulk. The default value is 1,000.
  • discoverTables. If false, tables are not retrieved. The default value is false.
  • discoveryDBClients. If true, DB clients are retrieved. The default value is true.
  • discoveryUsers. If true, database users are retrieved. If false, database user discovery is controlled by the comprehensiveDiscovery parameter.
  • excludeSysUser. If false, system default users are included. The default value is false.
  • reportEmptySchemas. Indicates whether to report empty schemas. The default value is true.

Send Help Center feedback