Oracle_plsql_开发工具搭建最小化客户端

最新推荐文章于 2022-10-26 17:17:24 发布

转载最新推荐文章于 2022-10-26 17:17:24 发布 · 104 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ios9/p/9216957.html

文章标签：

#开发工具 #数据库 #网络

本文提供了PLSQL开发工具的配置指南，包括安装步骤概览及客户端工具的具体配置方法。通过设置不同端口和服务名，实现与远程Oracle数据库的有效连接。

一：资源下载获取路径：

二：配置方法

1：前提是安装好plsql开发工具

具体安装步骤略

2：配置简化版的客户端工具。

具体格式：可以参照下文来修改编写使用。

orcl_1521 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1521))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = orcl )
                )
  )
orcl_1522 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1522))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = orcl )
                )
  )
orcl_1523 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1523))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = orcl )
                )
  )
orcl_1524 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1524))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = orcl )
                )
  )
orcl_1525 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1525))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = orcl )
                )
  )
orcl_1526 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1526))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = orcl )
                )
  )
neworcl_1521 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1521))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = neworcl )
                )
  )
neworcl_1522 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1522))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = neworcl )
                )
  )
neworcl_1523 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1523))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = neworcl )
                )
  )
neworcl_1524 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1524))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = neworcl )
                )
  )
neworcl_1525 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1525))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = neworcl )
                )
  )
neworcl_1526 =
 (DESCRIPTION =
          (ADDRESS_LIST =
                 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.146)(PORT = 1526))
           )
           (CONNECT_DATA =
                   (SERVICE_NAME = neworcl )
                )
  )