Plsql DEVELOPER Connection remote database OCI Client Installation method

Installation has been used Plsql Dev knows that to connect to the database, TNS (transparence network substrate) must be configured, and after the direct installation of Plsql Dev, the machine is not a registry key for Oracle home, and even the network connection configuration items are not , Plsql Dev is just a text editor.

Plsql Dev An effective solution for connecting remote Oracle is to use OCI. The Oracle Calling interface (Oracle call interface, OCI) provides a set of interface functions that can be accessed from an Oracle database, which can be accessed by invoking the third-generation programming language for the purpose of accessing the Oracle database. This article describes how Plsql Dev uses an instance of OCI to connect to a remote database.

1. Preparation

(1) Download Oci,oracle official offer free download, http://www.oracle.com/technetwork/topics/winsoft-085727.html need Oracle account login, some other platforms also provide open download.

Note: Here are 32-bit and 64-bit downloads, because Plsql Dev has only 32-bit version, so OCI download 32-bit, I machine 64-bit, use normal.

(2) Install Plsql Dev.

2. Installation and Setup

(1) This machine to establish a dedicated directory (will be referenced, so must be fixed directory, the proposed roadbed without space), the OCI download package decompression.

(2) Create a network directory within the directory, in the network directory, create an admin directory, where the Tnsnames.ora TNS configuration file will be placed

(3) Open Plsql Dev, direct Cancel Connection window into the main interface, click Open Menu Bar--------------Preferences----Connection

Set the OCI directory location at Oracle home and set the Oci.dll under the OCI directory at the OCI library to determine.

3. TNS and NLS Lang

(1) System Properties on native (start with right-click "Computer"--Properties--Advanced system settings--advanced--environment variables--system variables), new 2 variables

The Tns_admin value is the full address of the ADMIN directory below the network under the new OCI directory you just created

The Nls_lang value is typically set to the NLS LANG value of the database, such as simplified Chinese_china, depending on the specific. ZHS16GBK, American_america. UTF8, wait.

Note: A restart is required after setting the environment variable to take effect.

(2) in.. /oci/network/admin Create a file below, named "Tnsnames.ora", where TNS information is configured

4. Restart Plsql Dev, you can select the database, in Plsql Dev also see the relevant support Info (menu--help-->support Info)

Plsql DEVELOPER Connection remote database OCI Client Installation method