navicat毗连oracle数据库报ORA-28547: connection to server failed, proba
Navicat毗连ORACLE数据库非常失败毗连相干设置都正确，但是照旧报ORA-28547错误，多数是因为navicat本地的OCI版本与Oracle服务器器不符造成的，需设置对应版本的OCI文件
1.下载客户端
Instant Client for Microsoft Windows (x64) 64-bit
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNjViODkxODBkMzkwNDFmNWI4MmVjOGU4YzU3ODdjOGIucG5n
2.解压对应压缩包并在navicat设置对应oci环境
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMzRjMWE4MzYyMmRlNDRmMDhkZmEwN2JiZTg3Y2Y2NTAucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZmQzZWZjOGZlMzZkNGMwY2JkYzlkZTY0NWZkOWE0MGIucG5n
注意：设置后，必要重启Navicat才会生效
页:
[1]