DBLINK 9i 连接11G 错误信息ora-01017,ora-02063的解决方法
在oracle9i中建立一个dblink指向一个oracle11g的数据库,用户名、密码配置完毕以后测试,抛出这样的错误码:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from <link_name>
然后不知所措,到网上一搜,找到一段英文解释,如下:
Cause
The following Bug 6738104 was logged for this issue which was closed as not a bug saying the cause being introduction of password case sensitivity feature in 11g
When one creates a database link connection, a user name and password for the connection needs to be defined. When the database link is created, the password is case sensitive. Before a user can connect from a pre-release 11g database to a 11g release database and as the password case sensitivity is enabled by default, you must re-create the password for this database link using all uppercase letters.
The reason you need to re-create the password using all uppercase letters is so that it will match how Oracle Database stores database link passwords. Oracle Database always stores this type of password in uppercase letters, even if the password had originally been created using lower or mixed case letters. If case sensitivity is disabled, the user can enter the password using the case the password was created in.
Solution
++ As the password case sensitivity is enabled by default, create the database link to the 11g database as shown below :
我的理解是这样的:当9i连接11g时,会自动将密码转化为大写,所以,如果11g的数据库用户密码中,如果有小写字母,应该全部改成大写,然后再去用9i去连接,问题就解决了。
分享到:
相关推荐
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
错误描述:oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查:有很多是oracle自身安装的问题,但是我这里服务器配置正常,监听正常,服务正常,远程可以ping通服务器。 这里主要是防火墙问题,解决办法: ...
ORA-12560 TNS 协议适配器错误
ORA-00604: 递归SQL层1出现错误 ORA-03106: 致命的双工通信协议错误 ORA-02063: 紧接着line(源于dblink) 以及 ORA-04052: 在查找远程对象时出错 ORA-00604: 递归SQL层1出现错误 ORA-03120: 双工转换例行程序:整数...
ORA-01036:非法的变量名/编号 oracle特有的错误
ORA-12154_TNS无法解析指定的连接标识符
NULL 博文链接:https://springlin.iteye.com/blog/1520668
告警日志里这两天一直显示这个错误: ORA-00600:internalerrorcode,arguments:[kcblasm_1],[103],[],[],[],[],[],[] TueAug1209:20:17CST2014 Errorsinfile/u01/app/oracle/admin/orcl/udump/orcl_ora_29974.trc: ...
NULL 博文链接:https://czwlucky.iteye.com/blog/964093
ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [13], [1990],这是我自己整理的,已经试验过了
服务器均为windows server 2012,oracle 为11.2,mysql 为5.7
oracel 常见 故障 解决 方法
官网中关于ORA-12560的解释: ORA-12560: TNS:protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting ...
12.1.2.0与11.2.0.4通过DB Link查询触发BUG 17890099, ORA-2072 AND ORA-2063 ON QUERY VIA DBLINK
本周由于公司一个系统的oracle数据库需要采集另一个系统mysql数据库的数据,于是对oracle通过dblink连接mysql进行了研究,测试环境是单实例oracle 10g 64位,折腾了半天搞定了,但是生产环境是10g rac,原本以为会很...
Linux下ORACLE 使用dblink连接mysql_lijilinjy的专栏-CSDN博客.mhtml
主要给大家介绍了关于Oracle在dbca时报:ORA-12547: TNS:lost contact错误的解决方法,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面来一起看看吧。
本文详细描述了在oracle10g或11g中使用dblink访问sql server,使用oracle的透明网关来访问异构的数据库,方便一些习惯使用oracle的开发人员操作sql server数据库
oracle通过DBlink连接mysql搭建过程