"Client Terminal" Is Not Captured When Connecting To the Database In Non-interactive Mode

(Doc ID 2339225.1)

Last updated on APRIL 09, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

At present the "Terminal" info (as part of Mandatory Auditing) is not getting captured if one connects to the database as SYS and execute any query using these methods.

1. When the query is piped into sqlplus



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms