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

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 数据库

 

 

posted @ 2020-06-27 21:54  元贞  阅读(303)  评论(0)  编辑  收藏  举报