Plsql Developer Connection Linux installation and configuration of Oracle

First, download

: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

This is the homepage of the Oracle Instant client download, and there are many versions available for download.

But pay attention to third-party tools such as: PL/SQL developer and Toad version, 32-bit to correspond to 32-bit oracleinstant Client, do not because the system is 64-bit download 64-bit, this should be noted.

Two, configure

Unzip the downloaded Instantclient-basic-win64-10.2.0.5.zip compressed package and put it in the C:\Program files\plsql Developer 12\instantclient_10_2 directory.

In the environment variables, in the system variables, add:

Oracle_home=c:\program files\plsql Developer 12\instantclient_10_2tns_admin=c:\program files\plsql Developer 12\ Instantclient_10_2nls_lang=simplified Chinese_china. Zhs16gbk
Modify the path variable and add the C:\Program files\plsql Developer in the back 12\instantclient_10_2

Third, create a new Tnsnames.ora file

Create a new Tnsnames.ora file in C:\Program files\plsql Developer 12\instantclient_10_2 to add your own database alias configuration.

Examples are as follows:

PMD =  (DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = 22.13.34.2) (PORT = 1521))    (Connect_data =      (SERVER = dedicated)      (SID = PMD)    )  

Note that the format should be arranged well

Main change = previous alias, host is IP address, service_name is the instance name of the database server.

Four, unloading method

In "Environment variables", in "System variables":

Five. Use of third-party tools

Any of the above clients can be configured to install the toad or PL/SQL Developer tool, and no additional settings are required to be used.

Plsql Developer Connection Linux installation and configuration of Oracle