开发者社区> snowofsummer> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter

简介: Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
+关注继续查看

由于12c弃用了SQLNET.ALLOWED_LOGON_VERSION参数。
使用如下参数替代:
SQLNET.ALLOWED_LOGON_VERSION_SERVER = n
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = n

官方说明:

12c Database Alert.log File Shows The Message: Using Deprecated SQLNET.ALLOWED_LOGON_VERSION Parameter (文档 ID 2111876.1)

解决方法:

In order to suppress these messages in the alert log of the database, you need to use the new parameters for the 12c database.

 STEPS:

 1. Edit the sqlnet.ora file of the 12c database. (This needs be done on each database on 12c). So for example if both your EBS and CCG databases are on 12c, you need to do this on each sqlnet.ora file. Typically, the sqlnet.ora file that would be referenced by the database is located in RDBMS_HOME/network/admin

 2. Remove or comment the following entry.

    SQLNET.ALLOWED_LOGON_VERSION

 3.You need to follow the instructions below:

 3a. Add the following two new Oracle Net Services parameters:

    SQLNET.ALLOWED_LOGON_VERSION_SERVER = n
    SQLNET.ALLOWED_LOGON_VERSION_CLIENT = n

    Specify the value for 'n' based on your own environment. 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.       

   3b. For example: Set these parameters at the lowest version level that is required in your environment.
        The example shpow below shows the following: All clients at version 10 or higher would require this setting:

       SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
       SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10

    3c. Note that SQLNET.ALLOWED_LOGON_VERSION_CLIENT would be necessary on the server when the database is 'acting' as a client. Such as the case of a database link as in the case of CCG applications.

    3d. Even though the parameter value implies Oracle version 10 the internal check is really against the authentication protocol 'SHA-1'

    3e. For CCG, you can just set the parameter value to 10, since SHA-2 is currently not certified with CCG.

    3e. See the following reference for more information about these settings.
         https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2010

4. For setting up the values for step 3, you can also refer to the additional info section at the end of the note.

4. Bounce the database.

5. Bounce the application server.

报错日志:

Tue Nov 13 19:17:06 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:06 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:07 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:12 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:17 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:17 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:17 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:21 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:21 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:21 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:22 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:22 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:26 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:27 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:27 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:27 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:27 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Tue Nov 13 19:17:32 2018
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.
Using deprecated SQLNET.ALLOWED_LOGON_VERSION parameter.

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually
Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually
0 0
SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required
获取数据库连接失败! java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required at com.
6995 0
MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)
在mysql中执行以下命令:   drop database hive;   create database hive;   alter database hive character set latin1;   重启hive
2014 0
SQL Server Parameter Sniffing及其改进方法
上一篇我们谈到,SQL Server 在处理存储过程的时候,为了节省编译时间,是一次编译,多次重用。当第一次运行时代入值产生的执行计划,不适用后续代入的参数时,就产生了parameter sniffing问题。
3197 0
Error "ORA-28040: No matching authentication protocol" When Using SQLNET.ALLOWED_LOGON_VERSION (Doc
Error "ORA-28040: No matching authentication protocol" When Using SQLNET.
791 0
SQLNET.ALLOWED_LOGON_VERSION = 10 参数引起的ORA-28040故障一则:
SQLNET.ALLOWED_LOGON_VERSION = 10  参数引起的ORA-28040故障一则: 环境: Database:Oracle 11gR2 (11.
875 0
MS SQL Could not obtain information about Windows NT group/user 'domain\login', error code 0x5. [SQLSTATE 42000] (Error 15404)
最近碰到一个有趣的错误:海外的一台数据库服务器上某些作业偶尔会报错,报错信息如下所示: ---------------------------------------------------------------------------------------------------------...
801 0
SQL Server 2005 sp_send_dbmail出现Internal error at FormatRowset (Reason: Not enough storage is available to complete this operation)
案例环境:   操作系统: Windows 2003 SE 32bit(SP2) 数据库版本:Microsoft SQL Server 2005 - 9.00.5069.00 (Intel X86)             Aug 22 2012 16:01:52           ...
975 0
+关注
文章
问答
文章排行榜
最热
最新
相关电子书
更多
Scaling Spark applications by connecting code to resource consumption
立即下载
Dynamic DDL Adding Structure to Streaming Data on the Fly
立即下载
KR^X- Comprehensive- Kernel-Protection-Against-Just-In-Time-Code-Reuse
立即下载