Plsql Developer configuring OCI to connect to a remote database

Current Environment:

Native System: Win7 32-bit

Plsql Version: 9.06

Database version: 10.2 32 bit

Here's how to get started.

1. Download the Instantclient-basic-win32-10.2.0.3-20061115.zip on the Oracle website and extract it to a directory, such as D:\develop\oci. Then this directory is Plsql developer inside the OCI should fill in the directory.

2. Create the network directory under this directory and create the admin directory under the network directory, which is D:\develop\oci\network\admin.

3. In the admin directory to create a new Tnsnames.ora file, the content format is as follows (multiple connections are configured in turn, there is no "[]" in the actual configuration):

[Connection Name] =
(DESCRIPTION =
(address = (PROTOCOL = TCP) (HOST = [Database IP address]) (port = [Database port]))
(Connect_data =
(SERVER = dedicated)
(service_name = [SID of Database])
)
)

4. Open Plsql Developer and select Cancel at login. After entering the software interface, select Tools---Preferences, select Oracle-to-Connection on the left, complete the D:\DEVELOP\OCI,OCI library in Oracle home D:\develop \oci\oci.dll (here to fill in different values according to different directory settings), such as

5. Configure Environment variables

Tns_admin-D:\develop\oci\network\admin

Nls_lang is consistent with the NLS LANG value of the connected database, such as simplified Chinese_china. ZHS16GBK, American_america. UTF8, wait.

6. Restart Plsql Developer, you can select the connection of the Tnsnames.ora file configuration on the database of the connection interface.

Plsql Developer configuring OCI to connect to a remote database