今天实验环境遇到一个奇怪的问题,之前启动机器的时候,ASM实例和数据库实例都是自动自动,今天没有自动启动(可能跟我上次关机之前关闭了数据库实例和ASM实例有关)。
在今天启动完服务器后,发现ASM实例和数据库实例没有启动。
于是启动ASM实例
上面提示说无法连接到
css 服务。
step1:看看css服务是否启动
果然没有CSS的服务daemon进程。
step2:看一下HAS(High Availability Service)的状态
step3:在来看看相关的资源的情况
step4:
再看一下ora.cssd和ora.diskmon的属性
上面两个资源的 AUTO_START 属性设置为了never, 所以不会随has自动启动。需要手动先启动起来
step5:手动启动 ora . cssd
step6:在来看看相关资源的情况
可以看到, ora.cssd已经启动, 但是ora.diskmon没有启动,通过查相关的文档,发现
原来在11.2.0.3版本的非Exadata数据库上,diskmon的服务是被disable掉的 , 由于在之前的版本中ora.diskmon和ora.cssd服务是互相依赖的,及这两个服务中随便停止那个两个都会停止,同样的随便启动那个两个都会启动
step7:启动ASM实例
stp8:ASM实例启动后,再看看资源情况
step9:启动数据实例并查看资源情况
补充知识:
参照文档:
http://blog.csdn.net/rgb_rgb/article/details/7937928
http://blog.sina.com.cn/s/blog_70a2bdb80100xdth.html
在今天启动完服务器后,发现ASM实例和数据库实例没有启动。
- [oracle@LINUX10 ~]$ ps -ef|grep ASM
- oracle 2299 2096 0 22:17 pts/0 00:00:00 grep ASM
- [oracle@LINUX10 ~]$ echo $ORACLE_SID
- +ASM
- [oracle@LINUX10 ~]$ sqlplus / as sysasm
-
- SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 22:17:46 2015
-
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
-
- Connected to an idle instance.
-
- SQL> startup
- ORA-01078: failure in processing system parameters
- ORA-29701: unable to connect to Cluster Synchronization Service
- SQL> exit
step1:看看css服务是否启动
- [oracle@LINUX10 ~]$ crsctl check css
- CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
step2:看一下HAS(High Availability Service)的状态
- [oracle@LINUX10 ~]$ crsctl check has
- CRS-4638: Oracle High Availability Services is online
- [oracle@LINUX10 ~]$ crs_stat -t
- Name Type Target State Host
- ------------------------------------------------------------
- ora.DATA.dg ora....up.type OFFLINE OFFLINE
- ora.DGROUPA.dg ora....up.type OFFLINE OFFLINE
- ora....ER.lsnr ora....er.type ONLINE ONLINE linux10
- ora.asm ora.asm.type OFFLINE OFFLINE
- ora.cssd ora.cssd.type ONLINE OFFLINE
- ora.diskmon ora....on.type OFFLINE OFFLINE
- ora.evmd ora.evm.type ONLINE ONLINE linux10
- ora.ons ora.ons.type OFFLINE OFFLINE
- ora.orcl.db ora....se.type OFFLINE OFFLINE
- [oracle@LINUX10 ~]$ crsctl status resource -t
- --------------------------------------------------------------------------------
- NAME TARGET STATE SERVER STATE_DETAILS
- --------------------------------------------------------------------------------
- Local Resources
- --------------------------------------------------------------------------------
- ora.DATA.dg
- OFFLINE OFFLINE linux10
- ora.DGROUPA.dg
- OFFLINE OFFLINE linux10
- ora.LISTENER.lsnr
- ONLINE ONLINE linux10
- ora.asm
- OFFLINE OFFLINE linux10 Instance Shutdown
- ora.ons
- OFFLINE OFFLINE linux10
- --------------------------------------------------------------------------------
- Cluster Resources
- --------------------------------------------------------------------------------
- ora.cssd
- 1 ONLINE OFFLINE
- ora.diskmon
- 1 OFFLINE OFFLINE
- ora.evmd
- 1 ONLINE ONLINE linux10
- ora.orcl.db
- 1 OFFLINE OFFLINE Instance Shutdown
- [oracle@LINUX10 ~]$ crs_stat -p ora.cssd
- NAME=ora.cssd
- TYPE=ora.cssd.type
- ACTION_SCRIPT=
- ACTIVE_PLACEMENT=0
- AUTO_START=never
- CHECK_INTERVAL=30
- DESCRIPTION="Resource type for CSSD"
- FAILOVER_DELAY=0
- FAILURE_INTERVAL=3
- FAILURE_THRESHOLD=5
- HOSTING_MEMBERS=
- PLACEMENT=balanced
- RESTART_ATTEMPTS=5
- SCRIPT_TIMEOUT=600
- START_TIMEOUT=600
- STOP_TIMEOUT=900
- UPTIME_THRESHOLD=1m
- [oracle@LINUX10 ~]$ crs_stat -p ora.diskmon
- NAME=ora.diskmon
- TYPE=ora.diskmon.type
- ACTION_SCRIPT=
- ACTIVE_PLACEMENT=0
- AUTO_START=never
- CHECK_INTERVAL=3
- DESCRIPTION="Resource type for Diskmon"
- FAILOVER_DELAY=0
- FAILURE_INTERVAL=3
- FAILURE_THRESHOLD=5
- HOSTING_MEMBERS=
- PLACEMENT=balanced
- RESTART_ATTEMPTS=10
- SCRIPT_TIMEOUT=60
- START_TIMEOUT=600
- STOP_TIMEOUT=60
- UPTIME_THRESHOLD=5s
step5:手动启动 ora . cssd
- [oracle@LINUX10 ~]$ crsctl start resource ora.cssd
- CRS-2672: Attempting to start 'ora.cssd' on 'linux10'
- CRS-2672: Attempting to start 'ora.diskmon' on 'linux10'
- CRS-2676: Start of 'ora.diskmon' on 'linux10' succeeded
- CRS-2676: Start of 'ora.cssd' on 'linux10' succeeded
- [oracle@LINUX10 ~]$ crs_stat -t
- Name Type Target State Host
- ------------------------------------------------------------
- ora.DATA.dg ora....up.type OFFLINE OFFLINE
- ora.DGROUPA.dg ora....up.type OFFLINE OFFLINE
- ora....ER.lsnr ora....er.type ONLINE ONLINE linux10
- ora.asm ora.asm.type OFFLINE OFFLINE
- ora.cssd ora.cssd.type ONLINE ONLINE linux10
- ora.diskmon ora....on.type OFFLINE OFFLINE
- ora.evmd ora.evm.type ONLINE ONLINE linux10
- ora.ons ora.ons.type OFFLINE OFFLINE
- ora.orcl.db ora....se.type OFFLINE OFFLINE
原来在11.2.0.3版本的非Exadata数据库上,diskmon的服务是被disable掉的 , 由于在之前的版本中ora.diskmon和ora.cssd服务是互相依赖的,及这两个服务中随便停止那个两个都会停止,同样的随便启动那个两个都会启动
step7:启动ASM实例
- [oracle@LINUX10 ~]$ sqlplus / as sysasm
-
- SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 22:29:51 2015
-
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
-
- Connected to an idle instance.
-
- SQL>
- SQL>
- SQL> startup
- ASM instance started
-
- Total System Global Area 283930624 bytes
- Fixed Size 2227664 bytes
- Variable Size 256537136 bytes
- ASM Cache 25165824 bytes
- ASM diskgroups mounted
- SQL> exit
stp8:ASM实例启动后,再看看资源情况
- [oracle@LINUX10 ~]$ crs_stat -t
- Name Type Target State Host
- ------------------------------------------------------------
- ora.DATA.dg ora....up.type ONLINE ONLINE linux10
- ora.DGROUPA.dg ora....up.type ONLINE ONLINE linux10
- ora....ER.lsnr ora....er.type ONLINE ONLINE linux10
- ora.asm ora.asm.type ONLINE ONLINE linux10
- ora.cssd ora.cssd.type ONLINE ONLINE linux10
- ora.diskmon ora....on.type OFFLINE OFFLINE
- ora.evmd ora.evm.type ONLINE ONLINE linux10
- ora.ons ora.ons.type OFFLINE OFFLINE
- ora.orcl.db ora....se.type OFFLINE OFFLINE
step9:启动数据实例并查看资源情况
- [oracle@LINUX10 ~]$ echo $ORACLE_SID
- orcl
- [oracle@LINUX10 ~]$ sqlplus / as sysdba
-
- SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 13 23:21:24 2015
-
- Copyright (c) 1982, 2011, Oracle. All rights reserved.
-
- Connected to an idle instance.
-
- SQL>
- SQL>
- SQL> startup
- ORACLE instance started.
-
- Total System Global Area 839282688 bytes
- Fixed Size 2233000 bytes
- Variable Size 524291416 bytes
- Database Buffers 310378496 bytes
- Redo Buffers 2379776 bytes
- Database mounted.
- Database opened.
- SQL>
- [oracle@LINUX10 ~]$ crs_stat -t
- Name Type Target State Host
- ------------------------------------------------------------
- ora.DATA.dg ora....up.type ONLINE ONLINE linux10
- ora.DGROUPA.dg ora....up.type ONLINE ONLINE linux10
- ora....ER.lsnr ora....er.type ONLINE ONLINE linux10
- ora.asm ora.asm.type ONLINE ONLINE linux10
- ora.cssd ora.cssd.type ONLINE ONLINE linux10
- ora.diskmon ora....on.type OFFLINE OFFLINE
- ora.evmd ora.evm.type ONLINE ONLINE linux10
- ora.ons ora.ons.type OFFLINE OFFLINE
- ora.orcl.db ora....se.type ONLINE ONLINE linux10
补充知识:
- 1)默认情况下HAS(High Availability Service)是自动启动的.通过如下命令可以取消和启用自动启动
- crsctl disable has
- crsctl enable has
- 2)HAS手动启动和停止
- crsctl start has
- crsctl stop has
- 3)查看HAS的状态
- crsctl check has
- 4)如果想让ora.css和ora.diskmon服务随着HAS的启动而自动启动,那么你可以这两个服务的AUTO_START属性
- crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
- or
- crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
- 5)如果想取消ora.css和ora.diskmon的Auto start
- crsctl modify resource "ora.cssd" -attr "AUTO_START=never"
- crsctl modify resource "ora.diskmon" -attr "AUTO_START=never"
参照文档:
http://blog.csdn.net/rgb_rgb/article/details/7937928
http://blog.sina.com.cn/s/blog_70a2bdb80100xdth.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30150152/viewspace-1572902/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30150152/viewspace-1572902/