Plsql Developer8.04 Connection oracle11g

One, download Oracle Thin (thin) client 32bit version Compression package

Http://www.oracle.com/technetwork/topics/winsoft-085727.html This address may be subject to change as the Oracle official website is upgraded.

Instant Client package-basic:all files required to run OCI, OCCI, and JDBC-OCI applications

Instantclient-basic-nt-12.1.0.2.0.zip (67,410,370 bytes) (cksum-530881682)

Note: It is best to select this version, other versions of the error message that do not support Chinese and other related.

Second, unzip the thin client to the specified directory

The author extracts the catalogue as:D:\Program Files (x86) \instantclient_12_1

Iii. creating / modifying related configurations

Create a new folder under the above directory:network\admin\

copy sqlnet and tnsnames two files from Oracle server to the new ADMIN above directory under

Modify the contents of the tnsnames file as follows (the comment section has been omitted):

Please modify the following three configurations according to the individual installation situation

host=192.168.1.104--oracle Server IP address

port=1521--oracle Server Port

SERVICE_NAME=ORCL--oracle Global service name

Iv. setting System Variables ()

Create the following two items:

Variable name:tns_admin

Variable value:D:\Program Files (x86) \instantclient_12_1-- installation directory for thin clients

Variable name:Nls_lang

Variable value:simplified Chinese_china. ZHS16GBK-- Chinese Simplified GBK Character Set

V. Modify the connection under plsql Developer Preferences:

Open plsql Developer, click on the login page to cancel, no login mode to open plsql Developer

Find Tools → preferences (References)→ connection (Connection) Modify the configuration as:

the Oracle home directory is configured as a thin client installation directory

The OCI Library is the oci.dll in the Thin client installation directory

Click Apply, OK, close reopen plsql Developer

Enter the user name, password, select database, connect as (connection), determine

Note: If the sys account is logged in, the connection must be syadba

Plsql Developer8.04 Connection oracle11g