Connect Oracle 11g remote database using instantclient_11_2 and PL/SQL Developer Toolkit

This article goes from the CSDN blog, http://blog.csdn.net/helifengwell/archive/2010/08/18/5820434.aspx

1, first download instant Client to Oracle site:

Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html

Choose a different instant client version number depending on your operating system

Download back is a compressed file, extracted after the folder called: D:/instantclient_11_2. Put it in the folder you like. For example: d:/instantclient_11_2

2. Under the D:/instantclient_11_2 folder to create a new folder network, under the network folder to create a new admin folder, under the Admin folder to create a new file Tnsnames.ora, using a text editor to open write such as the following:

mwdb=
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521))
)
(Connect_data =
(service_name = mwdb)
)
)

First Yellow block: Represents the local hostname that defines the remote server

Second yellow block: Remote DB instance Name

3, add an environment variable named Tns_admin, the value is the path of the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin

4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbk

Assuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.

SELECT * from Nls_instance_parameters;

View the value of Nls_language

Nls_language

Nls_territory

5. Download and install the PL.SQL.Developer configuration app
Configure Tools->preferences->connection

Oracle Home
D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/oci.dll

The PL/SQL developer in Chinese is

Tools--Preferences--Connect

Oracle home folder

D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/oci.dll

6, close PL/SQL Developer, restart Developer.

The hostname will appear in the list of PL/SQL developer, and enter Usernamepassword to log in to the remote Oracle 11g database.

Supplemental Instant Client Instructions

Oracle Instant Client is an easy-to-support Oracle provider that supports multiple platforms. Available for download from the Oracle site for
Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html

Includes such as the following:

Instant Client Package-basic performs all the files required for OCI, OCCI, and JDBC-OCI applications.

Instant client Package-basic Lite: Includes only English error messages, only support Unicode, ASCII, Western European character sets.

Instant client Package-jdbc Supplement adds Xa, internationalization, and rowset to JDBC.

Instant Client package-sql *plus includes sqlplus and required library files

Instant client PACKAGE-SDK the header files and demo samples needed to develop an Oracle application using Instant client Makefile

Instant client Package-odbc The libraries that are required to use ODBC, not all platforms. Linux platforms include.

Basic and Basic lite must be selected in two, and other packages are optional. I downloaded Basic, JDBC Supplement, SQL *plus, SDK, ODBC. After decompression is placed in a directory, in this directory to establish the file Tnsnames.ora, environment variable settings ld_library_path and Tns_admin point to the extracted directory, you can use Sqlplus.

I downloaded the instant client version number 10.2.0.2.0 and tested the connection to Oracle 9.2.0.4 and Oracle 10.2.0.1.

Instant client does not include tnsping, Exp/imp, Rman, NETCA and other tools. If you need these tools, you need to install Oracle client

Assuming that this is a cumbersome operation, you can use Navicat Lite for Oracle to connect to an Oracle database,

See this article for more details. Http://www.linuxidc.com/Linux/2011-05/35598.htm

Connect to Oracle 11g remote database using instantclient_11_2 and PL/SQL Developer Toolkit