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文件的配置

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

 

 

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

 

 

 

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

 

Navicat 连接 oralce 数据库

 

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

 

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

上一篇:mongDB需要注意的事项


下一篇:MYSQL 之 JDBC(十七): 调用函数&存储过程