srvctlユーティリティ
srvctlの概要
Usage: srvctl <command> <object> [<options>]
    command: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config
    objects: database|instance|service|nodeapps|asm|listener
For detailed help on each command and object and its options use:
    srvctl <command> <object> -h
インスタンスの起動と停止

インスタンスの起動

srvctl start instance -d <db_name> -i <instance_list> [-o {open|mount|nomount}] [-c <接続文字列> | -q]
  • -oを指定しない場合、openで動作する。
  • -c:userid/passwd@ネットサービス名 as sysdbaの指定が可能である。
  • -q:標準入力から接続文字列を指定することができる。

インスタンスの停止

srvctl stop instance -d <db_name> -i <instance_list> [-o {normal|transactional|immediate|abort}] [-c <接続文字列> | -q]
  • -oを指定しない場合、immediateで動作する。

使用例

[oracle@rac-node01 oracle]$ srvctl stop instance -d racdb -i RACDB1,RACDB2
[oracle@rac-node01 oracle]$ crs_stat -t
名前           型             ター...ト 状態      ホスト
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac-node01
ora....01.lsnr application    ONLINE    ONLINE    rac-node01
ora....e01.gsd application    ONLINE    ONLINE    rac-node01
ora....e01.ons application    ONLINE    ONLINE    rac-node01
ora....e01.vip application    ONLINE    ONLINE    rac-node01
ora....SM2.asm application    ONLINE    ONLINE    rac-node02
ora....02.lsnr application    ONLINE    ONLINE    rac-node02
ora....e02.gsd application    ONLINE    ONLINE    rac-node02
ora....e02.ons application    ONLINE    ONLINE    rac-node02
ora....e02.vip application    ONLINE    ONLINE    rac-node02
ora....B1.inst application    OFFLINE   OFFLINE
ora....B2.inst application    OFFLINE   OFFLINE
ora.racdb.db   application    OFFLINE   OFFLINE
[oracle@rac-node01 oracle]$ srvctl start instance -d racdb -i RACDB1,RACDB2 -o open
[oracle@rac-node01 oracle]$ crs_stat -t
名前           型             ター...ト 状態      ホスト
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac-node01
ora....01.lsnr application    ONLINE    ONLINE    rac-node01
ora....e01.gsd application    ONLINE    ONLINE    rac-node01
ora....e01.ons application    ONLINE    ONLINE    rac-node01
ora....e01.vip application    ONLINE    ONLINE    rac-node01
ora....SM2.asm application    ONLINE    ONLINE    rac-node02
ora....02.lsnr application    ONLINE    ONLINE    rac-node02
ora....e02.gsd application    ONLINE    ONLINE    rac-node02
ora....e02.ons application    ONLINE    ONLINE    rac-node02
ora....e02.vip application    ONLINE    ONLINE    rac-node02
ora....B1.inst application    ONLINE    ONLINE    rac-node01
ora....B2.inst application    ONLINE    ONLINE    rac-node02
ora.racdb.db   application    ONLINE    ONLINE    rac-node01
[oracle@rac-node01 oracle]$
データベースの起動と停止

データベースの起動

srvctl start database -d <db_name> [-o {open|mount|nomount}] [-c <接続文字列> | -q]

データベースの停止
srvctl start database -d <db_name> [-o {normal|transactional|immediate|abort}] [-c <接続文字列> | -q]

使用例
[oracle@rac-node01 oracle]$ srvctl stop database -d racdb -o immediate
[oracle@rac-node01 oracle]$ crs_stat -t
名前           型             ター...ト 状態      ホスト
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac-node01
ora....01.lsnr application    ONLINE    ONLINE    rac-node01
ora....e01.gsd application    ONLINE    ONLINE    rac-node01
ora....e01.ons application    ONLINE    ONLINE    rac-node01
ora....e01.vip application    ONLINE    ONLINE    rac-node01
ora....SM2.asm application    ONLINE    ONLINE    rac-node02
ora....02.lsnr application    ONLINE    ONLINE    rac-node02
ora....e02.gsd application    ONLINE    ONLINE    rac-node02
ora....e02.ons application    ONLINE    ONLINE    rac-node02
ora....e02.vip application    ONLINE    ONLINE    rac-node02
ora....B1.inst application    OFFLINE   OFFLINE
ora....B2.inst application    OFFLINE   OFFLINE
ora.racdb.db   application    OFFLINE   OFFLINE
[oracle@rac-node01 oracle]$ srvctl start database -d racdb
[oracle@rac-node01 oracle]$ crs_stat -t
名前           型             ター...ト 状態      ホスト
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac-node01
ora....01.lsnr application    ONLINE    ONLINE    rac-node01
ora....e01.gsd application    ONLINE    ONLINE    rac-node01
ora....e01.ons application    ONLINE    ONLINE    rac-node01
ora....e01.vip application    ONLINE    ONLINE    rac-node01
ora....SM2.asm application    ONLINE    ONLINE    rac-node02
ora....02.lsnr application    ONLINE    ONLINE    rac-node02
ora....e02.gsd application    ONLINE    ONLINE    rac-node02
ora....e02.ons application    ONLINE    ONLINE    rac-node02
ora....e02.vip application    ONLINE    ONLINE    rac-node02
ora....B1.inst application    ONLINE    ONLINE    rac-node01
ora....B2.inst application    ONLINE    ONLINE    rac-node02
ora.racdb.db   application    ONLINE    ONLINE    rac-node01
[oracle@rac-node01 oracle]$
RACのステータスの確認

データベースのステータス

Usage: srvctl status database -d <name> [-f] [-v] [-S <level>]
    -d <name>           Unique name for the database
    -f                  Include disabled applications
    -v                  Verbose output
    -S <level>          Additional information for EM Console
    -h                  Print usage

[oracle@rac-node01 oracle]$ srvctl status database -d racdb
Instance RACDB1 is running on node rac-node01
Instance RACDB2 is running on node rac-node02

インスタンスのステータス
Usage: srvctl status instance -d <name> -i "<inst_name_list>" [-f] [-v] [-S <level>]
    -d <name>           Unique name for the database
    -i "<inst,...>"     Comma separated instance names
    -f                  Include disabled applications
    -v                  Verbose output
    -S <level>          Additional information for EM Console
    -h                  Print usage

[oracle@rac-node01 oracle]$ srvctl status instance -d racdb -i RACDB2
Instance RACDB2 is running on node rac-node02

ASMインスタンスのステータス
Usage: srvctl status asm -n <node_name>
    -n <node>           Node name
    -h                  Print usage

[oracle@rac-node01 oracle]$ srvctl status asm -n rac-node02
ASM instance +ASM2 is running on node rac-node02.
サービスの起動と停止

サービスの確認

[rac-node01 oracle(RACDB1)] srvctl status service -d racdb -s OLTP
Service OLTP is running on instance(s) RACDB1, RACDB2
[rac-node01 oracle(RACDB1)] srvctl status service -d racdb -s BATCH
Service BATCH is running on instance(s) RACDB2
[rac-node01 oracle(RACDB1)]

RACDB2のBATCHを停止する
[rac-node01 oracle(RACDB1)] srvctl stop service -d racdb -s BATCH -i RACDB2
[rac-node01 oracle(RACDB1)] srvctl status service -d racdb -s BATCH
Service BATCH is running on instance(s)
[rac-node01 oracle(RACDB1)]

RACDB2のBATCHを起動する
[rac-node01 oracle(RACDB1)] srvctl start service -d racdb -s BATCH -i RACDB2
[rac-node01 oracle(RACDB1)] srvctl status service -d racdb -s BATCH
Service BATCH is running on instance(s) RACDB2
[rac-node01 oracle(RACDB1)]
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License