PL/SQL Developer does not install a client to connect to a remote oracle database (for example, developeroracle)
Labels ):
Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html
2. Download and install PLSQL (around 16 Mb ):
Http://www.onlinedown.net/soft/4902.htm
3. Unzip the instantclient-basic-win32-11.2.0.1.0.zip to a 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 = // database 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. ora in a text document with the following content: 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 and 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 access the database. 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.