liqiang135的专栏 - 编程开发

1、服务器端配置D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

———————–修改前的文件内容———————-# listener.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )

ADR_BASE_LISTENER = d:\app\Administrator———————————————————————————–

———————–修改后的文件内容———————-# listener.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:d:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ) )

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.8.169)(PORT = 1521)) ) )

ADR_BASE_LISTENER = d:\app\Administrator

———————————————————————————–

注意：只更改HOST = 172.16.8.169这里不行，会报错误 RA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务，需要加

(SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = d:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ) 在重新启动监听服务

2、客户端配置（1）测试服务器端监听是否正常tnsping 172.16.8.169

看是否返回时间ms如果有数字代表成功否则失败。

C:\Documents and Settings\Administrator>tnsping 172.16.8.169

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 – Production on 05-3月 -2015 16:31:37

已使用的参数文件:d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

已使用 EZCONNECT 适配器来解析别名尝试连接 (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.8.169)(PORT=1521)))OK (20 毫秒)

（2）修改D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora文件内容

———-修改前————————

# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.

LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )————————————————————————-

———-修改后————————

# tnsnames.ora Network Configuration File: d:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.

LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

往往教导我们大家要好好学习天天向上，要永不言弃坚持到底百折不挠宁死不屈，

相关文章：

你感兴趣的文章：

标签云：