低版本使用dblink连接11G版本时报错ora-02063/ora-01017
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了低版本使用dblink连接11G版本时报错ora-02063/ora-01017,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含1869字,纯文字阅读大概需要3分钟。
内容图文
一回家,某运营商电话至,创建dblink报错ora-02063/ora-01017 关于这个BUG,遇到不是一次了,ORACLE对于该BUG 描述如下 Bug 6738104: ORA-01017 ORA-02063 WHILE CONNECTING FROM10G TO 11G VIA PUBLIC DBLINK Cause The following Bug 6738104 was logged f
一回家,某运营商电话至,创建dblink报错ora-02063/ora-01017
关于这个BUG,遇到不是一次了,ORACLE对于该BUG 描述如下
Bug 6738104: ORA-01017 ORA-02063 WHILE CONNECTING FROM10G TO 11G VIA PUBLIC DBLINK
Cause
The following Bug 6738104 was logged for this issue which was closed as not abug saying the cause being introduction of password case sensitivity feature in11g
When one creates a database link connection, a user name and password for theconnection needs to be defined. When the database link is created, the passwordis case sensitive. Before a user can connect from a pre-release 11g database toa 11g release database
and as the password case sensitivity is enabled bydefault, you must re-create the password for this database link using alluppercase letters.
The reason you need to re-create the password using all uppercase letters is sothat it will match how Oracle Database stores database link passwords. OracleDatabase always stores this type of password in uppercase letters, even if thepassword had originally
been created using lower or mixed case letters. If casesensitivity is disabled, the user can enter the password using the case thepassword was created in.
当低版本通过dblink连接11G库时,默认会将密码改为大写。
solution就很简单啦,重新创建dblink,密码使用双引号+小写即可
例:create database link db_test
2 connect to wxboss
3 identified by "wxboss"
4 using '(DESCRIPTION =
5 (ADDRESS_LIST =
6 (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.99.100)(PORT = 1521))
7 )
8 (CONNECT_DATA =
9 (SERVER = DEDICATED)
10 (SID = wxboss)
11 )
12 )';
特此记录。
内容总结
以上是互联网集市为您收集整理的低版本使用dblink连接11G版本时报错ora-02063/ora-01017全部内容,希望文章能够帮你解决低版本使用dblink连接11G版本时报错ora-02063/ora-01017所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。