1. Download the agile client instantclient (about 40 MB, select the appropriate download)
Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html
2, download and install PLSQL (16 m): http://www.onlinedown.net/soft/4902.htm 3, unzip
Instantclient-basic-win32-11.2.0.1.0.zip to new folder, such as D:/oracleclient/instantclient_11_2
Create tnsnames. ora in a text document. The content is roughly as follows:
# Tnsnames. ora network configuration file:/opt/Oracle/product/9204/Network/admin/tnsnames. ora # generated by Oracle configuration tools. // The above is the comment, because my tnsnames. ora is the hssl = // client display name downloaded directly from the server (description = (address_list = (address = (Protocol = TCP) (host = 218.108.242.30) (Port = 1521 )) // ip and port) (CONNECT_DATA = (SERVICE_NAME = hssl) // Database Name) Create sqlnet using text documents. ora, the content is as follows:
Names. directory_path = (tnsnames) sqlnet. authentication_services = (ETS) Add an environment variable to my computer, properties, advanced, and environment variables. The variable name is tns_admin and the value is the path of the tnsnames. ora file,
Example: D:/oracleclient/instantclient_11_2
4. After PLSQL is installed, start, cancel, and click tOols-> preferences-> connection:
Oracle Home = D:/oracleclient/instantclient_11_2
OCI library = D:/oracleclient/instantclient_11_2/OCI. dll
Restart PLSQL to enter the database. 5. Chinese characters may be garbled during initial login. The solution is as follows:
Add an environment variable to my computer, attributes, advanced, and environment variables:
Variable name: nls_lang
Variable value: american_america.zhs16gbk
Reconnect to display Chinese characters.
If you want to convert to the utf8 character set, you can assign 'nls _ Lang 'to 'American _ America. utf8'. Other codes are the same as above. From: http://www.blogjava.net/rockblue1988/archive/2011/09/06/358112.html