First download instantclient can be downloaded to the Oracle website, to register the account, must be under the corresponding version, otherwise unsuccessful,
10g,11g version of, I have been sent up, free download: Is crossing, wait a minute
Configuration file Tnsnames.ora This one place is generally put (network/admin), only in PL/SQL----->tools-->proferences ...------>connection---- > Oracle Home (Empty is AutoDetect) write Tnsnames.ora path (related path to your own)
ORCL2 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.100.183) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
Oraclr_connection_data =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(Connect_data =
(SID = Clrextproc)
(PRESENTATION = RO)
)
)
Setting environment variables (directories for your own)
Tns_admin=d:\soft\oarcleclient\instantclient_11_2
Nls_lang=simplified Chinese_china. Zhs16gbk
Path=d:\soft\oarcleclient\instantclient_11_2