配置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)
/ )
/ )
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
