Plsql Remote connection to Oracle database

Install the corresponding Oracle client (Instant clients) according to the Python version and the database version:

http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

Depending on the version of Plsql, download the corresponding client, here because our plsql is 32, we download the following version:

instantclient-basic-nt-11.2. 0.4. 0. zip

Unzip the downloaded files, the path does not take Chinese, here we unzip the path is:

D:\SOFT\oracle_client_x86

Configuring System Variables

Nls_langamerican_america. Al32utf8 or simplified Chinese_china. Zhs16gbk

Tns_admind:\soft\oracle_client_x86

To create the file Tnsnames.ora under the client path, the most basic configuration is as follows:

ORCL =      = =127.0.        0.11521)      ))) (= crcl    )   ))    

ORCL is the connection name, the alias of the connection database, you can start.
HOST is the database address IP.
SERVICE_NAME is the database name (corresponding to JDBC:ORACLE:THIN:@127.0.0.1:1521:CRCL).

Configure Plsql

Open the Plsql, directly cancel the login interface to the main program interface, enter the preferences

, fill in the Oracle Master directory name

D:\SOFT\oracle_client_x86

OCI Library Fill in

D:\SOFT\oracle_client_x86\oci.dll

Note Click on the previous point and turn green to enable.

Restart Plsql to log in normally.

Plsql Remote connection to Oracle database