First,cannot load OCI dll,126
Workaround: Tool-> option->OCI Select Oci.dll in bin in the Oracle installation directory, install Oracle 11g R2 under Win7, and when connecting to Oracle with NAVICAT, prompts the following error: Cannot load OCI DLL, 126:instant Client package is required for Baic and TNS connection for more information:http://wiki.navicat.com /wiki/index.php/instant_client_required View the above link found that Navicat only support 32-bit Instant client, so although we installed 64-bit Oracle, But since Navicat only supports 32-bit, we also need to download a 32-bit client, download the address: http://www.oracle.com/technetwork/topics/winsoft-085727.html. The following is a complete workaround: 1: Download the file in the above address: Instantclient-basic-nt-11.2.0.3.0.zip 2: Unzip this installation package and merge the extracted files into: D: Appuserproductinstantclient_11_2 3: Open navicat, select tools → options → other →oci, then set OCI Library as: D:app\user\product\instant\client_ 11_2\oci.dll, set the SQL *plus to: D:app\user\product\11.2.0\dbhome_1\bin\sqlplus.exe. Are you sure. 4: Test success.