KnownOracleListener Table

Records any discovered Oracle listeners that a DiscoveredDevice is providing.

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 KnownOracleListener table

Database Column

Details

KnownOracleListenerID

Type: integer. Key. Generated ID

Unique id for the known listener.

DeviceID

Type: integer. Key

Device identity number. Foreign key to the DiscoveredDevice table.

Port

Type: integer. Key

Port for this listener.

Name

Type: text (max 128 characters)

The name of the service provided by the device.

Version

Type: text (max 32 characters)

The version 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 listener is discovered using remote discovery, false otherwise.

DiscoveredLocally

Type: boolean

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

DiscoveredViaTNSNames

Type: boolean

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

DiscoveredViaRDS

Type: boolean

True means this listener is discovered by the AWS adapter from the AWS API.