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.