oracle11gRAC之srvctl命令:

lixiang114發表於2012-03-31
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章