Plsql Configuring the Oracle Client

64-bit environment, use PL/SQL developer to connect to Oracle:

1. Download the 32-bit Oracle instantclient and expand to a directory, such as C:\instantclient-basic-nt-11.2.0.2.0;

·2. Copy the system's Tnsnames.ora to the directory;

·3. Set up the Oracle_home and OCI Library in Plsql Developer:

tools>preferences>oracle>connection:oracle_home:c:\instantclient-basic-nt-11.2.0.2.0

OCI Library:c:\instantclient-basic-nt-11.2.0.2.0\oci.dll

4. Two ways, first (modify environment variable)

Add C:\instantclient-basic-nt-11.2.0.2.0 in Path

New oracle_home=c:\instantclient-basic-nt-11.2.0.2.0

tns_admin=c:\instantclient-basic-nt-11.2.0.2.0

Nls_lang=american_america. Zhs16gbkstart Plsqldev.exe

Note: If the installation time is selected, the database character set is UTF-8 Nls_lang=american_america. Al32utf8

Second (create BAT, set environment variables by BAT file at startup time)

Create a new BAT file below the Plsql Developer directory, replace its shortcut, and start Plsql Developer:

@echo Offset path=c:\instantclient-basic-nt-11.2.0.2.0

Set oracle_home=c:\instantclient-basic-nt-11.2.0.2.0

Set tns_admin=c:\instantclient-basic-nt-11.2.0.2.0

Set Nls_lang=american_america. Zhs16gbkstart Plsqldev.exe

Note: If the installation time is selected, the database character set is UTF-8 set Nls_lang=american_america. Al32utf8

Plsql Configuring the Oracle Client