Oracle listener.ora写法讲解
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
  (PROGRAM = extproc)
  )
  )

LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = win-666a0ebc2c5)(PORT = 1521))
  )
  )
  )


对这样的写法很奇怪，又不像程序，oracle这样写的原因是什么？

------解决方案--------------------
我感觉这是个调用文件，Oracle中的netca.exe调用这个文件配置一个监听器，可以让其他客户端通过这个监听器来访问服务器端。其中这个语句ADDRESS = (PROTOCOL = TCP)(HOST = win-666a0ebc2c5)(PORT = 1521)就是说 采用TCP协议，主机为win-666a0ebc2c5，端口号为1521
------解决方案--------------------
http://docs.oracle.com/cd/A57673_01/DOC/net/doc/NWUS233/apb.htm#list.syn