srvctl 添加监听的语法如下:grid@rac1:/home/grid>srvctl add listener -h将监听程序配置添加到 Oracle Clusterware。用法: srvctl add listener [-l <lsnr_name>] [-s] [-p “[TCP:]<port>[, …][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]”] [-o <oracle_home>] [-k <net_num>] -l <lsnr_name> 监听程序名称 (默认名称为 LISTENER) -o <oracle_home> ORACLE_HOME 路径 (默认值为 CRS_HOME) -k <net_num> 网络编号 (默认编号为 1) -s 跳过端口检查 -p “[TCP:]<port>[, …][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]” 逗号分隔的 TCP 端口或监听程序端点 -h 输出用法加入新的监听YANGQLgrid@rac1:/home/grid>srvctl add listener -l YANGQL -p 1524 -o $ORACLE_HOME grid@rac1:/home/grid>cat /opt/11202/11.2.0/grid/network/admin/listener.ora LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by AgentLISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by AgentENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by AgentENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agentgrid@rac1:/home/grid>srvctl add listener -l YANGQL -p 1524 -o $ORACLE_HOME -k 1PRCN-3004 : 监听程序YANGQL已存在k 值在加入的时候，不做指定也是可以的！默认为1！grid@rac1:/home/grid>grid@rac1:/home/grid>启动新加入的监听YANGQL ,grid@rac1:/home/grid>srvctl start listener -l YANGQLlistener.ora ,endpoints_listener.ora 两个文件会多出 新加入的监听信息：grid@rac1:/home/grid>cat /opt/11202/11.2.0/grid/network/admin/listener.ora YANGQL=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=YANGQL)))) # line added by Agentgrid@rac1:/home/grid>cat /opt/11202/11.2.0/grid/network/admin/endpoints_listener.ora YANGQL_RAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1524))(ADDRESS=(PROTOCOL=TCP)(HOST=10.250.7.225)(PORT=1524)(IP=FIRST)))) # line added by AgentLISTENER_RAC1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.250.7.225)(PORT=1521)(IP=FIRST)))) # line added by Agent手工修改listener.ora 加入静态监听！ grid@rac1:/home/grid>vim /opt/11202/11.2.0/grid/network/admin/listener.ora SID_LIST_YANGQL = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = rac) (ORACLE_HOME = /opt/11202/11.2.0/grid) (SID_NAME =rac1) ) )
YANGQL=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=YANGQL)))) # line added by AgentLISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by AgentLISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by AgentENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by AgentENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by AgentENABLE_GLOBAL_DYNAMIC_ENDPOINT_YANGQL=ON # line added by Agent “/opt/11202/11.2.0/grid/network/admin/listener.ora” 15L, 665C 已写入 重新启动监听YANGQLgrid@rac1:/home/grid>srvctl stop listener -l YANGQLgrid@rac1:/home/grid>srvctl start listener -l YANGQL 查看其状态： grid@rac1:/home/grid>lsnrctl status YANGQLLSNRCTL for Linux: Version 11.2.0.2.0 – Production on 04-DEC-2011 22:32:08Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=YANGQL)))STATUS of the LISTENER————————Alias YANGQLVersion TNSLSNR for Linux: Version 11.2.0.2.0 – ProductionStart Date 04-DEC-2011 22:31:59Uptime 0 days 0 hr. 0 min. 9 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /opt/11202/11.2.0/grid/network/admin/listener.oraListener Log File /opt/11202/11.2.0/grid/log/diag/tnslsnr/rac1/yangql/alert/log.xmlListening Endpoints Summary… (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=YANGQL))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.250.7.225)(PORT=1524))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.250.7.111)(PORT=1524)))Services Summary…Service “rac” has 1 instance(s). Instance “rac1”, status UNKNOWN, has 1 handler(s) for this service…The command completed successfullygrid@rac1:/home/grid>至此，操作完毕，当然也可以使用图形界面工具来操作，但是个人觉得手工使用srvctl 工具更加方便！
