Green Plsql/developer paired with Oracle thin client

The main steps are as follows:

1. Download the Oracle thin client and unzip it (without installation)

2. Create an Oracle thin client configuration file (Sqlnet.ora, Tnsnames.ora)

3. Set the environment variable Tns_admin

4. Set Plsql to run as Administrator (WIN7/WIN8)

5. Configure Oracle Connection parameters for Plsql

1. Download the Oracle thin client and unzip it (without installation )

download from here: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, then choose Basic version.

Decompression: C:\instantclient\ (catalogue optional)

2. Create an Oracle thin client configuration file (Sqlnet.ora, Tnsnames.ora)

Create new Sqlnet.ora and Tnsnames.ora files under the C:\instantclient\ directory

the contents of the Sqlnet.ora file are:

sqlnet. Authentication_services= (NTS)
NAMES. Directory_path= (TNSNames, Ezconnect)

the contents of the Tnsnames.ora file are:

orcl=
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.103) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

3. Set the environment variable Tns_admin

Variable Name: tns_admin
Variable value: C:\instantclient\
Otherwise appears: Ora-12154:tns:could not resolve the connect identifier specified error

I escalated the ora-12543 on my own machine: unable to find host error

If you have previously installed ORACLE and uninstalled, you will be left with the Nls_lang=na key. Enter regedit to open the registry hkey_local_machine/software/oracle. Find the Nls_lang=na on the right and delete it.
Otherwise it will be reported ora-12705:cannot access NLS data files or invalid error.

4. Set Plsql to run as Administrator (WIN7/WIN8)

Win7/win8, you need to run Plsqldev.exe program as Administrator
(Right--"properties--" compatibility--"Run as Administrator)

5. Configure Oracle Connection parameters for Plsql

Select the connection in the PL/SQL Tools/Preferences (tool/preference/) and set the Oracle home directory name (i.e. the installation directory) and the OCI library on the right.
Oracle Home directory Name: C:\instantclient\
OCI Library: C:\instantclient\Oci.dll
pay attention to the first application, then determine

Let's test it.

If you are bothered, use Oracle SQL developer directly.