通过设置不同的监听器,可以在一台服务器的多实例C环境中分离业务,使业务的停止和管理变得容易。 添加的方法除了netca以外比较简单
通过设置不同的监听器,可以在一台服务器的多实例C环境中分离业务,使业务的停止和管理变得容易。 的方法除了netca外,比较简单的方法是使用srvctl命令,具体用法如下
地址配置文件管理器。
usage : srvctl addlistener [-llcddwt-slcddwt-p ' [ TCP : GX dmz, GX dmz/IPC : GX dmz/NMP : GX dmz/tcps 3360
- llistenername (defaultnameislistener ) )。
- o Oracle _ homepath (defaultvalueiscrs _ home ) ) )。
- knetworknumber (defaultnumberis1) )。
-s Skip the checking of ports
-p '[TCP:gxdmz, GX dmz/IPC : GX dmz/NMP : GX dmz/tcps 3360 LCD dwt/SDP : ] ' commaseparatedtcpportsortsorlistsorlistttsorlistististttttted
- h打印用户
步骤如下。 数据库是oracle 11gr2版本
1、开始添加,使用网格用户
2、开始
rvctlstartlistener-l listener _ EPM
启动后相关文件已更改
监听器长情树叶=(description=(address_list=) address=(protocol=IPC ) ) (key=监听器长情树叶) )
listener=(description=(address _ list=(address=(protocol=IPC ) KEY=LISTENER ) ) ) #线添加按代理
listener _ scan1=(description=(address _ list=) address=(protocol=IPC ) ) (KEY=LISTENER_SCAN1) ) )
# listener=(description=(address _ list=) address=(protocol=IPC ) ) (KEY=LISTENER ) ) # line added by agage )
enable _ global _ dynamic _ endpoint _ listener=on # lineaddedbyagent
enable _ global _ dynamic _ endpoint _ listener _ scan1=on # lineaddedbyagent
enable _ global _ dynamic _ endpoint _ listener长情树叶=ON # line added by Agent
LISTENER长情树叶的冷傲的豆芽=(description=(address_list=) address=(protocol=TCP ) ) HOST=dtydb5-vip ) ) port
监听器的冷静豆芽=(description=) address _ list=(address=) protocol=TCP ) ) HOST=d
tydb5-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.235)(PORT=1521)(IP=FIRST)))) # line added by Agent3,查看资源的状态online
ora.LISTENER长情的树叶.lsnr
ONLINE ONLINE dtydb3
ONLINE ONLINE dtydb4
ONLINE ONLINE dtydb5
Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER长情的树叶))) STATUS of the LISTENER ------------------------ Alias LISTENER长情的树叶 Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production Start Date 13-SEP-2012 10:14:17 Uptime 0 days 0 hr. 2 min. 32 sec Trace Level off Listener Parameter File /oracle/11.2.0/grid/network/admin/listener.ora Listener Log File /oracle/11.2.0/grid/log/diag/tnslsnr/dtydb5/listener_epm/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER长情的树叶))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.235)(PORT=1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.245)(PORT=1522))) The listener supports no services The command completed successfully 4,vi listener.ora 添加以下信息,主要要修改三个节点的信息(后来证实,本步骤可以省略,可能因为静态监听信息已在endpoints_listener.ora文件中了) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = epmdb) (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1) (SID_NAME = epmdb3) ) ) 5, 重启listener 这时服务还是没有注册上来 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER长情的树叶))) STATUS of the LISTENER ------------------------ Alias LISTENER长情的树叶 Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production Start Date 13-SEP-2012 10:26:35 Uptime 0 days 0 hr. 0 min. 40 sec Trace Level off Listener Parameter File /oracle/11.2.0/grid/network/admin/listener.ora Listener Log File /oracle/11.2.0/grid/log/diag/tnslsnr/dtydb5/listener_epm/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER长情的树叶))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.235)(PORT=1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.245)(PORT=1522))) The listener supports no services The command completed successfully 6,什么原因?应该是local_listener设置问题,还需要修改该参数 sys@EPMDB3(dtydb5)> show parameter local NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=TCP)(HOST=10.4 .124.245)(PORT=1521)))) sys@EPMDB3(dtydb5)> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.245)(PORT=1522))))' scope=both sid='*'; 系统已更htdlm alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.243)(PORT=1522))))' scope=both sid='epmdb1'; alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.244)(PORT=1522))))' scope=both sid='epmdb2'; alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.4.124.245)(PORT=1522))))' scope=both sid='epmdb3'; 7,已成功注册 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER长情的树叶))) STATUS of the LISTENER ------------------------ Alias LISTENER长情的树叶 Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production Start Date 13-SEP-2012 10:26:35 Uptime 0 days 0 hr. 14 min. 12 sec Trace Level off Listener Parameter File /oracle/11.2.0/grid/network/admin/listener.ora Listener Log File /oracle/11.2.0/grid/log/diag/tnslsnr/dtydb5/listener_epm/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER长情的树叶))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.235)(PORT=1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.4.124.245)(PORT=1522))) Services Summary... Service "epmdb" has 1 instance(s). Instance "epmdb3", status READY, has 1 handler(s) for this service... The command completed successfully