Banner Text Gets Truncated when Using SEC_USER_AUDIT_ACTION_BANNER and SEC_USER_UNAUTHORIZED_ACCESS_BANNER Parameters (Doc ID 1216213.1)

Last updated on MARCH 08, 2017

Applies to:

SQL*Plus - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Using SQL*Plus 11.1.0.7, you are trying to display a warning banner by setting SEC_USER_AUDIT_ACTION_BANNER and SEC_USER_UNAUTHORIZED_ACCESS_BANNER parameters in sqlnet.ora to point to text files with the desired banners.

The problem is that when making the connection, the banner text gets truncated.

For example, when attempting to use the following sample banner message:

**************WARNING****************
YOU HAVE CONNECTED TO A U.S. GOVERNMENT COMPUTER.
IF YOU ARE NOT AUTHORIZED ACCESS TO THIS SYSTEM, DISCONNECT NOW

All attempts to access and use this system and/or its resources are subject
to keystroke monitoring and recording. Everyone using this system expressly
consents to such monitoring and is advised that if such reveals possible
evidence of criminal activity or abuse of authority, the information will be
reported to authorities for action. Unauthorized access attempts or use in
excess of documented authority may subject you to a fine and/or imprisonment
in accordance with Title 18, USC, Section 1030 or administrative penalties
or dismissal.
**************WARNING****************



You are getting ONLY the following banner upon connection:

**************WARNING****************
YOU HAVE CONNECTED TO A U.S. GOVERNMENT COMPUTER.
IF YOU ARE NOT AUTHORIZED ACCESS TO THIS SYSTEM, DISCONNECT NOW

All attempts to access and use this system and/or its resources are subject
to keystroke monitoring and recording. Everyone using this system expressly
consents to such monitoring and is advised that if such reveals possible
evidence of criminal activity or abuse of authority, the information will be
reported to authorities for action. U



Why is the banner text being truncated?

Changes

Trying to set up the banner text.

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