After reloading the system, after the installation of Navicat, when connecting to the Oracle database, the following error occurred:
Ora-28547:connection to server failed,probable Oracle Net admin error, as follows:
650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/97/A2/wKioL1kwxPLid5t1AAFWaXxPdgU152.jpg "title=" Navicat.jpg "alt=" Wkiol1kwxplid5t1aafwaxxpdgu152.jpg "/>
Cause: After reinstalling the system, the Oracle client needs to be installed, and after we install the Oracle client, we'll see if this problem still exists.
Note: If you are in your native installed Oracle and then access the native database, you do not need to install additional clients, because the Oracle server will have the client
1. Oracle Client Download
To the official website to download the client, my side of the database version is 11.2.0.4.0, the official network does not provide clients, can only download 11.2.0.1.0 client
650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/97/AB/wKiom1kxDiyBxD_bAAT5PNKx4XU890.jpg "title=" 2.jpg "alt=" Wkiom1kxdiybxd_baat5pnkx4xu890.jpg "/>2, client Installation
In the middle may be prompted to have a condition does not pass, view the log, no effect, here has been the default
650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M01/97/AC/wKiom1kxDrqzDXEEAAIMcEuyKlM984.jpg "title=" 3.jpg "alt=" Wkiom1kxdrqzdxeeaaimceuyklm984.jpg "/>
3, the implementation of NETCA,
The following error occurred:
caused By:java.io.filenotfoundexception:d:\app\administrator\product\11.2.0\client_2\network\admin\tnsnames.ora (Access denied.) )
Workaround: Use the administrator to run NETCA, and then we'll create a Tnsname.ora file by the way
4, the client installed after, found Navicat or reported this error, Internet query, found nvicate more special, my toad has been able to use the normal, then continue to troubleshoot
This article is from the "Breeze Month Blog" blog, please be sure to keep this source http://watchmen.blog.51cto.com/6091957/1931582
Navicat error-ora-28547:connection to server failed,probable Oracle Net admin Error