Use of Oracle instant client

Oracle instant client has recently been used to reinstall the operating system. It uses the Windows 7 x64 version and is not prepared to install Oracle. So we can see the Instant Client on the official website. Xing rushed to download a 64-bit version, instantclient-basic-windows.x64-11.2.0.3.0.zip. After the configuration is complete, PL/SQL Develpoer prompts that the connection fails because PLSQLDev is a 32-bit version and does not have a 64-bit version, therefore, the Oracle dll is still 32-bit. Then download the 32bit instantclient-basic-nt-11.2.0.3.0.zip. After the instantclient is downloaded, It is a compressed file. You can configure it without installation. Decompress the file to the directory to be placed. I have selected the Oracle directory of drive C, and the path is C: \ Oracle \ instantclient_11_2. Then, configure Path in the system environment variable and add the Path of instantclient, that is, C: \ Oracle \ instantclient_11_2; Add the environment variable: NLS_LANG = AMERICAN_AMERICA.ZHS16GBK TNS_ADMIN = C: \ Oracle \ instantclient_11_2, add a tnsnames in the "TNS_ADMIN" path. ora file, which can be copied directly from the installed Oracle directory, or use the following example: www.2cto.com # TNSNAMES. ORA Network Configuration File: C: \ oracle \ ora90 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. # sample ORCL_100 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.168.100) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl) after the configuration is complete, start PLSQLDev, the database is successfully logged on. Author benbenming