Oracle集群检测命令

最新推荐文章于 2024-06-07 11:15:00 发布
最新推荐文章于 2024-06-07 11:15:00 发布
阅读量2.8k 收藏 7
点赞数
文章标签： 数据库 操作系统 网络
原文链接：http://www.cnblogs.com/dbalightyear/p/11228355.html
版权

select inst_id, count(inst_id) from gv$session group by inst_id order by inst_id;

srvctl stop database -d racdb(数据库名) -o immediate 关闭数据库关闭集群中的实例所有节点

su - grid

查看所有节点状态
olsnodes -s

检查集群中各组件状态 每个组件都应该是online
crsctl check cluster -all

查看SCAN监听器
ps -ef |grep -f scan
srvctl status scan_listener

查看集群资源
crsctl stat res -t

ASM实例查询
ps -ef |grep -i asm
srvctl config asm
srvctl status asm

检查数据库当前配置
srvctl config database -d racdb(数据库名) -a

srvctl status database -d racdb -f -v


调整ASM SGA
su - grid
sqlplus / as sysasm
alter 修改
startup force;重启asm实例

 

调整数据库实例 SGA

su - oracle
sqlplus / as sysdba
alter system 修改
srvctl stop instance -d racdb(数据库名) -i racdb1(数据库实例名)
srvctl start instance -d racdb(数据库名) -i racdb1(数据库实例名)


集群的启动(root用户执行)
一步到位启动当前节点的CRS
crsctl start crs
二步走
crsctl start has(启动OHASD进程)
crsctl start cluster

crsctl start crs 管理本地节点
crsctl start cluster启动任何节点CRS服务
crsctl start cluster需要其它节点OHASD进程运行

集群的关闭(root用户执行)
一步到位关闭当前节点的CRS
crsctl stop crs
二步走
crsctl stop has(启动OHASD进程)
crsctl stop cluster


检查整个集群资源
olsnodes -s
crsctl check cluster
crsctl check cluster -all
crsctl check crs
crsctl stat res -t
crsctl status resource -t -init

重启网络服务
service network restart
停止CRS残留进程
ps -ef |grep ora |awk '{print $2}' |xargs kill -9
ps -ef |grep grid |awk '{print $2}' |xargs kill -9
ps -ef |grep asm |awk '{print $2}' |xargs kill -9
ps -ef |grep storage |awk '{print $2}' |xargs kill -9
ps -ef |grep grid
ps -ef |grep ora
ps -ef |grep asm
ps -ef |grep crs


--------------------------------------------
--------
--------本文件只是为了方便大家进行命令拷贝
--------使用时请进行相应的替换和修改
--------
--------------------------------------------

cat /etc/inittab
more /etc/init.d/ohasd
cd /etc/rc.d/rc5.d
ls -al *hasd*
ps -ef |grep ohasd.bin
$GRID_HOME/log/`hostname`/ohasd/ohasd.log
OLR
查找
ll |grep ha

crsctl status resource -init -t

cat /etc/oracle/scls_scr/`hostname`/root/ohasdstr
crsctl disable crs
cat /etc/oracle/scls_scr/`hostname`/root/ohasdstr
crsctl enable crs


$GRID_HOME/log/`hostname`/agent/ohasd/
$GRID_HOME/log/`hostname`/ohasd/oracssdagent_root
ll $GRID_HOME/log/`hostname`/agent/crsd

$GRID_HOME/log/`hostname`/crsd/crsd.log

ps -ef |grep agent|grep -v root


/taryartar/12c/grid_home/log/rac1/agent

cssdagent, cssdmonitor, oraagent, and oraagent_root.

SQL> alter system set sga_max_size=500M scope=spfile;
SQL> startup force;

crsctl status resource -t -init


$GRID_HOME/log/`hostname`/agent/crsd
$GRID_HOME/log/`hostname`/agent/crsd

ASM Instance

crsctl status server -f

crsctl status resource -t -init

 

 

crsctl start crs
crsctl check crs
crsctl stat res -t
crsctl status resource -t -init

crsctl start has
crsctl status resource -t -init
crsctl start cluster
crsctl status resource -t -init
crsctl start cluster
crsctl check crs
crsctl stat res -t
crsctl status resource -t -init

===停止集群===
crsctl stop crs
crsctl stop crs -f
crsctl check crs
crsctl stat res -t
crsctl status resource -t -init

ps -ef |grep ora |awk '{print $2}' |xargs kill -9
ps -ef |grep grid |awk '{print $2}' |xargs kill -9
ps -ef |grep asm |awk '{print $2}' |xargs kill -9
ps -ef |grep storage |awk '{print $2}' |xargs kill -9
ps -ef |grep grid
ps -ef |grep ora
ps -ef |grep asm
ps -ef |grep storage

ifconfig -a

service network restart

 

 

crsctl stop cluster
crsctl check has
ps -ef |grep has
crsctl stop has
ifconfig -a
service network restart

crsctl status resource -t -init
crsctl check crs
crsctl stat res -t

ps -ef |grep ora |awk '{print $2}' |xargs kill -9
ps -ef |grep grid |awk '{print $2}' |xargs kill -9
ps -ef |grep asm |awk '{print $2}' |xargs kill -9
ps -ef |grep storage |awk '{print $2}' |xargs kill -9
ps -ef |grep grid
ps -ef |grep ora
ps -ef |grep asm
ps -ef |grep crs

 

Stop cluster will shutdown across all nodes and will NOT shutdown HAS – crsctl stop cluster
===启动集群===
crsctl start crs
crsctl check crs
crsctl check has
crsctl stat res -t
crsctl status resource -t -init


ps -ef |grep grid
ps -ef |grep ora
ps -ef |grep asm


ifconfig -a

CRS-4639: Could not contact Oracle High Availability Services
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services
daemon
CRS-4534: Cannot communicate with Event Manager


crsctl start has
crsctl status resource -t -init
crsctl check crs

crsctl start cluster -h
crsctl start cluster # Start CRS stack
crsctl start cluster -all
crsctl status resource -t -init
crsctl check crs
crsctl stat res -t

ps -ef |grep grid
ps -ef |grep ora
ps -ef |grep asm


ifconfig -a

olsnodes -s
crsctl check cluster
crsctl check cluster -all
crsctl check crs
crsctl stat res -t

 

cat $ORACLE_BASE/diag/rdbms/"$DB_UNIQUE_NAME"/"$ORACLE_SID"/trace/"alert_${ORACLE_SID}.log" |grep -i asm

SELECT instance_name, db_name, status FROM V$ASM_CLIENT;
SELECT INSTANCE_NAME FROM V$ASM_CLIENT;

 

[root]# /u01/app/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
只表示 开始启动 并不表示成功，成功还要花很长时间


===表决盘的管理
asmcmd lsdg
crsctl query css votedisk
表决盘迁移到ocfs
crsctl replace votedisk /myocfs1/storage/vd6C
表决盘迁移到ASM
crsctl replace votedisk +DG1

crsctl query css votedisk
添加表决盘，如果表决盘存放在ASM中，则表决文件的镜像由磁盘组完成，不再需要另外一个磁盘组做镜像。
不允许表决盘同时存在ASM和集群文件系统中
crsctl add css votedisk /myocfs1/vdfile5
crsctl add css votedisk +DG2
crsctl add css votedisk /myocfs1/storage/vd5
crsctl query css votedisk

crsctl query css votedisk
crsctl delete css votedisk afb49b9a67304f9ebfaf4278c2eeeb71

===OCR
ocrcheck

touch /myocfs1/ocr_mirror1
chown root:oinstall /myocfs1/ocr_mirror1
chmod 640 /myocfs1/ocr_mirror1

ocrconfig -add /myocfs1/ocr_mirror1
ocrconfig -add +DG2
ocrconfig -delete /myocfs1/ocr_mirror1
ocrconfig -delete +DG2

touch /myocfs1/ocr_new
chown root:oinstall /myocfs1/ocr_new
chmod 640 /myocfs1/ocr_new

OCR替换
touch /myocfs1/ocr_new
chown root:oinstall /myocfs1/ocr_new
chmod 640 /myocfs1/ocr_new
ocrconfig -replace /myocfs1/ocr_mirror1 -replacement /myocfs1/ocr_new
ASM中不用创建文件
ocrconfig -replace /myocfs1/ocr_new -replacement +DG1
ocrconfig -replace +DG1 -replacement /myocfs1/ocr_new

OCR备份
ocrconfig -manualbackup
ocrconfig -showbackup
dump备份的ocr文件，会生成一个文件，查看生成文件
ocrdump -backupfile /taryartar/12c/grid_home/cdata/mycluster/backup_20150520_231258.ocr

导出ocr文件，文件名ocrEXP
ocrconfig -export ocrEXP
ocrconfig -import ocrEXP

ocr恢复关系
ocrconfig -manualbackup and ocrconfig -restore
ocrconfig -export and ocrconfig -import


===ocr voting disk 恢复试验（集群文件系统）======

检查ocr文件位置
ocrcheck
/myocfs1/ocr_new
检查表决盘位置
crsctl query css votedisk
/myocfs1/storage/vd6B
手动备份ocr
ocrconfig -manualbackup
/taryartar/12c/grid_home/cdata/mycluster/backup_20150521_152003.ocr
ocrconfig -showbackup

删除
rm -rf /myocfs1/ocr_new
rm -rf /myocfs1/storage/vd6B
查看ocr和表决盘是否存在
ocrcheck
crsctl query css votedisk


####恢复#####
首先查看集群的节点数目
olsnodes
每个节点上面强行关闭
crsctl stop crs -f
sudo su - grid关闭实例，两个节点执行
sqlplus / as sysasm
SQL> shutdown abort;
ps -ef |grep ora|awk '{print $2}'|xargs kill -9
ps -ef |grep asm|awk '{print $2}'|xargs kill -9
ps -ef |grep grid|awk '{print $2}'|xargs kill -9

ocr的恢复
ocrconfig -showbackup

on one node
ll /myocfs1/ocr_new
创建文件
touch /myocfs1/ocr_new
chown root:oinstall /myocfs1/ocr_new
chmod 640 /myocfs1/ocr_new
ll /myocfs1/ocr_new
从备份中恢复
ocrconfig -restore /taryartar/12c/grid_home/cdata/mycluster/backup_20150521_152003.ocr
ll /myocfs1/ocr_new
ocrcheck

on one node
启动集群，将集群启动到排他模式，在排他模式可以重建表决盘
crsctl start crs -excl
crsctl query css votedisk
如果原来的文件可以用，可以使用replace替换
crsctl replace votedisk /myocfs1/storage/vd6B
如果原来的文件不可用，可以新增加表决盘
crsctl add css votedisk /myocfs1/storage/vd6C
crsctl query css votedisk

crsctl stop crs -f

正式的启动集群，每个节点都执行
crsctl start crs
cluvfy comp ocr -n all -verbose
cluvfy comp vdisk -n all -verbose
crsctl check cluster -all

crsctl stat res -t

检查ocr和votedisk的完整新
cluvfy comp ocr -n all -verbose
cluvfy comp vdisk -n all -verbose


===ocr voting disk 恢复试验（ASM篇）======
ocrcheck
crsctl query css votedisk

COLUMN PATH FORMAT A20;
SET LINESIZE 500
select dg.NAME as disk_group,d.NAME,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,PATH from V$ASM_DISK d ,V$ASM_DISKGROUP dg
where d.GROUP_NUMBER=dg.GROUP_NUMBER
order by dg.NAME;

破坏
dd if=/dev/zero of=/dev/raw/raw3 bs=1024k count=1

#####恢复#####
olsnodes
crsctl stop crs -f
sudo su - grid关闭实例
sqlplus / as sysasm
SQL> shutdown abort;
ps -ef |grep ora|awk '{print $2}'|xargs kill -9
ps -ef |grep asm|awk '{print $2}'|xargs kill -9
ps -ef |grep grid|awk '{print $2}'|xargs kill -9


on one node
crsctl start crs -excl -nocrs (表示不启动crsd进程)
crsctl stop resource ora.crsd -init

sudo su - grid
select name,state from v$asm_diskgroup;
drop diskgroup dg1 force including contents;

重建磁盘组
create diskgroup dg1
external redundancy
disk
'/dev/raw/raw3' name nr_1;

ALTER DISKGROUP dg1 SET ATTRIBUTE 'compatible.asm' = '12.1.0.0.0' ;
ALTER DISKGROUP dg1 SET ATTRIBUTE 'compatible.rdbms' = '12.1.0.0.0';
ALTER DISKGROUP dg1 SET ATTRIBUTE 'compatible.advm' = '12.1.0.0.0';

drop diskgroup dg1 force including contents;

ocrconfig -showbackup
重启一下集群，crsctl stop/start crs，再执行还原
ocrconfig -restore /taryartar/12c/grid_home/cdata/mycluster/backup00.ocr
ocrcheck

表决盘恢复
crsctl query css votedisk
将表决盘恢复到+dg1，也可以恢复到其他磁盘组
crsctl replace votedisk +dg1
crsctl query css votedisk
crsctl stop crs -f


crsctl start crs

crsctl check cluster -all
crsctl stat res -t
cluvfy comp ocr -n all -verbose
cluvfy comp vdisk -n all -verbose


====本地注册表=================
ll $GRID_HOME/cdata/"`hostname`.olr"
ocrcheck -local
ocrdump -local -stdout
ocrconfig -local -manualbackup
ocrconfig -local -showbackup
ocrdump -local -backupfile /taryartar/12c/grid_home/cdata/rac1/backup_20150521_172006.olr

ocrconfig -local -backuploc /taryartar/12c/grid_home

 

ocrconfig -local -export olr_dump
ocrconfig -local -import olr_dump

ocrconfig -local -restore file_name
ocrconfig -local -manualbackup

--还原OLR:
ocrcheck -local
/taryartar/12c/grid_home/cdata/rac1.olr

ocrconfig -local -showbackup
/taryartar/12c/grid_home/backup_20150521_172440.olr

ocrconfig -local -manualbackup

rm -rf 模拟本地注册表丢失
crsctl stop crs -f
ps -ef |grep ora|awk '{print $2}'|xargs kill -9
ps -ef |grep asm|awk '{print $2}'|xargs kill -9
ps -ef |grep grid|awk '{print $2}'|xargs kill -9


hostname
touch /taryartar/12c/grid_home/cdata/rac1.olr
chmod 600 /taryartar/12c/grid_home/cdata/rac1.olr
chown root:oinstall /taryartar/12c/grid_home/cdata/rac1.olr

执行恢复
ocrconfig -local -restore /taryartar/12c/grid_home/backup_20150521_172440.olr
ocrcheck -local

crsctl start crs
crsctl check cluster -all
crsctl stat res -t
cluvfy -local comp olr

=================公有网络管理==========

--SCAN监听器
cluvfy comp scan -verbose
srvctl config scan_listener
srvctl status scan_listener
crsctl status resource ora.scan1.vip -p

srvctl stop scan_listener
srvctl status scan_listener
ps -ef |grep -i scan
srvctl start scan_listener

--
ifconfig -a |grep inet
ps -ef |grep -i scan
srvctl relocate scan -i 1 -n rac2


SCAN VIP
192.168.0.61---》 192.168.0.71
192.168.0.62---》 192.168.0.72
192.168.0.63---》 192.168.0.73
VIP
192.168.0.55---》 192.168.0.74
192.168.0.56---》 192.168.0.75

srvctl stop service -d tar
ifconfig -a |grep inet
srvctl stop scan_listener
srvctl stop scan
停止节点普通的监听器和普通vip
srvctl stop listener -n rac1
srvctl stop listener -n rac2
srvctl stop vip -n rac1
srvctl stop vip -n rac2
ifconfig -a |grep inet

 

nslookup myscan
srvctl config scan
srvctl config vip -n rac1

DNS服务器
cat /etc/named.conf
修改正向和反向解析文件
cp /var/named/192.168.0.db /var/named/192.168.0.dbBK
cp /var/named/taryartar.com.db /var/named/taryartar.com.dbBK


sed -i 's/61/71/' /var/named/taryartar.com.db
sed -i 's/62/72/' /var/named/taryartar.com.db
sed -i 's/63/73/' /var/named/taryartar.com.db
sed -i 's/55/74/' /var/named/taryartar.com.db
sed -i 's/56/75/' /var/named/taryartar.com.db

sed -i 's/61/71/' /var/named/192.168.0.db
sed -i 's/62/72/' /var/named/192.168.0.db
sed -i 's/63/73/' /var/named/192.168.0.db
sed -i 's/55/74/' /var/named/192.168.0.db
sed -i 's/56/75/' /var/named/192.168.0.db

cat /var/named/taryartar.com.db
cat /var/named/192.168.0.db

cp /var/named/192.168.0.dbBK /var/named/192.168.0.db
cp /var/named/taryartar.com.dbBK /var/named/taryartar.com.db

nslookup myscan
service named reload
nslookup myscan

srvctl config scan
srvctl modify scan -n myscan
srvctl config scan

srvctl config vip -n rac1
srvctl modify nodeapps -n rac1 -A 192.168.0.74/255.255.255.0/bond0
srvctl modify nodeapps -n rac2 -A 192.168.0.75/255.255.255.0/bond0
srvctl config vip -n rac1

srvctl start vip -n rac1
srvctl start listener -n rac1
lsnrctl status

srvctl start scan
srvctl start scan_listener

cluvfy comp nodecon -n all -verbose

==SCAN 端口号的修改=========
srvctl config scan_listener
srvctl modify scan_listener -p 1528
srvctl stop scan_listener
srvctl start scan_listener
ps -ef |grep -i scan
lsnrctl status LISTENER_SCAN1
alter system set remote_listener ='myscan:1528' scope=both;
lsnrctl status LISTENER_SCAN3

======私有IP的修改=========
oifcfg getif
oifcfg iflist
crsctl stop crs
ifconfig -a |grep -C1 eth2
10.0.10.1
crsctl stop crs
vi /etc/sysconfig/network-scripts/ifcfg-eth2
service network restart
oifcfg setif -global eth2/10.0.0.0:cluster_interconnect

ps -ef |grep ora |awk '{print $2}' |xargs kill -9
ps -ef |grep grid |awk '{print $2}' |xargs kill -9
ps -ef |grep asm |awk '{print $2}' |xargs kill -9
ps -ef |grep storage |awk '{print $2}' |xargs kill -9
ps -ef |grep ohasd |awk '{print $2}' |xargs kill -9

crsctl start crs

 


--------------------------------------------
--------
--------本文件只是为了方便大家进行命令拷贝
--------使用时请进行相应的替换和修改
--------
--------------------------------------------

=============数据库管理==============

srvctl start instance -d tar -n rac2
srvctl status database -d tar -f -v
srvctl stop database -d tar

show parameter spfile;
show parameter parallel_max_servers;

create spfile='+DG_ZERO/zerodb/spfilezerodb.ora' from pfile='/zerodb/11g/db_base/db_home/dbs/initzero.ora'


*.parallel_max_servers =40
tar2.parallel_max_servers=42

show parameter parallel_max_servers;
alter system set parallel_max_servers=42 sid='*' scope=both;
alter system set parallel_max_servers=42 scope=both;
alter system set parallel_max_servers=42 sid='tar2' scope=both;
show parameter parallel_max_servers;


create user c##test identified by Xtyt2008;
grant dba to c##test;

select inst_id, sid, serial#,USERNAME from gv$session;
alter system kill session '85, 90,@2';

column name format a20;
column value format a20;
select inst_id,name,value from gv$parameter where name like '%undo_tablespace%';

CREATE UNDO TABLESPACE UNDOTBS_TYT
DATAFILE '+DATA/TAR/DATAFILE/TYT.db' SIZE 900M AUTOEXTEND ON;


alter system set UNDO_TABLESPACE=UNDOTBS_TYT sid='tar2' scope=both;

select inst_id,name,value from gv$parameter where name like '%undo_tablespace%';

 

select GROUP#,thread# from v$log;

column MEMBER format a50;
select group#,status,member from v$logfile order by GROUP#;

不要使用gv$log，gv$logfile，其列出的信息是冗余的，容易误导
select thread#,group# from gv$log;
select INST_ID,group#,member from gv$logfile;

ALTER DATABASE
ADD LOGFILE INSTANCE 'tar1'
GROUP 6
('+DATA/TAR/ONLINELOG/redo_z111','+DATA/TAR/ONLINELOG/redo_z222') SIZE 50M reuse;


ALTER DATABASE DROP LOGFILE GROUP 5;


====负载均衡测试
srvctl config scan_listener
lsnrctl status


配置tnsnames.ora
tyt_normal=
(DESCRIPTION =
(FAILOVER = ON)
(LOAD_BALANCE = ON)
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.74)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.75)(PORT=1521))
(CONNECT_DATA =
(SERVICE_NAME = tar)
)
)


sqlplus system/Xtyt2008@tyt_fo

tyt_scan=
(DESCRIPTION =
(ADDRESS=(PROTOCOL=tcp)(HOST=myscan)(PORT=1528))
(CONNECT_DATA =
(SERVICE_NAME = tar)
)
)

sqlplus system/Xtyt2008@tyt_normal

SELECT INSTANCE_NAME FROM V$INSTANCE;

====失败转移

MYFL =
(DESCRIPTION =
(FAILOVER = ON)
(LOAD_BALANCE = ON)
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.71)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.72)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.73)(PORT=1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl_ac)
)
)


sqlplus system/Xtyt2008@MYFL

create table t_failover
as
select owner,object_name,object_id from dba_objects;

insert into t_failover
select owner,object_name,object_id from dba_objects;


sqlplus system/Xtyt2008@MYFL

SELECT INSTANCE_NAME FROM V$INSTANCE;
SELECT HOST_NAME FROM V$INSTANCE;
--1.idle
select sysdate from dual;

--2.long query
alter system flush buffer_cache;

column OWNER format a50;
select owner,COUNT(*) from
(
select * from system.t_failover
where object_id in (select object_id from system.t_failover ) and object_name not in (select owner from system.t_failover )
UNION ALL
select * from system.t_failover
where object_id in (select object_id from system.t_failover )
UNION ALL
select * from system.t_failover
where owner in (select owner from system.t_failover )
)
group by owner;

--3.DML
insert into system.t_failover values('system','LOGMNR_88888',88888);
select object_name from system.t_failover where object_name='LOGMNR_88888';

--4.new session

查看是否发生会话漂移
select
username,
sid,
serial#,
failover_type,
failover_method,
failed_over
from
gv$session
where
username not in ('SYS','PERFSTAT')
and
failed_over = 'YES';

SELECT MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER, COUNT(*)
FROM GV$SESSION
GROUP BY MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER;

转载于:https://www.cnblogs.com/dbalightyear/p/11228355.html

weixin_30879169
关注
Oracle集群RAC磁盘管理命令asmcmd的使用
没刮胡子的程序员专栏
07-23 281
ASM（Automatic Storage Management）磁盘共享是Oracle数据库中一项重要的存储管理技术，旨在简化数据库管理员（DBA）对存储资源的管理，提高存储效率和数据可用性。以下是对ASM磁盘共享的详细简介：ASM是Oracle提供的一种智能化数据库文件存储管理解决方案，它采用Oracle Managed Files（OMF）文件格式来创建目录文件，能够在多个物理设备之间实现条带化、镜像数据文件、恢复文件等功能。
【Oracle】Oracle RAC集群体系结构完美解析
tttzzzqqq2018的博客
10-18 4819
Cluster Ready Services，简称 CRS，是 oracle 开发的一个集群软件，与其它集群软件类似，CRS 主要完成集群成员管理、心跳监控、故障切换等功能，CRS 要求每个集群节点的操作系统必须相同，这样，通过 CRS 将多个节点的操作系统绑定到了一起，客户端对集群的访问，就像访问一台服务器一样。CRS 主要有两个集群套件组成，分别是 voting disk 和 Oracle Cluster Registry。
oracle怎么看是否有集群,oracle 集群检查集群资源状态脚本
weixin_39820910的博客
04-03 494
#/bin/shsource /home/oracle/.bash_profilegridpath=`ps -ef|grep crsd.bin|grep -v grep|awk '{print $8}'`${gridpath%/*}/crsctl stat res -t |grep -v Resources |grep -v ^-- > res.log#head -n 6 r...
ORACLE 11g RAC 集群的管理与维护（4） —— crsctl 命令之（四） ：管理 Oracle Cluster
睿思达DBA
09-19 1181
ORACLE 11g RAC 集群的管理与维护（4） —— crsctl 命令之（四） ：管理 Oracle Cluster Crsctl start/stop crs 管理本地节点 Clusterware stack 的启停，包含启动 ohasd 进程，只能用来管理本地节点。crsctl strat/stop cluster 既可以管理本地 Clusterware stack，也可以管理整个集群。 一、crsctl check cluster 检查 Oracle Clusterware stack 的状
crsctl相关命令
weixin_39568073的博客
11-24 2225
crsctl -help crsctl query crs activeversion：显示本地节点上Oracle Clusterware软件的活动版本或二进制版本 Oracle Clusterware active version on the cluster is [12.1.0.2.0] 集群上的Oracle Clusterware活动版本是[12.1.0.2.0] crsctl que...
oracle 19c crsctl相关命令（一）
weixin_39568073的博客
06-28 3489
./crsctl query has releaseversion 显示存储在本地节点上的二进制文件中的Oracle Clusterware软件的发行版本 ./crsctl query has softwareversion 在本地节点上显示软件版本 HAS高可用性服务 High Availability Services ./crsctl config has 显示服务器上Oracle High Availability Services堆栈的自动启动配置。 已启用Oracle高可用性服务 ./c
oracle 12c 集群安装后的检查
kadwf123的专栏
11-02 1712
安装配置gi、安装数据库软件、dbca建库见下： http://blog.csdn.net/kadwf123/article/details/78429961 1、检查集群节点及状态： [root@rac2 ~]# olsnodes -s rac1 Active rac2 Active rac3 Active rac4 Active [root@rac2 ~]
Oracle集群数据库压力测试与分析.pdf
10-09
【Oracle集群数据库压力测试与分析】 Oracle Real Application Clusters (RAC) 是Oracle数据库系统提供的一种高可用性和可伸缩性的解决方案。RAC允许多个服务器同时访问同一个数据库，以实现负载均衡和故障切换功能...
ORACLE-11G-RAC--集群应用层命令扫盲.doc
10-29
本文将深入解析Oracle 11g RAC中的集群应用层命令，特别是用于维护和监控的关键工具。 1. **SRVCTL**： SRVCTL是Oracle Clusterware提供的一个命令行接口，用于管理和控制RAC环境中的服务、实例、节点、监听器等...
【云原生进阶之数据库技术】第二章-Oracle-原理-4.6.2-Oracle集群心跳机制
最新发布
junbaozi的专栏
06-07 86
Oracle集群如何维护集群的一致性，所谓的集群一致性就是指集群中每个成员能够了解其他成员的状态，而且每个成员获得的集群中其他节点的状态和集群中节点成员列表信息是一致的，这也是集群最基本的要求。
管理11g RAC之Cluster实验
db commando
06-20 597
实验内容如下： 检查集群状态： [grid@rac122 ~]$ crsctl check cluster -all ************************************************************** rac121: CRS-4537: Cluster Ready Services is online CRS-4529: Cluster S
11g RAC集群启动关闭、各种资源检查、配置信息查看汇总。
张冲andy的博客
12-25 5619
简要： 一：集群的启动与关闭 1.  rac集群的手动启动 [root@node1 bin]# ./crsctl start cluster -all 2.  查看rac集群的状态 [root@node1 bin]# ./crsctl  stat res -t 3.  rac集群的关闭 [root@node1 bin]# ./crscrl stop cluster -all
oracle_rac（Oracle集群）启动过程及状态检查记录
weixin_42821740的博客
01-13 1854
检查卷组的挂载状态lsvg -o 和lsvg 对比，应该是一致，如果不一致，应该是HACMP集群软件出问题。启动Oracle集群CRS，在目录/etc/oracle/scls_scr/wxwydb1/root。/etc/init.crs stop 可关闭集群进程Oracle CRS。如果网络不通或者crs进程异常会离线状态。看到ora_smon进程，说明数据库已经被集群CRS启动。在15节点，启动CRS（Oracle集群就绪服务。如果发现状态不正常或者缺少进程，就用命令。切换oracle用户查看集群状态，
Oracle 集群的自启动，OLR与套接字文件
Hehuyi_In的博客
10-24 2724
当Oracle集群安装部署完成后，默认会处于启动的状态，当服务器重启之后集群也会被自动启动，那么，Oracle集群是如何来实现自启动的呢？ 一、集群的自启动 1. 自启动脚本 Oracle 10G: cat/etc/inittab h1:35:respawn:/etc/init.d/init.evmdrun>/dev/null2>&1</dev/null h2:35:respawn:/etc/init.d/init.cssdfatal>/dev/n...
Oracle 11gr2 RAC安装笔记（四）安装Grid Infrastructure
白昼的技术专栏
10-26 4009
一、两节点检测ssh互通性的配置： 1、Grid用户互通配置： 节点1： su - grid cd /home/grid/ mkdir ~/.ssh chmod 700 ~/.ssh ssh-keygen -t rsa ssh-keygen -t dsa 切换到节点2重复以上操作！ 返回节点1，执行： cat ~/.ssh/id_rsa.pub &gt;&gt...
Q群友问题---tnsnames.ora中指定sid参数仍无法连接到指定的rac实例
11-29 205
Q群友问题 群主，请教个问题 ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = nbubackup1vip)(PORT = 1...
oracle12c命令行安装grid,oracle12c-RAC安装部署之GRID安装-grid设置
weixin_39624360的博客
04-04 1034
概述Grid Infrastructure是11gR2版本新出现的安装包，使用独立的grid用户进行安装。如果要使用Clusterware、ASM、ACFS、ASM动态卷等功能时都需要先安装此包。Grid Infrastructure封装了Clusterware集群软件和ASM存储软件，此外，对ASM的管理也同样独立出来，新建了ASMADMIN、ASMDBA和ASMOPER 3个系统组来完善对AS...
oracle rac _oifcfg iflist -p -n,11gr2 rac 基本管理命令（一）
weixin_42466868的博客
04-05 201
Oracle clusterware命令集层次命令节点层olsnodes网络层oifcfg集群层crsctl、orccheck、orcdump、ocrconfig应用层Srvctl、onsctl、crs_stat节点层表格详解olsnodes常用命令目标命令集群名称olsnodes -c节点编号olsnodes -n节点活动情况olsnodes -s本地节点名称olsnodes -ldebug模式...
[Oracle] oracle11g scan ip relocate
cizhiyou2391的博客
06-06 238
[root@xxxxxdb2 ~]# crsctl stat res -t -----------------------------------------------------------------------...
Windows平台Oracle RAC集群构建步骤
“Windows平台OracleRAC集群安装过程” 在Windows平台上安装Oracle Real Application Clusters (RAC)是一项复杂而细致的工作，涉及到多个步骤和组件的配置。RAC是一种高可用性的数据库解决方案，允许多台服务器共享...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值