首页 > 数据库技术 > 详细

windows 客户端的Navicat & PL/SQL 连接Oracle 数据库

时间:2020-06-27 22:42:17      阅读:92      评论:0      收藏:0      [点我收藏+]

PL/SQL 连接Oracle 数据库

1、下载instantclient_11_2文件

  官网可以下载

2、本地的监听文件

D:\Program Files\instantclient_11_2\network\admin\tnsnames.ora、

注意填写清楚下面两项的内容

  • SERVICE_NAME
  • ORACLE_SID
ORCL =
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.17)(PORT = 1521))
        )
        (CONNECT_DATA =
            (SERVICE_NAME = orcl)
        )
    )

BWG_ORCL =
    (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 74.120.175.165)(PORT = 1521))
        )
        (CONNECT_DATA =
            (SID = orcl)
        )
    )
WIN_ORCL =
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
        )
        (CONNECT_DATA =
            (SERVICE_NAME = orcl)
        )
    )
    
    
    
ORCL-19c =
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.51)(PORT = 1521))
        )
        (CONNECT_DATA =
            (ORACLE_SID = itpuxdb)
        )
    )

 

3、配置PL/SQL的文件

  oci.dll文件的配置

技术分享图片

 

 

技术分享图片

 

 

 

技术分享图片

 

Navicat 连接 oralce 数据库

 

技术分享图片

 

windows 客户端的Navicat & PL/SQL 连接Oracle 数据库

原文:https://www.cnblogs.com/wenyule/p/13200129.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!