Shulou(Shulou.com)06/01 Report--

Although it can be solved in sqlnet.oraplus SQLNET.ALLOWED _ LOGON_VERSION=8, because this parameter has been abandoned at 12c, if it continues to be used, it will report "Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter." endlessly in alert/log.xml.

Therefore, the right thing to do is to add "SQLNET.ALLOWED_LOGON_VERSION_SERVER=8" to $ORACLE_HOME/network/admin/sqlnet.ora.

Oracle12c abandoned SQLNET.ALLOWED_LOGON_VERSION and replaced it with SQLNET.ALLOWED_LOGON_VERSION_CLIENT and SQLNET.ALLOWED_LOGON_VERSION_SERVER.

The differences are as follows:

SQLNET.ALLOWED_LOGON_VERSION_SERVER: controls the client version that can connect to 12c databases (client-- > orace 12c db)

SQLNET.ALLOWED_LOGON_VERSION_CLIENT: controls which versions of the database 12c databases can connect to (orace 12c db-- > other versions of oracle db), for example, controls which versions of oracle libraries can be connected to through DB LINK.

Special attention should be paid to:

(1) if it is RAC, because RAC is a listener that uses grid, many people think that it is adding "SQLNET.ALLOWED_LOGON_VERSION_SERVER=8" to "/ u02/app/12.1.0/grid/network/admin/sqlnet.ora". In fact, this is wrong, but it is still adding "SQLNET.ALLOWED_LOGON_VERSION_SERVER=8" to $ORACLE_HOME/network/admin/sqlnet.ora.

(2) the version mentioned above refers to the version of dba_users.password_versions.

Official reference document: http://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2010

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.