【RAC】srvctl管理工具添加新监听和静态注册
发表于:2024-10-03 作者:千家信息网编辑
千家信息网最后更新 2024年10月03日,srvctl 添加监听的语法如下:grid@rac1:/home/grid>srvctl add listener -h将监听程序配置添加到 Oracle Clusterware。用法: srvctl
千家信息网最后更新 2024年10月03日【RAC】srvctl管理工具添加新监听和静态注册srvctl 添加监听的语法如下:grid@rac1:/home/grid>srvctl add listener -h将监听程序配置添加到 Oracle Clusterware。用法: srvctl add listener [-l ] [-s] [-p "[TCP:][, ...][/IPC:][/NMP:][/TCPS:] [/SDP:]"] [-o ] [-k ] -l 监听程序名称 (默认名称为 LISTENER) -o ORACLE_HOME 路径 (默认值为 CRS_HOME) -k 网络编号 (默认编号为 1) -s 跳过端口检查 -p "[TCP:][, ...][/IPC:][/NMP:][/TCPS:] [/SDP:]" 逗号分隔的 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 工具更加方便!
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 工具更加方便!
监听
程序
工具
名称
手工
端口
静态
两个
个人
信息
图形
文件
时候
状态
界面
端点
网络
至此
语法
路径
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
定远软件开发有限公司
陈志泊数据库第三版
win10 ftp服务器教程
2核4g服务器有显卡吗
大兴区多功能网络技术诚信服务
在数据库上部署模块
网络安全是强调某一个
更新线上数据库表结构
西藏企业内部erp软件开发
科技大学互联网服务平台
宝山区营销软件开发采购
数据采集 实时数据库
手机软件开发拿什么
select查重复数据库
天龙八部安卓ios服务器
花都区软件开发技校
服务器的通信出错
打一发数据库
网络安全法 划重点
数据库中表怎么定义
杭州本普网络技术有限公司
前端项目用什么数据库
小蝶网络技术有限公司
数据库应用技术孙晨霞答案
网络安全软件是什么
服务器增加刷物区
哪些大学考研考数据库技术与应用
互联网时代科技经济
网络安全法 划重点
计算机防火墙技术数据库