PL/SQL Developer--instant-client simple Configuration

Instant-client (Database Instant client)

Official note: The instant client is available under a separate OTN development and distribution license for Instant client, which allows the majority of licenses to be downloaded, redistributed, and deployed to the production environment at no charge.

Why use Instant-client

1. No need to install, decompression is good;
2. Free.

Download instant-client

Address: http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html

There are several versions of Instant-client, Basic, Basic Lite, JDBC Supplement, Sqlplus, etc., the download page has a detailed description, there is not much to say. In general, if you just connect to the database, the basic version is available.

Basic

Run OCI , OCCI and the Jdbc-oci All files required by the application

Here we download: Instantclient-basic-win32-11.2.0.1.0.zip

Installation configuration

Software preparation: Plsql Developer v8.0.4, Instantclient-basic-win32-11.2.0.1.0.zip

1. Install Plsql Developer v8.0.4;
2. Decompression Instantclient-basic-win32-11.2.0.1.0.zip to D:\Oracle\instantclient_11_2;
3. Configure environment variables;

Variable name	Value	Note
Nls_lang	Simplified Chinese_china. Zhs16gbk	set up the necessary Oracle Global Language environment variables, Nls_lang the corresponding character set in Chinese is simplified Chinese_china. ZHS16GBK

1. Configuring PL/SQL Developer

Start PL/SQL Developer, in the Login window interface, click the Cancel button to enter the main interface, click Tools->preferences, in connection need to configure the following two parameters:

Oracle Home	D:\Oracle\instantclient_11_2
OCI Library	D:\Oracle\instantclient_11_2\oci.dll

After configuration, restart PL/SQL Developer.

1. Connecting to a database

Database format: IP: Port/Instance name. We enter here: 192.168.1.102:1521/ORCL

Note: With IP: Port/Instance Name the benefit of this approach is that you do not need to configure Tnsnames.ora. Of course you can use the Tnsname configuration, but remember to configure the environment variable tns_admin.

Tns_admin

D:\Oracle\instantclient_11_2

can be found under the path specified by the variable Tnsnames.ora file

?

?