Continiously getting the deprecated SQLNET.ALLOWED_LOGON_VERSION parameter error in alert log in Oracle 12cr2

Problem: Continiously getting the deprecated SQLNET.ALLOWED_LOGON_VERSION parameter error in alert log in Oracle 12cr2

Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
2019-01-22T09:21:33.072026+06:00
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
2019-01-22T09:22:33.094491+06:00
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
2019-01-22T09:23:33.117507+06:00
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
2019-01-22T09:24:33.140318+06:00
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
2019-01-22T09:25:33.164969+06:00
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.

Reason:

Currently the sqlnet.ora file contains the following parameter

SQLNET.ALLOWED_LOGON_VERSION=8

Solution:

Step 1: Remove SQLNET.ALLOWED_LOGON_VERSION parameter from sqlnet.ora.

Based on your environment, set the following parameters to a proper value:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10


[oracle@utility-db-serv admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /oraclehome/app/oracle/product/12.2.0.1/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
SQLNET.AUTHENTICATION_SERVICES=NONE
#SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10

WALLET_LOCATION =
   (SOURCE =
     (METHOD = FILE)
     (METHOD_DATA =
       (DIRECTORY = /oraclehome/app/oracle/admin/wallet)
     )
   )
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
[oracle@utility-db-serv admin]$

Step 2: Reload the the listener file

[oracle@utility-db-serv admin]$ lsnrctl reload

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-JAN-2019 09:26:02

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=utility-db-serv.bankasia-bd.com)(PORT=1521)))
The command completed successfully
[oracle@utility-db-serv admin]$

Step 3: Now check the alert log file.

Problem solved