OriginalHttp://blog.csdn.net/dreamcatchergo/article/details/27688601
Navicat has been used. It is a database client software that can connect to a variety of different types of databases, which brings a lot of convenience to our daily work. Recently, I installed orcale on my computer, and navicat was inexplicably unable to connect to the Oracle database. The following error is always prompted:
Let's talk about what OCI is. In the encyclopedia, Oracle call interface (Oracle callinterface (OCI) provides a set of interface subroutines (functions) that can be accessed to the Oracle database ), by calling the third-generation programming language (such as the C language), you can access the Oracle database.
Therefore, to connect to Oracle, you must have available OCI. The default OCI position of navicat is navicat premium \ instantclient_10_2 \ OCI. dll. You can view the information through tools> Options> miscellaneous> OCI, as shown in:
I have been able to use it normally before, but it cannot be used after oracle is installed. I guess that when oracle is installed, it modifies some configurations, resulting in this problem. I checked it online and found that many people said they could change the location of OCI to the location of OCI under the Oracle directory. So I did this, but after I restarted navicat, it prompts cannotload OCI DLL, as shown below:
Later, I accidentally saw an OCI. dll file in the Oracle client folder. I changed the OCI location to the OCI location in the client, as shown in the result:
I think, when you see the picture above, you must be as excited as I do.
Navicat prompts cannot create OCI environment Solution