ORACLE监听器

 

图1

 

Listener.ora、tnsnames.ora、sqlnet.ora路径

ORACLE_HOME\NETWORK\ADMIN\

 

内容解析

listener.ora

# listener.oraNetwork Configuration File:E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

# Generated byOracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME =E:\app\Administrator\product\11.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS ="EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")

    )

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME =E:\app\Administrator\product\11.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS ="EXTPROC_DLLS=ONLY:E:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST =PC-201411052136)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))

    )

  )

 

ADR_BASE_LISTENER =E:\app\Administrator

 

 

tnsnames.ora

# tnsnames.oraNetwork Configuration File:E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

# Generated byOracle configuration tools.

 

COM =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = com.subapp)

    )

  )

 

LISTENER_COM =

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

 

 

LISTENER_COMDB =

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

 

 

ORACLR_CONNECTION_DATA=

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

 

 

192.168.22.100_COM = --名称

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.22.100)(PORT = 1521))--协议、主机、端口

    )

    (CONNECT_DATA =

      (SERVICE_NAME = com) --服务名，也就是oracle对外提供的服务名

    )

  )

 

COM =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = com.subapp)

    )

  )

 

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)

    )

  )

 

 

图2

 

1、Client访问Server的1521端口，把自己的信息告诉Server；

2、Server的listener会产生一个ServerClient，用另外一个端口XXXX，和oracle交互

3、Server得到Client的信息后主动连接Client，并告诉Client自己的工作端口；

4、Client确认Server是否存在

5、Server确认信息

 

连接方法

1、本地命名

tnsnames.ora是本地命名文件

需要客户机解析文件

支持所有的Oracle Net协议

支持高级连接选项，如：

• 连接时故障转移

• 源路由
• 负载平衡

 

SQL>CONNECT hr/hr@orcl

 

2、简便连接

默认情况下是启用的

不需要进行客户端配置

仅支持TCP/IP（无SSL）

不支持高级选项，如：

• 连接时故障转移

• 源路由

• 负载平衡

 

SQL>CONNECT hr/[e-mail]:1521/dballg

 

 

 

3、目录命名

需要加载了Oracle Net名称解析信息的LDAP：

 - Oracle Internet Directory

 - Microsoft Active Directory Services

支持所有的Oracle Net协议

支持高级连接选项