配置oracle监听文件

原创

佼佼战魂锤 2019-10-16 18:48:46 ©著作权

©著作权归作者所有：来自51CTO博客作者佼佼战魂锤的原创作品，请联系作者获取转载授权，否则将追究法律责任

配置oracle监听文件直接复制使用如果自己配置的监听文件总是出错，可以复制下面的信息进到自己配置文件中更改主机信息

TNS文件tnsnames.ora /# tnsnames.ora Network Configuration File: /oracle/oracle/11g/network/admin/tnsnames.ora /# Generated by Oracle configuration tools. / /ORCL = /(DESCRIPTION = / (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.10)(PORT = 1521)) / (CONNECT_DATA = / (SERVER = DEDICATED) / (SERVICE_NAME = orcl) / ) /) 监听文件listener.ora # listener.ora Network Configuration File: /oracle/oracle/11g/network/admin/listener.ora # Generated by Oracle configuration tools.

#粘贴后将/号去掉 /# listener.ora Network Configuration File: /oracle/oracle/11g/network/admin/listener.ora /# Generated by Oracle configuration tools. / /LISTENER = / (DESCRIPTION_LIST = / (DESCRIPTION = / (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) / (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) / ) / ) / /ADR_BASE_LISTENER = /oracle/oracle / /SID_LIST_LISTENER = / (SID_LIST = / (SID_DESC = / (GLOBAL_DBNAME = orcl) / (ORACLE_HOME = /oracle/oracle/11g) / (SID_NAME = orcl) / ) / )