设置PLSQ 连接oracle数据库

最新推荐文章于 2024-06-17 20:12:26 发布

古月_

最新推荐文章于 2024-06-17 20:12:26 发布

阅读量383

点赞数

分类专栏：数据库 oracle 工具类

本文链接：https://blog.csdn.net/huyande123/article/details/85283597

版权

数据库同时被 3 个专栏收录

23 篇文章 0 订阅

订阅专栏

工具类

12 篇文章 1 订阅

订阅专栏

oracle

2 篇文章 0 订阅

订阅专栏

1 、instantclient_12_1 的设置

配置文件内容 tnsnames.ora

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 221.122.92.61)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
  
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

配置环境变量

TNS_ADMIN

D:\oracle\instantclient_12_1\config