ORACLE数据库报错:ora-02063/ora-01017 解决方法 - PHPERZ中文资讯站 - 胜博发888手机平台

发布于 2014-12-06 15:57:53 | 811 次阅读 | 评论: 1 | 来源: PHPERZ

这里有新鲜出炉的精品教程,程序狗速度看过来!

Oracle关系数据库管理系统

Oracle Database,又名Oracle RDBMS,或简称Oracle。是甲骨文公司的一款关系数据库管理系统。到目前仍在数据库市场上占有主要份额。


本文为大家讲解的是创建dblink ORACLE数据库报错:ora-02063/ora-01017 解决方法,感兴趣的同学参考下。

问题描述:

一回家,某运营商电话至,创建dblink报错ora-02063/ora-01017 

关于这个BUG,遇到不是一次了,ORACLE对于该BUG 描述如下

Bug 6738104: ORA-01017 ORA-02063 WHILE CONNECTING FROM10G TO 11G VIA PUBLIC DBLINK
 
错误原因:
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库时,默认会将密码改为大写。

解决方法:

重新创建dblink,密码使用双引号+小写即可

例:

create database link db_test
connect to wxboss
identified by "wxboss"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.99.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = wxboss)
)
)';



相关阅读 :
ORACLE数据库报错:ora-02063/ora-01017 解决方法
oracle启动报错:ORA-00845: MEMORY_TARGET not supported on this system解决办法
oracle错误 ora-01017解决方法
Linux中Oracle启动侦听报错TNS:permission denied的解决方法
oracle12c安装报错:PRVF-0002的解决方法
连接oracle报错“ORA-28547:connection to server failed,probable Oracle Net admin 解决办法
oracle数据库报ORA-01839的错误解决方法
plsql连接oracle数据库报ora 12154错误解决方法
解决报错ora-32035的方法分析
在客户端配置TNS测试报错ORA-12170:TNS:连接超时
Orcle的package中访问其它Schema的表报错ORA-00942解决方法
Oracle出现超出打开游标最大数的解决方法
最新网友评论  共有(1)条评论 发布评论 返回顶部
srvehu 发布于2015-01-09 11:35:58
感谢
支持(0)  反对(0)  回复
月排行榜

Copyright © 2007-2017 PHPERZ.COM All Rights Reserved   冀ICP备14009818号  版权声明  服务