oracle

推荐列表 站点导航

当前位置:首页 > 数据库 > oracle >

oracle 11g RAC 常用命令整理分享

来源:网络整理  作者:网络  发布时间:2020-12-13 17:29
很多朋友会经常用到oracle 11g RAC的命令,今天我也用到了,同时也整理了一些常用的命令,以备不时之需...
  Start options: open
11)、节点应用程序配置 —(VIP、GSD、ONS、监听器)
13)、集群中所有正在运行的实例 — (SQL):
  VIP exists.:rac02
  Network is enabled

  Check CTSS state started...
  eONS is enabled
  [grid@rac02 ~]$ srvctl config vip -n rac02
  [grid@rac02 ~]$ srvctl config asm -a
  Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

  VIP rac02-vip is running on node: rac02
  Listener LISTENER is running on node(s): rac01,rac02
  GSD is disabled

  CRS-4537: Cluster Ready Services is online
  [oracle@rac01 ~]#srvctl start database -d racdb 服务器上启动 Oracle Clusterware 系统:
  End points: TCP:1521
资源中有任何一个还在运行,则整个命令失败。使用 -f 选项无条件地停止所有资源并
  使用 SRVCTL 启动/停止所有实例:

  End points: TCP:1521
  Stop options: immediate

  [grid@rac02 ~]$ cluvfy comp clocksync -verbose
5)、列出所有的配置数据库:
  -l option has been deprecated and will be ignored.
  GSD is not running on node: rac01
  Check: CTSS Resource running on all nodes
  [grid@rac02 ~]$ srvctl status database -d racdb
database_status db_status , active_state state , host_name host FROM gv$instance ORDER BY inst_id;
  Node Name State
  [grid@rac02 ~]$ srvctl config scan
  [grid@rac02 ~]$ srvctl status vip -n rac01
  Disk Groups: RACDB_DATA,FRA
  VIP rac01-vip is enabled
  VIP rac01-vip is enabled
  Network is running on node: rac01
  [root@rac01 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster
  ONS daemon is running on node: rac02
  Database is enabled
  Services:
  VIP exists.: /rac02-vip/192.168.1.54/255.255.255.0/eth0
停止 Oracle Clusterware 系统。
  Instance racdb1 is running on node rac01
6)、数据库配置:
7)、ASM状态以及ASM配置:
  Check of Clusterware install passed
  Result: CTSS resource check passed


  "[rac02]"
  Oracle Cluster Time Synchronization Services check passed
  Database role: PRIMARY
  GSD is not running on node: rac02
  Querying CTSS for time offset on all nodes...
  Listener LISTENER is enabled
  另请注意,可通过指定 -all 选项在集群中所有服务器上停止 Oracle Clusterware
1)、检查集群状态:
10)、VIP各个节点的状态以及配置:
  /u01/app/11.2.0/grid on node(s) rac02,rac01
  Instance racdb1 is running on node rac01
  ONS daemon exists. Local port 6100, remote port 6200
8)、TNS监听器状态以及配置:
  SCAN VIP scan1 is running on node rac02
  [grid@rac02 ~]$ srvctl status asm
  Spfile: +RACDB_DATA/racdb/spfileracdb.ora
  Home: <CRS home>
  ONS daemon is running on node: rac01
4)、节点应用程序状态:
  Time offset is within the specified limits on the following set of nodes:
  Database is administrator managed
  SELECT inst_id , instance_number inst_no , instance_name inst_name , parallel , status ,
  Name: LISTENER
  Result: Query of CTSS for time offset passed

  注:可通过指定 -all 选项在集群中所有服务器上启动 Oracle Clusterware 系统。
  VIP rac02-vip is enabled
  VIP rac02-vip is running on node: rac02

  [grid@rac02 ~]$ srvctl config listener -a
  [grid@rac02 ~]$ srvctl config database
  [grid@rac02 ~]$ crsctl check cluster
  SCAN VIP scan1 is enabled
  VIP exists.: /rac01-vip/192.168.1.53/255.255.255.0/eth0
  Network is running on node: rac02

  Verifying Clock Synchronization across the cluster nodes
  racdb
  ------------------------------------ ------------------------
  SCAN name: rac-scan.xzxj.edu.cn, Network: 1/192.168.1.0/255.255.255.0/eth0
  CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
  VIP exists.: /rac01-vip/192.168.1.53/255.255.255.0/eth0
  ONS is enabled
  eONS daemon is running on node: rac02

  Domain: xzxj.edu.cn
  [root@rac02 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster –all
  ASM listener: LISTENER
  [grid@rac02 ~]$ srvctl status listener
  Node Name Time Offset Status
  rac02 0.0 passed
  ASM is enabled.
  Network: 1, Owner: grid
  Instance racdb2 is running on node rac02
  VIP exists.:rac01
  [root@rac01 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster
  以下操作需用root用户执行。
  Server pools: racdb
  CRS-4533: Event Manager is online
  还可以通过列出服务器(各服务器之间以空格分隔)在集群中一个或多个指定的
  GSD exists.
  ASM home: /u01/app/11.2.0/grid
  VIP rac01-vip is running on node: rac01
  Result: Check of clock time offsets passed
  Check: Reference Time Offset
  [root@rac02 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster –all
  Database instances: racdb1,racdb2
  [grid@rac02 ~]$ srvctl status instance -d racdb -i racdb1
  Home: <CRS home>
12)、验证所有集群节点间的时钟同步:
  /u01/app/11.2.0/grid on node(s) rac02,rac01
  ASM is running on rac01,rac02
3)、检查单个实例状态:
14)、所有数据库文件及它们所在的 ASM 磁盘组 — (SQL):
  Checking if Clusterware is installed on all nodes...
  VIP rac02-vip is enabled
  VIP exists.: /rac02-vip/192.168.1.54/255.255.255.0/eth0
  SCAN VIP name: scan1, IP: /rac-scan.xzxj.edu.cn/192.168.1.55
  Verification of Clock Synchronization across the cluster nodes was successful.
2)、所有 Oracle 实例 —(数据库状态):
  Name: LISTENER
 注:在运行“crsctl stop cluster”命令之后,如果 Oracle Clusterware 管理的
  VIP exists.:rac01
系统。如下所示,在rac01和rac02上停止oracle clusterware系统:

  [root@rac01 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster -n rac01 rac02
  rac02 Active
  Reference Time Offset Limit: 1000.0 msecs
  (1)、在本地服务器上停止Oracle Clusterware 系统:
  Network: 1, Owner: grid
  [grid@rac02 ~]$ srvctl config nodeapps -a -g -s -l
  eONS daemon is running on node: rac01
  在本地服务器上启动oralce clusterware系统:
  [oracle@rac01 ~]#srvctl stop database -d racdb
  Database unique name: racdb
  Node Name Status
  Database name: racdb
9)、SCAN状态以及配置:
  [grid@rac02 ~]$ srvctl status scan
  VIP rac01-vip is running on node: rac01

  Checking if CTSS Resource is running on all nodes...
  [grid@rac02 ~]$ srvctl status vip -n rac02
16)、启动和停止集群:
  CRS-4529: Cluster Synchronization Services is online
  Oracle user: oracle
  [grid@rac02 ~]$ srvctl config vip -n rac01
  rac02 passed
  ------------ ------------------------ ------------------------
  VIP exists.:rac02
  Management policy: AUTOMATIC
  Check: CTSS state
  [grid@rac02 ~]$ srvctl config database -d racdb -a

  [grid@rac02 ~]$ srvctl status nodeapps
  ------------------------------------ ------------------------
15)、ASM 磁盘卷:

相关热词: oracle 命令

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供用于网络技术学习参考,学习中请遵循相关法律法规!

本文地址: https://www.juheyunku.com/sql/oracle/3358.shtml

Copyright © www.juheyunku.com      关于 | 合作 | 声明 | 联系 | 更新 | 地图 | Tags

oracle 11g RAC 常用命令整理分享

2020-12-13 编辑:网络

  Start options: open
11)、节点应用程序配置 —(VIP、GSD、ONS、监听器)
13)、集群中所有正在运行的实例 — (SQL):
  VIP exists.:rac02
  Network is enabled

  Check CTSS state started...
  eONS is enabled
  [grid@rac02 ~]$ srvctl config vip -n rac02
  [grid@rac02 ~]$ srvctl config asm -a
  Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

  VIP rac02-vip is running on node: rac02
  Listener LISTENER is running on node(s): rac01,rac02
  GSD is disabled

  CRS-4537: Cluster Ready Services is online
  [oracle@rac01 ~]#srvctl start database -d racdb 服务器上启动 Oracle Clusterware 系统:
  End points: TCP:1521
资源中有任何一个还在运行,则整个命令失败。使用 -f 选项无条件地停止所有资源并
  使用 SRVCTL 启动/停止所有实例:

  End points: TCP:1521
  Stop options: immediate

  [grid@rac02 ~]$ cluvfy comp clocksync -verbose
5)、列出所有的配置数据库:
  -l option has been deprecated and will be ignored.
  GSD is not running on node: rac01
  Check: CTSS Resource running on all nodes
  [grid@rac02 ~]$ srvctl status database -d racdb
database_status db_status , active_state state , host_name host FROM gv$instance ORDER BY inst_id;
  Node Name State
  [grid@rac02 ~]$ srvctl config scan
  [grid@rac02 ~]$ srvctl status vip -n rac01
  Disk Groups: RACDB_DATA,FRA
  VIP rac01-vip is enabled
  VIP rac01-vip is enabled
  Network is running on node: rac01
  [root@rac01 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster
  ONS daemon is running on node: rac02
  Database is enabled
  Services:
  VIP exists.: /rac02-vip/192.168.1.54/255.255.255.0/eth0
停止 Oracle Clusterware 系统。
  Instance racdb1 is running on node rac01
6)、数据库配置:
7)、ASM状态以及ASM配置:
  Check of Clusterware install passed
  Result: CTSS resource check passed


  "[rac02]"
  Oracle Cluster Time Synchronization Services check passed
  Database role: PRIMARY
  GSD is not running on node: rac02
  Querying CTSS for time offset on all nodes...
  Listener LISTENER is enabled
  另请注意,可通过指定 -all 选项在集群中所有服务器上停止 Oracle Clusterware
1)、检查集群状态:
10)、VIP各个节点的状态以及配置:
  /u01/app/11.2.0/grid on node(s) rac02,rac01
  Instance racdb1 is running on node rac01
  ONS daemon exists. Local port 6100, remote port 6200
8)、TNS监听器状态以及配置:
  SCAN VIP scan1 is running on node rac02
  [grid@rac02 ~]$ srvctl status asm
  Spfile: +RACDB_DATA/racdb/spfileracdb.ora
  Home: <CRS home>
  ONS daemon is running on node: rac01
4)、节点应用程序状态:
  Time offset is within the specified limits on the following set of nodes:
  Database is administrator managed
  SELECT inst_id , instance_number inst_no , instance_name inst_name , parallel , status ,
  Name: LISTENER
  Result: Query of CTSS for time offset passed

  注:可通过指定 -all 选项在集群中所有服务器上启动 Oracle Clusterware 系统。
  VIP rac02-vip is enabled
  VIP rac02-vip is running on node: rac02

  [grid@rac02 ~]$ srvctl config listener -a
  [grid@rac02 ~]$ srvctl config database
  [grid@rac02 ~]$ crsctl check cluster
  SCAN VIP scan1 is enabled
  VIP exists.: /rac01-vip/192.168.1.53/255.255.255.0/eth0
  Network is running on node: rac02

  Verifying Clock Synchronization across the cluster nodes
  racdb
  ------------------------------------ ------------------------
  SCAN name: rac-scan.xzxj.edu.cn, Network: 1/192.168.1.0/255.255.255.0/eth0
  CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
  VIP exists.: /rac01-vip/192.168.1.53/255.255.255.0/eth0
  ONS is enabled
  eONS daemon is running on node: rac02

  Domain: xzxj.edu.cn
  [root@rac02 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster –all
  ASM listener: LISTENER
  [grid@rac02 ~]$ srvctl status listener
  Node Name Time Offset Status
  rac02 0.0 passed
  ASM is enabled.
  Network: 1, Owner: grid
  Instance racdb2 is running on node rac02
  VIP exists.:rac01
  [root@rac01 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster
  以下操作需用root用户执行。
  Server pools: racdb
  CRS-4533: Event Manager is online
  还可以通过列出服务器(各服务器之间以空格分隔)在集群中一个或多个指定的
  GSD exists.
  ASM home: /u01/app/11.2.0/grid
  VIP rac01-vip is running on node: rac01
  Result: Check of clock time offsets passed
  Check: Reference Time Offset
  [root@rac02 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster –all
  Database instances: racdb1,racdb2
  [grid@rac02 ~]$ srvctl status instance -d racdb -i racdb1
  Home: <CRS home>
12)、验证所有集群节点间的时钟同步:
  /u01/app/11.2.0/grid on node(s) rac02,rac01
  ASM is running on rac01,rac02
3)、检查单个实例状态:
14)、所有数据库文件及它们所在的 ASM 磁盘组 — (SQL):
  Checking if Clusterware is installed on all nodes...
  VIP rac02-vip is enabled
  VIP exists.: /rac02-vip/192.168.1.54/255.255.255.0/eth0
  SCAN VIP name: scan1, IP: /rac-scan.xzxj.edu.cn/192.168.1.55
  Verification of Clock Synchronization across the cluster nodes was successful.
2)、所有 Oracle 实例 —(数据库状态):
  Name: LISTENER
 注:在运行“crsctl stop cluster”命令之后,如果 Oracle Clusterware 管理的
  VIP exists.:rac01
系统。如下所示,在rac01和rac02上停止oracle clusterware系统:

  [root@rac01 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster -n rac01 rac02
  rac02 Active
  Reference Time Offset Limit: 1000.0 msecs
  (1)、在本地服务器上停止Oracle Clusterware 系统:
  Network: 1, Owner: grid
  [grid@rac02 ~]$ srvctl config nodeapps -a -g -s -l
  eONS daemon is running on node: rac01
  在本地服务器上启动oralce clusterware系统:
  [oracle@rac01 ~]#srvctl stop database -d racdb
  Database unique name: racdb
  Node Name Status
  Database name: racdb
9)、SCAN状态以及配置:
  [grid@rac02 ~]$ srvctl status scan
  VIP rac01-vip is running on node: rac01

  Checking if CTSS Resource is running on all nodes...
  [grid@rac02 ~]$ srvctl status vip -n rac02
16)、启动和停止集群:
  CRS-4529: Cluster Synchronization Services is online
  Oracle user: oracle
  [grid@rac02 ~]$ srvctl config vip -n rac01
  rac02 passed
  ------------ ------------------------ ------------------------
  VIP exists.:rac02
  Management policy: AUTOMATIC
  Check: CTSS state
  [grid@rac02 ~]$ srvctl config database -d racdb -a

  [grid@rac02 ~]$ srvctl status nodeapps
  ------------------------------------ ------------------------
15)、ASM 磁盘卷:

本站内容来源于网络,如有侵权请与我们联系,我们会及时删除,我们深感抱歉!
注:本站所有信息仅供学习参考!
本文地址为 https://www.juheyunku.com/sql/oracle/3358.shtml

相关文章

风云图片

推荐阅读

返回oracle频道首页