Cool breeze AAA 2022-02-13 07:41:43 阅读数:503
Use navicat Remote connection to the company's oracle The database reported the following error , Stuck for a long time .
oci.dll Version inconsistency .
because Navicat It's through Oracle Client connection Oracle Server's ,Oracle There are two types of clients , One is the standard version , One is the simple version , namely Oracle Install Client.
And we use Navicat when It usually contains multiple versions of... In its own installation path OCI, If you use Navicat Connect Oracle The server appears ORA-28547 When it's wrong , Mostly because Navicat The local OCI Version and Oracle Caused by server mismatch . So all we have to do is download OCI Make it similar to what we installed Oracle Server match .
OCI stay Oracl Download address on the official website :
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Version Description : When you find the reason on the Internet , Many people say that no matter what their computer is 32 Bit , still 64 Bit , Can only download 32 Bit . Test and solve it yourself : Find out 32 Bit is still not connected , Another mistake :oracle library is not loaded. Later it was replaced by 64 Bits can be connected correctly .
This should be connected to oracle The version of has something to do with , Here I'll tell you the version of my successful connection for your reference : Computer :win10 64 position ,navicat:v12.0 Green decompression version ,OCI: The latest version downloaded from the official website ,windows64 19.10.0.0.0, Connected company oracle:64 11 edition
Before downloading, you need to log in to your oracle account number , Without following the prompts, just register step by step .
Don't have : chinese , Space , Special characters, etc
Tools — Options — Environmental Science
Select the path of the file just below .dll file
Be careful : Then click the OK button , Remember to restart navicat, Connecting oracle test , Generally, the connection can be successful at this time .
copyright:author[Cool breeze AAA],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130741407131.html