oracle监听深入浅出.docx

Oracle监听在专用服务器模式中，监听的工作极其简单，只是当客户端用户登录数据库时，客户端进程发送请求，服务器端的监听程序监听到用户进程的请求，使用listener.ora核对用户连接信息，如果正确，则启动一个服务器进程，然后把用户进程直接或者间接交付给服务器进程，至此监听程序的工作就完毕了，所以基本上监听是不会有负载的压力的，除非在同一时刻有大量的客户端进程并发的请求连接。在服务器端新建实例之后，可以通过netca命令调出图形配置界面，配置一个默认的监听程序，一般默认起名为LISTENER。[oracle@localhost admin]$ pwd/oracle/product/10.1.0/db/network/admin[oracle@localhost admin]$ [oracle@localhost admin]$ lltotal 16drwxr-x--- 2 oracle oinstall 4096 Mar 14 2014 samples-rw-r----- 1 oracle oinstall 172 Dec 26 2003 shrept.lst[oracle@localhost admin]$[oracle@localhost admin]$ netca调出配置监听的图形界面netca创建监听的目的就是为了在listener.ora文件中创建如下内容：[oracle@localhost admin]$ more listener.ora# listener.ora Network Configuration File: /oracle/product/10.1.0/db/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/product/10.1.0/db) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )一般需要把LISTENER下面的HOST改完该主机的ip地址即改为如下内容：SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/product/10.1.0/db) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 3)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )此时数据库监听的状态是：[oracle@localhost admin]$ lsnrctl statusLSNRCTL for Linux: Version .0 - Production on 04-JAN-2015 18:43:12Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=3)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version .0 - ProductionStart Date 04-JAN-2015 18:37:16Uptime 0 days 0 hr. 5 min. 56 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListen