oracle怎么设置监听文件,配置oracle监听文件

配置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 = master.example.com)(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)

/ )

/ )