How to Use PLSQL developer without installing Oracle client

1. Download the Oracle client package (30 m)
You only need
Oracle can download a software named Instant Client package. This software does not need to be installed and can be used as long as it is decompressed. It is very convenient and can be used even if the system is reinstalled.

: Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
Decompress the package to a directory, such as c: \ oracleclient.

2. Configure Operating System Environment Variables
Nls_lang = simplified chinese_china.zhs16gbk
Tns_admin = c: \ oracleclient

3. Configure the connection to Oracle. Tnsnames. ora file to the directory c: \ oracleclient. You can copy one from the Oracle server.
The content is similar to: # tnsnames. ora network configuration file: e: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \ tnsnames. ora
# Generated by Oracle configuration tools. orclproduct =
(Description =
(Address = (Protocol = TCP) (host = prmpatm 1.asiapacific.hpqcorp.net) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = orcl)
)
) Orcl122 =
(Description =
(Address = (Protocol = TCP) (host = 16.157.133.122) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = orcl)
)
) Extproc_connection_data =
(Description =
(Address_list =
(Address = (Protocol = IPC) (Key = extproc1 ))
)
(CONNECT_DATA =
(SID = plsextproc)
(Presentation = Ro)
)
)
4. Install PLSQL developer

5. Configure PLSQL developer (for the first time, you do not need to log on directly to PLSQL Developer)
Tools --> preferences --> connections,
The content of Oracle Home is c: \ oracleclient
OCI library content is c: \ oracleclient \ OCI. dll

Restart plsqldeveloper
Finished