SEC_USER_UNAUTHORIZED_ACCESS_BANNER
Purpose::
To specify a text file containing the banner contents that warn the user about possible user action auditing. The complete path of the text file must be specified in the sqlnet.ora file on the server. Oracle Call Interface (OCI) applications can make use of OCI features to retrieve this banner and display it to the user. The text file has a maximum limit of 512 bytes.
node1: /data2/1930/network/admin $ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /data2/1930/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME, EZCONNECT)
SEC_USER_UNAUTHORIZED_ACCESS_BANNER = /home/oracle/banner.txt
node1: /home/oracle $
node1: /home/oracle $ cat banner.txt
Welcome to RnD DB
node1: /home/oracle $
Post, need to restart the database to changes get effected
node1: /home/oracle $ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 2 22:56:47 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
node1: /home/oracle $
node1: /home/oracle $ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 2 22:57:53 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Welcome to RnD DB <<<--- Welcome message
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area xxxxx bytes
Fixed Size xxxxx bytes
Variable Size xxxxx bytes
Database Buffers xxxxx bytes
Redo Buffers xxxxx bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
node1: /home/oracle $
Cheers !
