由于很久没有开过自己虚拟机里的集群库了,中间有少许的一两次开过,做了少量的操作,但是具体是什么操作就忘记了。
本想着是给自己的测试集群库添加一两个服务的,还以为打开两个节点的主机,会把两个节点的实例会拉起来的,但是没想到
在登录实例进入数据库的时候,出现了以下的状况:实例没有开启,再看看另外的节点的实例也没有起来。想着自己之前没有
对集群做过什么操作啊,为什么没有起来呢?然后看了集群的所有资源,发现两个实例确实没有起来,都是offline状态。再看了看
集群的后台进程是否正常,OCR是否正常,表决磁盘是否正常,后面发现这些都正常,为什么两个节点没有被拉起来呢?最后去看了
CRS日志,发现是实例没有开启自动启动模式。想了想,自己也没有去disable过这两个实例啊,怎么会出现这种情况呢。后面尽管
手动去分别启动两个实例,但是不会被注册到CRS的资源里面,则是实例是open状态,在CRS呈现的是offline状态。不管如何,
为了先完成加服务的测试,我把两个实例重新enable了,然后重启了集群所有的资源,过程如下,重启资源后,两个实例都被拉起来了。
果真是这个原因。
----进入实例:
[oracle@node1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 5 08:52:49 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> quit
----查看集群中实例的运行状态:
[oracle@node1 ~]$ srvctl status instance -d prod -i prod1
Instance prod1 is not running on node node1
----查看集群中的所有资源的状态:
[grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.RCY.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.eons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 OFFLINE OFFLINE
ora.prod.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE node1
----查看集群后台进程的状态:
[grid@node1 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
----检查OCR的状态:
[grid@node1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2720
Available space (kbytes) : 259400
ID : 861205906
Device/File Name : +OCR_VOTE
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
[grid@node1 ~]$
----查看表决磁盘的状态:
[grid@node1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 4dead57abcce4f0abf2c1fb8c683c4ec (ORCL:OCR_VOTE1) [OCR_VOTE]
2. ONLINE 8080217425f44f38bf29af1d8e51ef08 (ORCL:OCR_VOTE2) [OCR_VOTE]
3. ONLINE 63665595cb424fcebfa33920db2d72d5 (ORCL:OCR_VOTE3) [OCR_VOTE]
Located 3 voting disk(s).
----关闭两个节点所有资源:
[grid@node1 ~]$ crs_stop -all
CRS-2500: Cannot stop resource 'ora.gsd' as it is not running
CRS-2500: Cannot stop resource 'ora.oc4j' as it is not running
CRS-2500: Cannot stop resource 'ora.prod.db' as it is not running
Attempting to stop `ora.LISTENER.lsnr` on member `node1`
Attempting to stop `ora.LISTENER.lsnr` on member `node2`
CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'node1'
Attempting to stop `ora.eons` on member `node2`
CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'node2'
Attempting to stop `ora.DATA.dg` on member `node2`
Attempting to stop `ora.OCR_VOTE.dg` on member `node2`
Attempting to stop `ora.RCY.dg` on member `node2`
Attempting to stop `ora.registry.acfs` on member `node2`
Attempting to stop `ora.eons` on member `node1`
Attempting to stop `ora.DATA.dg` on member `node1`
Attempting to stop `ora.OCR_VOTE.dg` on member `node1`
Attempting to stop `ora.RCY.dg` on member `node1`
Attempting to stop `ora.registry.acfs` on member `node1`
Stop of `ora.LISTENER.lsnr` on member `node2` succeeded.
Attempting to stop `ora.ons` on member `node2`
Attempting to stop `ora.node2.vip` on member `node2`
Stop of `ora.node2.vip` on member `node2` succeeded.
Stop of `ora.LISTENER.lsnr` on member `node1` succeeded.
Attempting to stop `ora.ons` on member `node1`
Attempting to stop `ora.node1.vip` on member `node1`
Attempting to stop `ora.LISTENER_SCAN1.lsnr` on member `node1`
Stop of `ora.node1.vip` on member `node1` succeeded.
Stop of `ora.registry.acfs` on member `node2` succeeded.
Stop of `ora.ons` on member `node2` succeeded.
CRS-2789: Cannot stop resource 'ora.ons' as it is not running on server 'node2'
Attempting to stop `ora.net1.network` on member `node2`
Stop of `ora.net1.network` on member `node2` succeeded.
Stop of `ora.registry.acfs` on member `node1` succeeded.
Stop of `ora.LISTENER_SCAN1.lsnr` on member `node1` succeeded.
Attempting to stop `ora.scan1.vip` on member `node1`
Stop of `ora.scan1.vip` on member `node1` succeeded.
Stop of `ora.ons` on member `node1` succeeded.
CRS-2789: Cannot stop resource 'ora.ons' as it is not running on server 'node1'
Attempting to stop `ora.net1.network` on member `node1`
Stop of `ora.net1.network` on member `node1` succeeded.
Stop of `ora.eons` on member `node2` succeeded.
Stop of `ora.eons` on member `node1` succeeded.
Stop of `ora.OCR_VOTE.dg` on member `node2` succeeded.
Stop of `ora.RCY.dg` on member `node2` succeeded.
Stop of `ora.OCR_VOTE.dg` on member `node1` succeeded.
Stop of `ora.RCY.dg` on member `node1` succeeded.
Stop of `ora.DATA.dg` on member `node2` succeeded.
Attempting to stop `ora.asm` on member `node2`
Stop of `ora.DATA.dg` on member `node1` succeeded.
Attempting to stop `ora.asm` on member `node1`
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
ORA-15097: cannot SHUTDOWN ASM instance with connected client
CRS-2675: Stop of 'ora.asm' on 'node2' failed
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
ORA-15097: cannot SHUTDOWN ASM instance with connected client
CRS-2675: Stop of 'ora.asm' on 'node1' failed
CRS-0216: Could not stop resource 'ora.asm node1 1'.
CRS-0216: Could not stop resource 'ora.asm node2 1'.
CRS-0216: Could not stop resource 'ora.gsd'.
CRS-0216: Could not stop resource 'ora.gsd node1 1'.
CRS-0216: Could not stop resource 'ora.gsd node2 1'.
CRS-0216: Could not stop resource 'ora.oc4j'.
CRS-0216: Could not stop resource 'ora.ons node1 1'.
CRS-0216: Could not stop resource 'ora.ons node2 1'.
CRS-0216: Could not stop resource 'ora.prod.db'.
#资源停止完毕。
----关闭后查看集群所有的资源:
[grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.LISTENER.lsnr
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.OCR_VOTE.dg
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.RCY.dg
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.asm
OFFLINE ONLINE node1 Started
OFFLINE ONLINE node2 Started
ora.eons
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.ons
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.registry.acfs
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE
ora.node1.vip
1 OFFLINE OFFLINE
ora.node2.vip
1 OFFLINE OFFLINE
ora.oc4j
1 OFFLINE OFFLINE
ora.prod.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.scan1.vip
1 OFFLINE OFFLINE
[grid@node1 ~]$
----开启实例自动启动模式:
[oracle@node1 ~]$ srvctl enable instance -d prod -i prod1
----重启所有的资源:
[grid@node1 ~]$ crs_start -all
CRS-2501: Resource 'ora.gsd' is disabled
CRS-2501: Resource 'ora.gsd' is disabled
CRS-2501: Resource 'ora.gsd' is disabled
CRS-2501: Resource 'ora.oc4j' is disabled
Attempting to start `ora.RCY.dg` on member `node2`
Attempting to start `ora.RCY.dg` on member `node1`
CRS-2664: Resource 'ora.asm' is already running on 'node2'
CRS-2664: Resource 'ora.asm' is already running on 'node1'
Attempting to start `ora.eons` on member `node1`
Attempting to start `ora.eons` on member `node2`
Attempting to start `ora.DATA.dg` on member `node2`
Attempting to start `ora.net1.network` on member `node2`
Attempting to start `ora.OCR_VOTE.dg` on member `node2`
Attempting to start `ora.net1.network` on member `node1`
Attempting to start `ora.registry.acfs` on member `node2`
Attempting to start `ora.registry.acfs` on member `node1`
Start of `ora.OCR_VOTE.dg` on member `node2` succeeded.
Start of `ora.net1.network` on member `node1` succeeded.
Attempting to start `ora.node2.vip` on member `node1`
Attempting to start `ora.scan1.vip` on member `node1`
Start of `ora.net1.network` on member `node2` succeeded.
Start of `ora.registry.acfs` on member `node1` succeeded.
Start of `ora.registry.acfs` on member `node2` succeeded.
Start of `ora.node2.vip` on member `node1` succeeded.
Start of `ora.scan1.vip` on member `node1` succeeded.
Attempting to start `ora.LISTENER_SCAN1.lsnr` on member `node1`
Start of `ora.eons` on member `node2` succeeded.
Start of `ora.eons` on member `node1` succeeded.
Attempting to stop `ora.node2.vip` on member `node1`
Attempting to stop `ora.scan1.vip` on member `node1`
Attempting to start `ora.ons` on member `node2`
Stop of `ora.node2.vip` on member `node1` succeeded.
Attempting to start `ora.node2.vip` on member `node2`
Stop of `ora.scan1.vip` on member `node1` succeeded.
Attempting to start `ora.scan1.vip` on member `node2`
Start of `ora.LISTENER_SCAN1.lsnr` on member `node1` succeeded.
Attempting to start `ora.ons` on member `node1`
Start of `ora.ons` on member `node2` succeeded.
CRS-5702: Resource 'ora.ons' is already running on 'node2'
Start of `ora.ons` on member `node1` succeeded.
CRS-5702: Resource 'ora.ons' is already running on 'node1'
Start of `ora.scan1.vip` on member `node2` succeeded.
Start of `ora.node2.vip` on member `node2` succeeded.
Attempting to stop `ora.LISTENER_SCAN1.lsnr` on member `node1`
Start of `ora.RCY.dg` on member `node1` succeeded.
Start of `ora.DATA.dg` on member `node2` succeeded.
Attempting to start `ora.LISTENER.lsnr` on member `node2`
Stop of `ora.LISTENER_SCAN1.lsnr` on member `node1` succeeded.
Attempting to start `ora.LISTENER_SCAN1.lsnr` on member `node2`
Start of `ora.RCY.dg` on member `node2` succeeded.
Start of `ora.LISTENER.lsnr` on member `node2` succeeded.
CRS-5702: Resource 'ora.LISTENER.lsnr' is already running on 'node2'
Start of `ora.LISTENER_SCAN1.lsnr` on member `node2` succeeded.
Attempting to start `ora.DATA.dg` on member `node1`
Attempting to start `ora.node1.vip` on member `node1`
Attempting to start `ora.OCR_VOTE.dg` on member `node1`
Start of `ora.OCR_VOTE.dg` on member `node1` succeeded.
Attempting to start `ora.prod.db` on member `node2`
Start of `ora.DATA.dg` on member `node1` succeeded.
Start of `ora.node1.vip` on member `node1` succeeded.
Attempting to start `ora.LISTENER.lsnr` on member `node1`
Start of `ora.LISTENER.lsnr` on member `node1` succeeded.
Attempting to start `ora.prod.db` on member `node1`
Start of `ora.prod.db` on member `node2` succeeded.
Start of `ora.prod.db` on member `node1` succeeded.
CRS-0223: Resource 'ora.LISTENER.lsnr node2 1' has placement error.
CRS-0223: Resource 'ora.asm node1 1' has placement error.
CRS-0223: Resource 'ora.asm node2 1' has placement error.
CRS-2660: Resource 'ora.gsd' or all of its instances are disabled
CRS-2660: Resource 'ora.node1.gsd' or all of its instances are disabled
CRS-2660: Resource 'ora.node2.gsd' or all of its instances are disabled
CRS-2660: Resource 'ora.oc4j' or all of its instances are disabled
CRS-0223: Resource 'ora.ons node1 1' has placement error.
CRS-0223: Resource 'ora.ons node2 1' has placement error.
[grid@node1 ~]$
#资源重启完毕。
----再次查看集群所有资源的状态:
[grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.RCY.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.eons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 OFFLINE OFFLINE
ora.prod.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
ora.scan1.vip
1 ONLINE ONLINE node2
[grid@node1 ~]$
----查看实例的状态:
[oracle@node1 ~]$ srvctl enable instance -d prod -i prod1
PRCC-1011 : prod was already enabled on node1
#查看节点2的实例,也被拉起来了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31392094/viewspace-2134735/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31392094/viewspace-2134735/