–asm 自动挂载
alter system asm_diskgroups=‘ORADATA,ORAFLASH,ORAIMAGE1,ORAIMAGE2,ORAIMAGE,VOT01’ scope=spfile;
alter system set asm_diskstring=’/dev/oracleasm/disks/*’ scope=spfile;
- 检查节点集群资源状态(grid用户):crs_stat -t
或者crsctl stat res -t
停止顺序:数据库–》ASM–》节点服务–》集群软件==================
1.停止监听(oracle执行):
srvctl stop listener -n node1
srvctl stop listener -n node2
srvctl status listener -n node1
srvctl start listener -n node1
srvctl start listener -n node2
-------不执行
srvctl stop vip -n node1
srvctl stop vip -n node2
-------不执行
srvctl stop scan_listener -n node1
srvctl stop scan_listener -n node2
grid 用户
srvctl stop listener
- 停止em(oracle执行):
emctl stop dbconsole
3.停止实例(oracle执行):
srvctl stop instance -d orcl -i orcl1
srvctl stop instance -d orcl -i orcl2
or
srvctl stop instance -d orcl -n node1
srvctl stop instance -d orcl -n node2
or
srvctl stop database -d orcl
-
停止asm(grid执行):
srvctl stop asm -n node1
srvctl stop asm -n node2 -
停止nodeapp(oracle执行):
srvctl stop nodeapps -n node1
srvctl stop nodeapps -n node2
6.root用户停止集群软件
/etc/init.d/init.crs stop
OR
[root@node1 ~]# cd /home/g01/app/11.2.0.4/grid/bin/
[root@node1 bin]# ./crsctl stop crs
(crsctl stop has -f )
==========================启动顺序:节点服务–》ASM–> 数据库实例—》集群软件--------------------------------------------------
1.
启动nodeapps:
srvctl start nodeapps -n node1
srvctl start nodeapps -n node2
启动asm:
srvctl start asm -n node1
srvctl start asm -n node2
- 启动数据库实例
srvctl start database -d orcl
or
srvctl start instance -d orcl -i orcl1
srvctl start instance -d orcl -i orcl2
or
srvctl start instance -d orcl -n node1
srvctl start instance -d orcl -n node2
6.root用户启动集群软件
/etc/init.d/init.crs start
or
cd /home/g01/app/11.2.0.4/grid/bin/
crsctl start crs
(crsctl start has )
4.
启动监听:
srvctl start listener -n node1
srvctl start listener -n node2
启动vip
srvctl start vip -n node1
srvctl start vip -n node2
启动scan_listener:
srvctl start scan_listener -n node1
srvctl start scan_listener -n node2
----监听intermediate状态,处理
srvctl stop listener -n node2
srvctl stop scan_listene
ps -eaf|grep tns ##kill -9 掉进程
然后
srvctl start listener -n node2
srvctl start scan_listener -n node2
–检查
a) 检查crs资源状态:crsctl check crs
b) 检查集群资源情况:crsctl stat res -t
------单实例
lsnrctl stop ;
alter system switch logfile;
alter system switch logfile;
alter system checkpoint;
1.1
SQL> shutdown immediate
startup mount
create pfile=’/home/oracle/initorcl0326.ora’ from spfile;
alter database open;