plsql连接mysql数据库_plsql配置远程数据库连接（即监听文件的配置）

2、我这里选择的是：即时客户端程序包 — Basic： 运行 OCI、OCCI 和 JDBC-OCI

应用程序所需的所有文件(instantclient-basic-win32-11.1.00.70.0.zip)

3、将安装包解压和重命名为：D:\OracleInstantClient_11_1

4、设置环境变量：

1.;D:\OracleInstantClient_11_1; (在PATH环境变量追加)

2.SET

TNS_ADMIN=D:\OracleInstantClient_11_1 (新建),为admin目录,如果新建的目录,注意修改成你对应的

3.SET NLS_LANG=SIMPLIFIED

CHINESE_CHINA.ZHS16GBK (新建,防止查询乱码)

5、指定需要连接的实例名字，在D:\OracleInstantClient_11_1目录下新建一个tnsnames.ora文件，然后填入

192.168.8.201 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.201)(PORT =

1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

大家都知道，用PL/SQL连接Oracle，是需要安装Oracle客户端软件的。有没要想过不安装Oracle客户端直接连接Oracle呢?

利用Oracle提供的Instant Client Package

只需要在Oracle下载一个叫Instant Client

Package的软件就可以了，这个软件不需要安装，只要解压就可以用了，很方便，就算重装了系统还是可以用的。

下载地址：http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html下载这个，Instant

Client Package -

Basic包。然后解压到任意目录，在这个目录下建立NETWORK文件夹，接着再这个文件夹下再建立ADMIN文件夹，然后在ADMIN内建立tnsnames.ora文件，内容如下：

yourDataBaseName =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = yourhostIp )(PORT =

1521))

)

(CONNECT_DATA =

(SERVICE_NAME = yourSID )

)

)

例如：

# TNSNAMES.ORA Network Configuration File:

C:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

LILO =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.33.220.157)(PORT =

1521))

)

(CONNECT_DATA =

(SERVICE_NAME = Lilo)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

D:\oracle\NETWORK\ADMIN下 安装目录

找到tnsnames.ora(可以通过搜索找到该文件)

E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

//下面是本地或者是局域网连接 地址为:192.168.0.146 数据库为:ORA10G

ORA10G =

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = TCP)(HOST = 192.168.0.146)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORA10G)

)

)

//下面是远程连接 地址为:211.155.25.43 数据库为:LION

ORA10G_LION =

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = TCP)(HOST = 211.155.25.43)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = LION)

)

)