ora-01017 ora-02063 database link，oracle11.2g通过dblink连接oracle11.2g

本文主要是介绍ora-01017 ora-02063 database link，oracle11.2g通过dblink连接oracle11.2g，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

错误图示：

问题解决

All database links, whether public or private, need username/password of the remote/target database. Public db links are accessible by all accounts on the local database, while private db links are only accessible in the schema they are defined in. So, as suggested earlier, if you drop your public database links and recreate them exactly as you did for the fprchr account (CREATE PUBLIC DATABASE LINK …. CONNECT TO … IDENTIFIED BY … USING …) then your queries will work using any account on the local database.

也就是以public创建dblink就解决了。

这篇关于ora-01017 ora-02063 database link，oracle11.2g通过dblink连接oracle11.2g的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---