oracle 11g RAC 常用命令整理分享
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
相关文章
热门TAG
命令 外链 企业网站 白帽 php 织梦教程 dedecms修改内容 javascript 织梦 功能 标签 调用 详解 技巧 权重 服务器 网站流量 Dedecms 织梦cms HTML tags标签 python jquery教程 jquery windows 蜘蛛 搜索引擎 网站收录 JSP 实例解析最新文章
-
OracleRAC的五大优势及其劣
时间:2021-01-05
-
Oracle优化器 自适应执行计
时间:2021-01-05
-
Oracle行内链接不会引起U
时间:2021-01-05
-
Window下Oracle Database 11g 发行
时间:2020-12-29
-
Oracle如何实现like多个值的
时间:2020-12-29
-
maven添加oracle依赖失败问题
时间:2020-12-29
-
OracleRAC基本概念及入门
时间:2020-12-29
-
Azure File Storage 基本用法
时间:2020-12-26
热门文章
-
Azure Queue Storage 基本用法 Azure Storage 之
时间:2020-12-26
-
Oracle存储过程编程详解
时间:2020-12-07
-
win10下oracle 11g安装图文教程
时间:2020-12-25
-
oracle 数据库学习 基本结构介绍
时间:2020-12-13
-
Azure File Storage 基本用法 Azure Storage 之 F
时间:2020-12-26
-
windows使用sqlpus连接oracle 数据库的教程图
时间:2020-12-25
-
Window下Oracle Database 11g 发行版2安装教程
时间:2020-12-29
-
Oracle解锁的方式介绍
时间:2020-12-14
-
linux下oracle设置开机自启动实现方法
时间:2020-12-13
-
Oracle学习记录之使用自定义函数和触发器
时间:2020-12-07
