1, first download the instant client instantclient-basic-windows.x64-11.2.0.4.0,:http://www.oracle.com/technetwork/topics/ Winx64soft-089540.html?sssourcesiteid=otncn
2. Unzip the downloaded instantclient-basic-windows.x64-11.2.0.4.0 to D:\oracle\instantclient_11_2
3, create a file named Tnsnames.ora in the D:\oracle\instantclient_11_2 directory, the file content is as follows:
ORCL = = 192.168. 1.711521 )) = = dedicated) = orcl)))
4. Configure environment variables (System variables)
nls_lang=simplified Chinese_china. Zhs16gbktns_admin=d:\oracle\instantclient_11_2
After the path variable is appended
;D: \oracle\instantclient_11_2;
5. Configure PL/SQL
Open Plsql Prompt to select Cancel when logging in, select Tools->prefernces
The red part needs to be configured
After the configuration is complete, turn off Plsql to open the login again. Enter the user name password.
If you are prompted to do not have a listener during the logon process, you need to re-configure the Listener (listener configuration) using the "Net Configuration Assistant" tool on the server side, and then configure the "Local Network service name Configuration" When prompted for IP, fill in the IP address you want to connect to other programs
Win7 64-bit remote connection oracle11g64 bit