Attention:
That Oci.dll file is not installed Oracle inside to be downloaded separately that compression package extracted inside the
Which D:\instantclient_11_1\oci.dll in the decompression
Instantclient-basic-win32-11.1.0.6.0.zip Compressed Package inside
DLL file has been placed in the Baidu Cloud peer directory after decompression and put a position can be introduced in Navicat
Baidu Cloud Network Disk download
Http://pan.baidu.com/s/1cdrmea
1. Download Oracle Client Lite Instant Clients
Oracle Instant Client:http://download.oracle.com/otn/nt/instantclient/11/instantclient-basic-win32-11.1.0.6.0.zip
After downloading the file compression, the compressed path is as follows: D:\instantclient_11_1
2, Configuration Tnsnames.ora
Create a file under directory D:\instantclient_11_1\network\admin: Tnsnames.ora, as follows:
databasename = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip address)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = database name) ) )
Parameter description: In the above parameters
DatabaseName Database name
IP Address database server IP addresses
For example, if my Oracle database server is installed on 192.168.1.101 and the database name is ORCL, the Tnsnames.ora content is set as follows:
orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )
3. Configure Environment variables
Add content to the PATH variable D:\instantclient_11_1
Add new environment variable tns_admin with content set to: D:\instantclient_11_1\network\admin
Configure PL/SQL Deverloper login
Go to PL/SQL developer in non-logged-in state, go to the Connect as preferences, tools, set the Oracle home directory and the OCI library in the connection, where
The Oracle home directory is set to the Instantclient directory (D:\ProgramFiles\instantclient_11_2 's path), and the OCI library is set to Oci.dll in that directory (D:\ProgramFiles\ The path of the Instantclient_11_2\oci.dll himself).
After Setup is complete, the interface is as follows
After saving, you can try to log in,
If such an error occurs ora-12154:tns:could not resolve the connect identifier specified, you need to configure the environment variable at this time
New in system variables, set the variable name and variable name: (the variable name is your path to Oracle: My path is: C:\app\Administrator\product\11.2.0\dbhome_1) key to find the red part can be;
You may get an error when you log in again: Nls_lang can cause unpredictable consequences if the client cannot be determined by a character set transition
You also need to configure one more environment variable at this time:
Easy to copy
NLS_LANGSIMPLIFIED CHINESE_CHINA.ZHS16GBK
Navicat Connecting Oracle Database issues