点击odac_client下载:odac_client
1. 安装:
2. 使用方法1.1 按上述地址下载,解压至任意目录(建议放在你自己的软件安装目录下),无需安装
1.2 环境变量配置
变量名称:TNS_ADMIN
变量值:odac_client的解压目录。例如D:\DataBases\odac_client
示例:TNS_ADMIN = D:\DataBases\odac_client
1.3 tnsnames.ora(D:\DataBases\odac_client\tnsnames.ora)文件配置
Test@10.167.200.59 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.167.200.59)(PORT = 1523)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdbsitjk) ) )
打开PL\SQL,按如下进行配置:Tools --> Preferences... 如下图