启动ASM实例失败ORA-29701
点击(此处)折叠或打开
-
[grid@songasm Desktop]$ sqlplus / as sysasm
-
-
SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 6 17:10:21 2016
-
-
Copyright (c) 1982, 2013, 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> !crsctl check css
-
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
-
-
SQL> !ps -ef | grep cssd | grep -v grep
-
-
SQL> !crsctl check has
-
CRS-4638: Oracle High Availability Services is online
-
-
SQL> !ps -ef | grep d.bin | grep -v grep
-
grid 2385 1 0 16:21 ? 00:00:20 /u01/app/grid/product/11.2.0/gihome_1/bin/ohasd.bin reboot
-
grid 2672 1 0 16:22 ? 00:00:00 /u01/app/grid/product/11.2.0/gihome_1/bin/evmd.bin
-
-
SQL> !crsctl status resource -t
-
--------------------------------------------------------------------------------
-
NAME TARGET STATE SERVER STATE_DETAILS
-
--------------------------------------------------------------------------------
-
Local Resources
-
--------------------------------------------------------------------------------
-
ora.DATAGROUP.dg
-
OFFLINE OFFLINE songasm
-
ora.GRIDGROUP.dg
-
OFFLINE OFFLINE songasm
-
ora.LISTENER.lsnr
-
ONLINE ONLINE songasm
-
ora.asm
-
OFFLINE OFFLINE songasm Instance Shutdown
-
ora.ons
-
OFFLINE OFFLINE songasm
-
--------------------------------------------------------------------------------
-
Cluster Resources
-
--------------------------------------------------------------------------------
-
ora.cssd
-
1 ONLINE OFFLINE
-
ora.diskmon
-
1 OFFLINE OFFLINE
-
ora.evmd
-
1 ONLINE ONLINE songasm
-
-
SQL> !crs_stat -p ora.cssd | grep AUTO
-
AUTO_START=never
-
-
SQL> !crs_stat -p ora.diskmon | grep AUTO
-
AUTO_START=never
-
-
SQL> !crsctl start resource ora.cssd
-
CRS-2672: Attempting to start 'ora.cssd' on 'songasm'
-
CRS-2672: Attempting to start 'ora.diskmon' on 'songasm'
-
CRS-2676: Start of 'ora.diskmon' on 'songasm' succeeded
-
CRS-2676: Start of 'ora.cssd' on 'songasm' succeeded
-
-
SQL> !crs_stat -t
-
Name Type Target State Host
-
------------------------------------------------------------
-
ora....ROUP.dg ora....up.type OFFLINE OFFLINE
-
ora....ROUP.dg ora....up.type OFFLINE OFFLINE
-
ora....ER.lsnr ora....er.type ONLINE ONLINE songasm
-
ora.asm ora.asm.type OFFLINE OFFLINE
-
ora.cssd ora.cssd.type ONLINE ONLINE songasm
-
ora.diskmon ora....on.type OFFLINE OFFLINE
-
ora.evmd ora.evm.type ONLINE ONLINE songasm
-
ora.ons ora.ons.type OFFLINE OFFLINE
-
-
SQL> startup
-
ASM instance started
-
-
Total System Global Area 1135747072 bytes
-
Fixed Size 2260728 bytes
-
Variable Size 1108320520 bytes
-
ASM Cache 25165824 bytes
-
ASM diskgroups mounted
-
SQL> !crs_stat -t
-
Name Type Target State Host
-
------------------------------------------------------------
-
ora....ROUP.dg ora....up.type ONLINE ONLINE songasm
-
ora....ROUP.dg ora....up.type ONLINE ONLINE songasm
-
ora....ER.lsnr ora....er.type ONLINE ONLINE songasm
-
ora.asm ora.asm.type ONLINE ONLINE songasm
-
ora.cssd ora.cssd.type ONLINE ONLINE songasm
-
ora.diskmon ora....on.type OFFLINE OFFLINE
-
ora.evmd ora.evm.type ONLINE ONLINE songasm
-
ora.ons ora.ons.type OFFLINE OFFLINE
-
- SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26066458/viewspace-2124599/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
at
请登录后发表评论
登录
全部评论
