plsql连接oracle

时间:2024-05-25 16:04:14

在plsql中:   需要在工具----选项    指定 1. orcacle   主目录    :G:\PLSQL Developer 11.0.0.1762 中文绿色注册版(免Oracle11g客户端)\PLSQL Developer\instantclient_11_2

这个文件夹下得有tnsnames.ora文件:

# tnsnames.ora Network Configuration File: tnsnames.ora
# Generated by Oracle configuration tools.

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
)
)

2.指定  oci库    G:\PLSQL Developer 11.0.0.1762 中文绿色注册版(免Oracle11g客户端)\PLSQL Developer\instantclient_11_2\oci.dll