Connect to a remote database using an Oracle client

Available with three Oracle clients: SQL Developer, pl Developer, Navicat Premium

I. SQL Developer (Oracle's Own)

Download and install SQL Developer, the connection is simply not said.

: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Ii. PL/SQL Developer11 configuration Client

Download PL/SQL Developer11 Chinese version: http://download.csdn.net/download/hr541659660/9550427

1, first to the Oracle website download Instant Client:

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

Choose a different instant client version based on your operating system

The download will be a compressed file, after extracting the folder called: Instantclient_12_1. Put it in your favorite directory. For example: E:\Program files\plsql developer\instantclient_12_1

2, in the E:\Program files\plsql developer\instantclient_12_1 directory under the new directory network, in the network directory under the new admin directory, Create a new file Tnsnames.ora in the admin directory,

Use a text editor to open the write to the following:

Connection name == = = (PROTOCOL = TCP) (HOST =192.168.  0.1321521=ORCL) ))

Connection Name: Indicates the local hostname (optional input) that defines the remote server

192.168.0.132: IP address of the remote database

ORCL: Remote DB instance name

3. Right-click My Computer Select "Properties", "Advanced", "Environment variables", "System variables"

Add the following two variables

Tns_admin E:\Program Files\plsql Developer\instantclient_12_1\network\admin

Nls_lang simplified Chinese_china. Zhs16gbk

4. Download and install the PL.SQL.Developer configuration app

Configure Tools->preferences->connection

Oracle Home

E:\Program Files\plsql Developer\instantclient_12_1

OCI Library

E:\Program Files\plsql Developer\instantclient_12_1\oci.dll

The PL/SQL developer in Chinese is

Tools--Preferences--Connect

Oracle Home Directory

E:\Program Files\plsql Developer\instantclient_12_1

OCI Library

E:\Program Files\plsql Developer\instantclient_12_1\oci.dll

6, close PL/SQL Developer, restart Developer.

The hostname will appear in the PL/SQL developer list, enter the user name password, and you will be able to log in to the remote Oracle 11g database.

Reference: Http://www.cnblogs.com/acyyu/p/6493080.html?utm_source=itdadao&utm_medium=referral

Third, Navicat Premium

Download and install Navicat Premium, connect the database simply don't say it.

Iv. Comparison of the three

PL/SQL Developer is powerful, but the operator interface is not intuitive and is more appropriate for DBAs.

Navicat Premium connects multiple types of databases, and the interface is simple, intuitive and easy to get started with.

Connect to a remote database using an Oracle client