My Oracle Support Banner

Database Setting SQLNET.ALLOWED_LOGON_VERSION, And The Implications Of Using SQLNET.ALLOWED_LOGON_VERSION=12 in E-Business Suite Environments (Doc ID 2216959.1)

Last updated on OCTOBER 08, 2019

Applies to:

Oracle Applications DBA - Version to 12.2.6 [Release 11.5.10 to 12.2]
Oracle E-Business Suite Technology Stack - Version to 12.2.6 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.


E-Business Suite Applications Technology Stack, Database for Applications Technology issues

Resolve issues with connectivity for APPS user from the EBS application node, after setting SQLNET.ALLOWED_LOGON_VERSION=12.

Users report they are unable to connect to APPS from the database node successfully and the following error is received:


ebs@tst$ sqlplus apps/****
SQL*Plus: Release - Production on Tue Dec 20 13:51:13 2016


Copyright (c) 1982, 2005, Oracle. All rights reserved.
ORA-01017: invalid username/password; logon denied


The document with discuss whether it is advisable to set SQLNET.ALLOWED_LOGON_VERSION=12 in EBS Environments, and what the impact / implications are for setting the parameter.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.