Shulou(Shulou.com)06/01 Report--

Client: WIN10

Server: Oracle server installed in Linux

1. Download plsqldeveloper11.zip and instantclient_11_2.rar and extract them to the corresponding directory.

D:\ instantclient_11_2, D:\ PLSQL Developer

2. Add environment variables to WIN10

Variable name: TNS_ADMIN variable value: d:\ instantclient_11_2\ NETWORK\ ADMIN

Variable name: NLS_LANG variable value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Variable TNS_ADMIN is the directory where the tnsnames.ora file is located

3. Change the file / u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora on the oracle server

Send it to the D:\ instantclient_11_2\ NETWORK\ ADMIN directory. WIN10 can ping the oracle server oracle11g01.

The content of the tnsnames.ora file is:

# tnsnames.ora Network Configuration File: / u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = oracle11g01) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

4. Set PLSQL Developer:Tools- > Preferences- > Connection

Oracle Home: d:\ instantclient_11_2

OCI library: d:\ instantclient_11_2\ oci.dll

5. Re-login

Note: PL/SQL Developer has 32-bit and 64-bit. There may be matching problems with instantclient_11_2. It is recommended to install it on D disk.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.