关于SQLNET.ORA中的参数SQLNET.ALLOWED_LOGON_VERSION

jiawang

This issue is caused by the default setting for allowed logon version in the 12 database.
Note that the SQLNET.ALLOWED_LOGON_VERSION parameter has been deprecated in 12c.
That parameter has been replaced by these:


SQLNET.ALLOWED_LOGON_VERSION_SERVER=n
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=n


The default setting for the new parameters is 11.  Any client that attempts to connect must
be at version 11 or higher unless these parameters are explicitly set in the server side sqlnet.ora file.

可以看出，该参数在12c中已经被废弃了，被另外两个参数所取代（SQLNET.ALLOWED_LOGON_SERVER,SQLNET.ALLOWED_LOGON_CLIENT）。


接着看下SQLNET.ALLOWED_LOGON_VERSION的作用：


看文章：Doc ID 402193.1


Use the sqlnet.ora parameter SQLNET.ALLOWED_LOGON_VERSION to specify which authentication protocols are allowed by the client or database. This parameter defines the minimum Client Oracle version that is allowed to connect to the database.  This parameter has been introduced in 10g which replaces the init.ora parameter DB_ALLOWED_LOGON_VERSION.


即该参数用来限制可以连接到数据库服务器上的最小客户端版本，比如设置值为10，即10g，11g等以上客户端版本可以连接到数据库服务器上。