plsql32 链接oracle64
使用第三方插件instantclient_11_2的原因是plsql是32位的 oracle是64位的 导致链接不上
配置两个环境变量
listener.ora的代码 作用就是net manager 中配置的监听
# listener.ora Network Configuration File: C:\Oracle\instantclient_11_2\listener.ora # Generated by Oracle configuration tools. 10.246.109.35 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.246.109.35)(PORT = 1521)) ) LOCALHOST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) SID_LIST_10.246.109.35 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = SSP_DEV.10.246.109.35) (SID_NAME = orcl) ) ) SID_LIST_LOCALHOST = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (SID_NAME = chen) ) ) ADR_BASE_10.246.109.35 = D:\app\Admin\product\11.2.0\client_1\log ADR_BASE_LOCALHOST = D:\app\Admin\product\11.2.0\client_1\log
tnsnames.oRA的代码 作用就是net manager配置的服务
# tnsnames.ora Network Configuration File: C:\Oracle\instantclient_11_2\tnsnames.ora # Generated by Oracle configuration tools. CHEN = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) SSP_DEV = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.246.109.35)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。