Oracle客户端PLSQL的使用说明

原创

mb5fe55acf14b1a 2021-01-26 17:29:03 ©著作权

文章标签 Java 文章分类 Java 后端开发

©著作权归作者所有：来自51CTO博客作者mb5fe55acf14b1a的原创作品，请联系作者获取转载授权，否则将追究法律责任

1安装windows客户端

2安装PL/SQL工具 PL/SQL工具注册

说明：安装完成pl/sql工具后试用期为7天，为了解决这个问题；需要进行注册；

配置相关信息

配置Oracle主目录和OCI.DLL文件位置

配置TNS文件信息

在oracle客户端目录下创建tnsnames.ora文件

D:\app\Administrator\product\11.2.0\client_1\network\admin

黄色区域需要手动创建目录

添加tnsnames.ora文件内容

# tnsnames.ora Network Configuration File.
# Generated by Oracle InstantClient tools.
# For more information, please visit: http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html

# Sample:
#DatabaseName =
#  (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
#    )
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME = ServiceName)
#      (INSTANCE_NAME = InstanceName)
#    )
#  )

# Modify the following content to fit your own needs.
# 下面为hxk 和 cxk 实例库 说明；如果有多个，则需要创建多个配置
hxk =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.55.130)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = hxk)
   )
 )
...
...