Plsql connecting Oracle requires local installation of Oracle client (download in the attachment):
- After downloading the file, put it in any directory, for example D:\instantclient_10_2
- Modify the Tnsnames.ora file, the first line to fill in the database name to link, the 4th line to fill in the database IP, line 7th fill the SID
- Configure environment Variables Tns_admin D:\instantclient_10_2\, add%tns_admin% in path, this can not be less, otherwise the environment variable configuration is not useful, this once bothered me for a long time to install Plsql, the process slightly
- Open Plsql, require user name and password, here first cancel, go to Plsql main interface, Tools-preferences, find Oracle home, input d:\instantclient_10_2,oci libriary, input d:\ Instantclient_10_2\oci.dll
- Re-open Plsql, login successful
Because the file is larger than 20M cannot upload, so I uploaded the file to Csdn:
http://download.csdn.net/detail/woxiangbo/6301193
Plsql Connecting Oracle Client (simple, practical) accessories