One
1) Download Oracle client: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
2) Download Plsql:
Note: Install Plsql if the corresponding instantclient for 32 bits is under 32 bits, Plsql if the corresponding instantclient of 64 bits is next 64 bits (in short two versions to be consistent)
Second, configure the environment variables:
1) Path = C:\instantclient
2) Nls_lang = simplified Chinese_china. Zhs16gbk
3) Tns_admin = C:\instantclient\NETWORK\ADMIN
Third, add the folder under C:\instantclient \network\admin, the final file directory is as follows C:\instantclient\NETWORK\ADMIN
Where the Admin folder is used to store tnsnames.ora, or not to create, put Tnsnames.ora in the client root directory, the same effect
Tnsnames.ora contents can be consulted:
Orcl=
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
Oracle No install Client Installation method