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

1. Download the instant client from the Oracle Website:

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

Select different Instant Client versions based on your operating system

The downloaded file is a compressed file. The decompressed folder is D:/instantclient_11_2. Put it in your favorite directory. For example, D:/instantclient_11_2.

2. Create a New Directory Network under the D:/instantclient_11_2 directory, create the Admin directory under the network directory, and create the file tnsnames. ora under the Admin directory. Use the text editor to open and write the following content:

Mwdb =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.0.58) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = mwdb)
)
)

The first yellow block indicates the local host name of the remote server.

Second yellow block: Remote database instance name

3. Add an environment variable named tns_admin. The value is the path of the tnsnames. ora file. For example, my local machine is D:/instantclient_11_2/Network/admin.

4. Set the Oracle language and add the environment variable nls_lang. The value is simplified chinese_china.zhs16gbk.

If you do not know the Oracle language of the remote database, you can SSH or telnet to the remote machine, enter the command interface, and use the command line to connect to the database.

Select * From nls_instance_parameters;

View the value of nls_language

Nls_language

Nls_territory

5. download and install the Pl. SQL. developer configuration application
Configure tools> preferences> connection

Oracle Home
D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/OCI. dll

PL/SQL developer in Chinese is

Tool --> preferences --> connection

Oracle main directory

D:/instantclient_11_2

OCI Library

D:/instantclient_11_2/OCI. dll

6. Disable PL/SQL developer and restart developer.

The host name appears in the PL/SQL developer list. Enter the user name and password to log on to the remote ORACLE 11g database.