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 220.127.116.11 to 12.2.6 [Release 11.5.10 to 12.2]
Oracle E-Business Suite Technology Stack - Version 18.104.22.168 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 10.1.0.5.0 - 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