大家好,又见面了,我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE使用 1年只要46元 售后保障 童叟无欺
oracle11gRAC之srvctl命令:
srvctl版本查询:
[grid@dbserver1:/home/grid]$srvctl -V
srvctl version: 11.2.0.1.0
srvctl常用命令分类:
*增加 oracle asm/database/listener 注册信息
eg:srvctl add asm -l LISTENER -p +crs/dbserve-cluster/ASMPARAMETERFILE/registry.253.743836405
eg: srvctl add database -d orclqt -o /oracle/app/oracle/product/11.2.0/dbhome_1 -p +DATADG/orclqt/spfileorclqt.ora
eg: srvctl add listener -p TCP:1522 -o /u01/app/oracle/product/11.2.0/dbhome_1
*查看 oracle asm/database/listener 配置信息
eg: srvctl config asm -a
ASM home: /oracle/app/11.2.0/grid
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.770900461
ASM diskgroup discovery string:
ASM is enabled.
eg: srvctl config database -d orclqt -a
Database unique name: orclqt
Database name: orclqt
Oracle home: /oracle/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATADG/orclqt/spfileorclqt.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orclqt
Database instances: orclqt1,orclqt2
Disk Groups: DATADG
Services:
Database is enabled
Database is administrator managed
eg: srvctl config listener
Name: LISTENER
Network: 1, Owner: grid
Home: End points: TCP:1521
*查看 oracle database/instance/service/nodeapps/asm 状态情况
eg: srvctl status database -d orclqt
Instance orclqt1 is running on node dbserver1
Instance orclqt2 is running on node dbserver2
eg: srvctl status instance -d orclqt -i “orclqt1,orclqt2”
Instance orclqt1 is running on node dbserver1
Instance orclqt2 is running on node dbserver2
eg: srvctl status nodeapps -n dbserver1
-n option has been deprecated.
VIP dbserver1vip is enabled
VIP dbserver1vip is running on node: dbserver1
Network is enabled
Network is running on node: dbserver1
GSD is disabled
GSD is not running on node: dbserver1
ONS is enabled
ONS daemon is running on node: dbserver1
eONS is enabled
eONS daemon is running on node: dbserver1
eg: srvctl status asm
ASM is running on dbserver1,dbserver2
srvctl status asm -n dbserver2
ASM is running on dbserver2
*启动 oracle asm/database/listener 服务
eg: srvctl start asm
eg: srvctl start database -d orclqt -o /oracle/app/oracle/product/11.2.0/dbhome_1 -p +DATA/test/spfileorclqt.ora
eg: srvctl start listener -l LISTENER
*停止 oracle asm/database/listener 服务
eg: srvctl stop database -d orclqt
eg: srvctl stop instance -d orclqt -i qrclqt1
eg: srvctl stop asm -n dbserver1 -i +asm1
eg: srvctl stop listener -n dbserver1[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7417660/viewspace-1057793/,如需转载,请注明出处,否则将追究法律责任。
发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/194886.html原文链接:https://javaforall.cn
【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛
【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...