11g R2 RAC使用srvctl工具添加监听并手动加入静态注册信息
来源:互联网 发布:javascript 服务端 编辑:程序博客网 时间:2024/05/17 05:17
步骤如下:
检查默认network的network number,红色字体1,一会儿添加监听会用到:
[grid@rac121 admin]$ srvctl config networkNetwork exists: 1/10.1.252.0/255.255.255.0/eth0, type static
查看srvctl添加监听的语法:
[grid@rac121 admin]$ srvctl add listener -hAdds a listener configuration to the Oracle Clusterware.Usage: 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 name (default name is LISTENER) #监听名称 -o <oracle_home> ORACLE_HOME path (default value is CRS_HOME) #grid的HOME -k <net_num> network number (default number is 1) #最开始查看的网络号 -s Skip the checking of ports -p "[TCP:]<port>[, ...][/IPC:<key>][/NMP:<pipe_name>][/TCPS:<s_port>] [/SDP:<port>]" Comma separated tcp ports or listener endpoints #要添加的端口号 -h Print usage
添加监听:名称: LISTENER4 端口号:1524
[grid@rac121 ~]$ srvctl add listener -l LISTENER4 -o $ORACLE_HOME -p 1524 -k 1[grid@rac121 ~]$ srvctl start listener -l LISTENER4
创建完后会在配置文件endpoints_listener.ora和listener.ora中添加记录信息:
[grid@rac121 admin]$ lsendpoints_listener.ora listener1206183PM1248.bak listener.ora samples sqlnet1206199AM0038.bakendpoints_listener.ora.bak.rac121 listener1206199AM0038.bak listener.ora.bak.rac121 shrept.lst sqlnet.ora
查看添加 的信息:两个文件听红色字体部分
[grid@rac121 admin]$ cat listener.oraLISTENER4=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER4)))) # line added by AgentNEW_RACDB_LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=NEW_RACDB_LISTENER)))) # line added by Agent# listener.ora Network Configuration File: /oradata/oracleapp/11.2.0/grid/network/admin/listener.ora# Generated by Oracle configuration tools.[grid@rac121 admin]$ cat endpoints_listener.oraLISTENER4_RAC121=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac121-vip)(PORT=1524))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.252.121)(PORT=1524)(IP=FIRST)))) # line added by AgentNEW_RACDB_LISTENER_RAC121=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac121-vip)(PORT=1523))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.252.121)(PORT=1523)(IP=FIRST)))) # line added by AgentRACDB_LISTENER_RAC121=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac121-vip)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.252.121)(PORT=1522)(IP=FIRST)))) # line added by AgentLISTENER_RAC121=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rac121-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.252.121)(PORT=1521)(IP=FIRST)))) # line added by Agent
到此完成了监听的添加,再添加静态注册信息,vi listener.ora文件,在里面添加如下内容:
SID_LIST_LISTENER4 = #对应的监听名 (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = RACDB) (ORACLE_HOME = /oradata/oracleapp/11.2.0/grid) (SID_NAME = RACDB1) #节点对应的SID ) )
重启监听即完成静态注册:
[grid@rac121 admin]$ srvctl stop listener -l LISTENER4[grid@rac121 admin]$ srvctl start listener -l LISTENER4[grid@rac121 admin]$ lsnrctl status LISTENER4LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 19-JUN-2012 15:48:47Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER4)))STATUS of the LISTENER------------------------Alias LISTENER4Version TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date 19-JUN-2012 15:48:35Uptime 0 days 0 hr. 0 min. 11 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /oradata/oracleapp/11.2.0/grid/network/admin/listener.oraListener Log File /oradata/oracleapp/11.2.0/grid/log/diag/tnslsnr/rac121/listener4/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER4))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.252.121)(PORT=1524))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.252.75)(PORT=1524)))Services Summary...Service "RACDB" has 1 instance(s). Instance "RACDB1", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully[grid@rac121 admin]$
查看所有的监听状态:
grid@rac121 admin]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): rac121,rac122Listener LISTENER4 is enabledListener LISTENER4 is running on node(s): rac121,rac122Listener NEW_RACDB_LISTENER is enabledListener NEW_RACDB_LISTENER is running on node(s): rac121,rac122Listener RACDB_LISTENER is enabledListener RACDB_LISTENER is running on node(s): rac121,rac122
查看各个监听的配置:
[grid@rac121 admin]$ srvctl config listener -a Name: LISTENERNetwork: 1, Owner: gridHome: <CRS home> /oradata/oracleapp/11.2.0/grid on node(s) rac122,rac121End points: TCP:1521Name: LISTENER4Network: 1, Owner: gridHome: <CRS home> /oradata/oracleapp/11.2.0/grid on node(s) rac122,rac121End points: TCP:1524Name: NEW_RACDB_LISTENERNetwork: 1, Owner: gridHome: <CRS home> /oradata/oracleapp/11.2.0/grid on node(s) rac122,rac121End points: TCP:1523Name: RACDB_LISTENERNetwork: 1, Owner: gridHome: <CRS home> /oradata/oracleapp/11.2.0/grid on node(s) rac122,rac121End points: TCP:1522
到此就利用srvctl管理工具完成了添加新监听和静态注册的任务。
- 11g R2 RAC使用srvctl工具添加监听并手动加入静态注册信息
- 11g R2 RAC使用srvctl工具删除监听
- Oracle 11g R2 RAC:使用 srvctl 工具管理 service 资源
- 11g R2 rac linstener 监听配置
- 11g R2 rac listener 监听配置
- 给11gR2 RAC添加LISTENER监听器并静态注册
- 给11gR2 RAC添加LISTENER监听器并静态注册
- 给11gR2 RAC添加LISTENER监听器并静态注册
- 给11gR2 RAC添加LISTENER监听器并静态注册
- 给11gR2 RAC添加LISTENER监听器并静态注册
- Oracle 11G R2 RAC 添加节点
- Oracle 11G R2 RAC 添加节点
- 11G R2 RAC添加删除节点
- 11G R2 RAC监听管理---增加监听1
- 11G R2 RAC监听管理---增加监听2
- 11G R2 RAC监听管理---修改端口
- Oracle 11G R2 RAC 添加节点,添加asm磁盘
- oracle 11g RAC 如何手工建库使用srvctl 加资源
- Python函数式编程指南(三):迭代器
- C#的一些小技术 <1>
- Linux如何查找杀死僵死进程
- C# Tips:在继承中,new 与 override 的区别
- Wince获取Wifi的设备名、连接状态和信号强度
- 11g R2 RAC使用srvctl工具添加监听并手动加入静态注册信息
- 委托和事件
- win7应用程序无响应解决方法
- HBase MapReduce与Speculative Task
- [分享]Win7 32位与64位/x86与x64的区别
- Application Cache manifest 的处理 (Webkit)
- JQuery
- UIResponder inputView与inputAccessoryView
- Oracle DBLink 访问Lob 字段 ORA-22992 解决方法