KnownOracleService Table

Records any discovered Oracle services (databases) on a DiscoveredDevice.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for KnownOracleService table

Database Column

Details

KnownOracleServiceID

Type: integer. Key. Generated ID

Unique id for the known Oracle service.

KnownOracleListenerID

Type: integer. Key. Nullable

Listener identity number.

DeviceID

Type: integer. Key

Network device identity number. Foreign key to the DiscoveredDevice table.

Name

Type: text (max 128 characters). Key

The name of the service provided by the device.

ManuallyAdded

Type: boolean

Boolean field specifying whether the KnownService record has been manually added by the user.

DiscoveredRemotely

Type: boolean

True means this service is discovered using remote discovery, false otherwise.

DiscoveredLocally

Type: boolean

True means this service is discovered using local discovery, false otherwise.

DiscoveredViaTNSNames

Type: boolean

True means this service is discovered from a TNSNames file on an inventory beacon, false otherwise.