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

2022-11-26 07:33:56

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)
        )
    )