|
 |
CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
+ASM1 CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
+ASM2 CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
|
Grid 1$ CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
Grid 2$ CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
Oracle RAC ASM1 CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
Oracle RAC ASM2 CRS-0184: Cannot communicate with the CRS daemon-->解决方法 |
|
CRS-2672: Attempting to start 'ora.asm' on 'TTTTDB2'
CRS-2676: Start of 'ora.asm' on 'TTTTDB2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'TTTTDB2'
CRS-2676: Start of 'ora.crsd' on 'TTTTDB2' succeeded
|
|
CRS-4124: Oracle HighAvailability Services startup failed，数据恢复技术服务-->解决方法 |
|
|
Start of `ora.ttttdb.db` on member `TTTTDB1` failed.
Attempting to stop `ora.ttttdb.db` on member `TTTTDB1`
Start of `ora.oc4j` on member `TTTTDB2` succeeded.
Start of `ora.ttttdb.db` on member `TTTTDB2` succeeded.
Stop of `ora.ttttdb.db` on member `TTTTDB1` succeeded.
Attempting to stop `ora.LISTENER.lsnr` on member `TTTTDB1`
Stop of `ora.LISTENER.lsnr` on member `TTTTDB1` succeeded.
Attempting to stop `ora.TTTTDB1.vip` on member `TTTTDB1`
Stop of `ora.TTTTDB1.vip` on member `TTTTDB1` succeeded.
CRS-2632: There are no more servers to try to place resource 'ora.ttttdb.db' on that would satisfy its placement policy
CRS-0223: Resource 'ora.CRS.dg' has placement error.
CRS-0223: Resource 'ora.NDATA.dg' has placement error.
CRS-0223: Resource 'ora.NFRA.dg' has placement error.
CRS-0223: Resource 'ora.asm' has placement error.
CRS-2660: Resource 'ora.gsd' or all of its instances are disabled
CRS-0223: Resource 'ora.net1.network' has placement error.
CRS-0223: Resource 'ora.ons TTTTDB1 1' has placement error.
CRS-0223: Resource 'ora.ons TTTTDB2 1' has placement error.
CRS-0223: Resource 'ora.registry.acfs' has placement error.
CRS-0223: Resource 'ora.TTTTDB1.ASM1.asm' has placement error.
CRS-2660: Resource 'ora.TTTTDB1.gsd' or all of its instances are disabled
CRS-0223: Resource 'ora.TTTTDB2.ASM2.asm' has placement error.
CRS-2660: Resource 'ora.TTTTDB2.gsd' or all of its instances are disabled
CRS-0223: Resource 'ora.ttttdb.db 1 1' has placement error.
|
|
TTTTDB1:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora....ER.lsnr ora....er.type OFFLINE OFFLINE TTTTDB2
ora....N1.lsnr ora....er.type OFFLINE OFFLINE TTTTDB2
ora.DATA.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora.FRA1.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora.asm ora.asm.type OFFLINE OFFLINE TTTTDB1
ora.cvu ora.cvu.type OFFLINE OFFLINE TTTTDB2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora.....type OFFLINE OFFLINE TTTTDB1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE TTTTDB2
ora.ons ora.ons.type OFFLINE OFFLINE TTTTDB1
ora....ry.acfs ora....fs.type OFFLINE OFFLINE TTTTDB1
ora.scan1.vip ora....ip.type OFFLINE OFFLINE TTTTDB2
ora....SM1.asm application OFFLINE OFFLINE TTTTDB1
ora....B1.lsnr application OFFLINE OFFLINE
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application OFFLINE OFFLINE TTTTDB1
ora....db1.vip ora....t1.type OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE TTTTDB2
ora....B2.lsnr application OFFLINE OFFLINE TTTTDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application OFFLINE OFFLINE TTTTDB2
ora....db2.vip ora....t1.type OFFLINE OFFLINE TTTTDB2
ora.ttttdb.db ora....se.type OFFLINE ONLINE TTTTDB2
TTTTDB1:/home/grid$
|
|
TTTTDB2:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora....ER.lsnr ora....er.type OFFLINE OFFLINE TTTTDB2
ora....N1.lsnr ora....er.type OFFLINE OFFLINE TTTTDB2
ora.DATA.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora.FRA1.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法
ora.asm ora.asm.type OFFLINE OFFLINE TTTTDB1
ora.cvu ora.cvu.type OFFLINE OFFLINE TTTTDB2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora.....type OFFLINE OFFLINE TTTTDB1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE TTTTDB2
ora.ons ora.ons.type OFFLINE OFFLINE TTTTDB1
ora....ry.acfs ora....fs.type OFFLINE OFFLINE TTTTDB1
ora.scan1.vip ora....ip.type OFFLINE OFFLINE TTTTDB2
ora....SM1.asm application OFFLINE OFFLINE TTTTDB1
ora....B1.lsnr application OFFLINE OFFLINE
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application OFFLINE OFFLINE TTTTDB1
ora....db1.vip ora....t1.type OFFLINE OFFLINE
ora....SM2.asm application OFFLINE OFFLINE TTTTDB2
ora....B2.lsnr application OFFLINE OFFLINE TTTTDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application OFFLINE OFFLINE TTTTDB2
ora....db2.vip ora....t1.type OFFLINE OFFLINE TTTTDB2
ora.ttttdb.db ora....se.type OFFLINE ONLINE TTTTDB2
TTTTDB2:/home/grid$
|
|
TTTTDB1:/home/grid$
CRS-5702: Resource 'ora.CRS.dg' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.NDATA.dg' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.NFRA.dg' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.asm' is already running on 'TTTTDB1'
CRS-2501: Resource 'ora.gsd' is disabled
CRS-5702: Resource 'ora.net1.network' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.registry.acfs' is already running on 'TTTTDB1'
CRS-5702: Resource 'ora.asm' is already running on 'TTTTDB1'
CRS-2501: Resource 'ora.gsd' is disabled
CRS-5702: Resource 'ora.asm' is already running on 'TTTTDB1'
CRS-2501: Resource 'ora.gsd' is disabled
CRS-5017: The resource action "ora.ttttdb.db start" encountered the following error:
|
|
[root@rac1 bin]# ./crsctlstart crs
CRS-4124: Oracle HighAvailability Services startup failed. (错误) -->解决方法
CRS-4000: Command Startfailed, or completed with errors. -->解决方法
[root@rac2 bin]#./crsctl check crs
CRS-4638: Oracle High AvailabilityServices is OFFLINE
CRS-4535: Cannot communicate with ClusterReady Services
CRS-4530: Communications failure contactingCluster Synchronization Services daemon
CRS-4534: Cannotcommunicate with Event Manager
[root@rac1 bin]# ./crsctlstart cluster -all
CRS-5702: Resource 'ora.crsd' is alreadyrunning on 'rac1'
CRS-5702: Resource 'ora.crsd' is alreadyrunning on 'rac2'
[root@rac2 u01]# sh crs_stat.sh
Name Target State Host
------------------------------ ------------------- -------
ora.DATA.dg OFFLINE OFFLINE rac1
ora.FRA.dg OFFLINE OFFLINE rac1
ora.LISTENER.lsnr OFFLINE OFFLINE rac1
ora.LISTENER_SCAN1.lsnr OFFLINE OFFLINE rac2
ora.OCRVOTING.dg OFFLINE OFFLINE rac1
ora.asm OFFLINE OFFLINE rac1
ora.dave.db OFFLINE OFFLINE
ora.eons OFFLINE OFFLINE rac1
ora.gsd OFFLINE OFFLINE
ora.net1.network OFFLINE OFFLINE rac1
ora.oc4j OFFLINE OFFLINE
ora.ons OFFLINE OFFLINE rac1
ora.rac1.ASM1.asm OFFLINE OFFLINE rac1
ora.rac1.LISTENER_RAC1.lsnr OFFLINE OFFLINE rac1
ora.rac1.gsd OFFLINE OFFLINE
ora.rac1.ons OFFLINE OFFLINE rac1
ora.rac1.vip OFFLINE OFFLINE rac1
ora.rac2.ASM2.asm OFFLINE OFFLINE rac2
ora.rac2.LISTENER_RAC2.lsnr OFFLINE OFFLINE rac2
ora.rac2.gsd OFFLINE OFFLINE
ora.rac2.ons OFFLINE OFFLINE rac2
ora.rac2.vip OFFLINE OFFLINE rac2
ora.scan1.vip OFFLINE OFFLINE rac2
|
|
CRS-2765:Resource 'ora.cssdmonitor' has failed on server 'TTTTDB1'.
[ohasd(4259970)]CRS-2765:Resource 'ora.cssdmonitor' has failed on server 'TTTTDB1'.
2023-02-18 11:52:53.722
[ohasd(4259970)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
|
|
[ohasd(4259970)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:)in /u01/app/product/11.2.0/grid/log/TTTTDB1/cssd/ocssd.log
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB1/cssd/ocssd.log
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB1/cssd/ocssd.log
|
|
[ohasd(4259970)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB2/cssd/ocssd.log
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB2/cssd/ocssd.log
[cssd(5439522)]CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds;
Details at (:CSSNM00070:) in /u01/app/product/11.2.0/grid/log/TTTTDB2/cssd/ocssd.log
|
|
TTTTDB1:~>
CRS-4638:Oracle High Availability Servicesis online
CRS-4535:Cannotcommunicate with ClusterReady Services -->解决方法
CRS-4530:Communications failure contacting Cluster Synchronization Services daemon
CRS-4534:Cannotcommunicate with EventManager
|
|
TTTTDB1:/home/grid$
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services -->解决方法
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
TTTTDB1:/home/grid$
|
|
TTTTDB1:/home/grid$
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 OFFLINE OFFLINE Instance Shutdown
ora.cluster_interconnect.haip
1 ONLINE ONLINE TTTTDB1
ora.crf
1 ONLINE ONLINE TTTTDB1
ora.crsd
1 ONLINE OFFLINE -->解决方法
ora.cssd
1 ONLINE ONLINE TTTTDB1
ora.cssdmonitor
1 ONLINE ONLINE TTTTDB1
ora.ctssd
1 ONLINE ONLINE TTTTDB1 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE -->解决方法
ora.drivers.acfs
1 ONLINE ONLINE TTTTDB1
ora.evmd
1 ONLINE ONLINE TTTTDB1
ora.gipcd
1 ONLINE ONLINE TTTTDB1
ora.gpnpd
1 ONLINE ONLINE TTTTDB1
ora.mdnsd
1 ONLINE ONLINE TTTTDB1
TTTTDB1:/home/grid$
|
|
TTTTDB2:/home/grid$
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 OFFLINE OFFLINE Instance Shutdown
ora.cluster_interconnect.haip
1 ONLINE ONLINE TTTTDB2
ora.crf
1 ONLINE ONLINE TTTTDB2
ora.crsd
1 ONLINE OFFLINE -->解决方法
ora.cssd
1 ONLINE ONLINE TTTTDB2
ora.cssdmonitor
1 ONLINE ONLINE TTTTDB2
ora.ctssd
1 ONLINE ONLINE TTTTDB2 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE -->解决方法
ora.drivers.acfs
1 ONLINE ONLINE TTTTDB2
ora.evmd
1 ONLINE ONLINE TTTTDB2
ora.gipcd
1 ONLINE ONLINE TTTTDB2
ora.gpnpd
1 ONLINE ONLINE TTTTDB2
ora.mdnsd
1 ONLINE ONLINE TTTTDB2
TTTTDB2:/home/grid$
|
|
TTTTDB1:~> 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
|
|
TTTTDB2:/home/grid$crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services -->解决方法
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
TTTTDB1:/home/grid$
|
|
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
CRS MOUNTED
DATA1 CONNECTED -->解决方法
FRA1 CONNECTED -->解决方法
|
|
TTTTDB1:/u01/app/11.2.0/grid/bin$
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 15362 14434 5120 3657 0 Y CRSDG/
MOUNTED CONNECTED N 512 4096 1048576 2024000 170044 0 585022 0 N DATA1/
TTTTDB1:/u01/app/11.2.0/grid/bin$
|
|
TTTTDB1:/u01/app/11.2.0/grid/bin$
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 15362 14434 5120 3657 0 Y CRSDG/
MOUNTED NORMAL N 512 4096 1048576 2024000 170044 0 585022 0 N DATA/
TTTTDB1:/u01/app/11.2.0/grid/bin$
|
|
TTTTDB1:/home/oracle$sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on 星期一 1月 6 23:24:26 2023
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01102: cannot mount database in EXCLUSIVE mode -->解决方法
SQL>
|
|
TTTTDB2:/home/oracle$sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on 星期一 1月 6 23:24:26 2023
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01102: cannot mount database in EXCLUSIVE mode -->解决方法
SQL>
|
|
错误：ORA-01102: cannot mount database in EXCLUSIVE mode -->解决方法
|
|
TTTTDB1 >startup
ORACLE instance started.
Total System Global Area 941600768 bytes
Fixed Size 1348860 bytes
Variable Size 549456644 bytes
Database Buffers 385875968 bytes
Redo Buffers 4919296 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
|
|
TTTTDB2 >startup
ORACLE instance started.
Total System Global Area 941600768 bytes
Fixed Size 1348860 bytes
Variable Size 549456644 bytes
Database Buffers 385875968 bytes
Redo Buffers 4919296 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
|
|
MMNL started with pid=16, OS id=20451
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/oracle
ALTER DATABASE MOUNT
sculkget: failed to lock /u01/app/oracle/product/11.2.0/db1/dbs/ exclusive
sculkget: lock held by PID: 17127
ORA-09968: unable to lock file
Linux Error: 11: Resource temporarily unavailable
Additional information: 17127
ORA-1102 signalled during: ALTER DATABASE MOUNT...
|
|
ora.ttttdb.db
1 ONLINE ONLINE TTTTDB1 Open
2 ONLINE OFFLINE Instance Shutdown -->解决方法
|
|
ora.ttttdb.db
1 ONLINE ONLINE TTTTDB2 Open
2 ONLINE OFFLINE Instance Shutdown -->解决方法
|
|
TTTTDB1:>
Oracle RAC 集群启动实例 PRCR-1079、CRS-5017、ORA-01102 cannot mount database in EXCLUSIVE mode
RAC环境：Oracle 11g R2 RAC集群 在做异机恢复时，通过srvctl start database -d 命令启动数据实例，
遇到ORA-01102 cannot mount database in EXCLUSIVE mode错误.导致只有一个节点能起来.另 一个节点启动数据库失败.
ORA-01102 cannot mount database in EXCLUSIVE mode -->解决方法
|
|
TTTTDB2:>
Oracle RAC 集群启动实例 PRCR-1079、CRS-5017、ORA-01102 cannot mount database in EXCLUSIVE mode
RAC环境：Oracle 11g R2 RAC集群 在做异机恢复时，通过srvctl start database -d 命令启动数据实例，
遇到ORA-01102 cannot mount database in EXCLUSIVE mode错误.导致只有一个节点能起来.另 一个节点启动数据库失败.
ORA-01102 cannot mount database in EXCLUSIVE mode -->解决方法
|
|
TTTTDB1:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE TTTTDB1
ora....ER.lsnr ora....er.type ONLINE ONLINE TTTTDB1
ora....N1.lsnr ora....er.type ONLINE ONLINE TTTTDB2
ora.DATA1.dg ora....up.type ONLINE ONLINE TTTTDB1
ora.FRA1.dg ora....up.type ONLINE ONLINE TTTTDB1
ora.asm ora.asm.type ONLINE ONLINE TTTTDB1
ora.cvu ora.cvu.type ONLINE ONLINE TTTTDB2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE TTTTDB1
ora.oc4j ora.oc4j.type ONLINE ONLINE TTTTDB2
ora.ons ora.ons.type ONLINE ONLINE TTTTDB1
ora....ry.acfs ora....fs.type ONLINE ONLINE TTTTDB1
ora.scan1.vip ora....ip.type ONLINE ONLINE TTTTDB2
ora....SM1.asm application ONLINE ONLINE TTTTDB1
ora....B1.lsnr application ONLINE ONLINE TTTTDB1
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application ONLINE ONLINE TTTTDB1
ora....db1.vip ora....t1.type ONLINE ONLINE TTTTDB1
ora....SM2.asm application ONLINE ONLINE TTTTDB2
ora....B2.lsnr application ONLINE ONLINE TTTTDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application ONLINE ONLINE TTTTDB2
ora....db2.vip ora....t1.type ONLINE ONLINE TTTTDB2
ora.ttttdb.db ora....se.type ONLINE ONLINE TTTTDB1
TTTTDB1:/home/grid$
|
|
TTTTDB2:/home/grid$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE TTTTDB1
ora....ER.lsnr ora....er.type ONLINE ONLINE TTTTDB1
ora....N1.lsnr ora....er.type ONLINE ONLINE TTTTDB2
ora.DATA1.dg ora....up.type ONLINE ONLINE TTTTDB1
ora.FRA1.dg ora....up.type ONLINE ONLINE TTTTDB1
ora.asm ora.asm.type ONLINE ONLINE TTTTDB1
ora.cvu ora.cvu.type ONLINE ONLINE TTTTDB2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE TTTTDB1
ora.oc4j ora.oc4j.type ONLINE ONLINE TTTTDB2
ora.ons ora.ons.type ONLINE ONLINE TTTTDB1
ora....ry.acfs ora....fs.type ONLINE ONLINE TTTTDB1
ora.scan1.vip ora....ip.type ONLINE ONLINE TTTTDB2
ora....SM1.asm application ONLINE ONLINE TTTTDB1
ora....B1.lsnr application ONLINE ONLINE TTTTDB1
ora....db1.gsd application OFFLINE OFFLINE
ora....db1.ons application ONLINE ONLINE TTTTDB1
ora....db1.vip ora....t1.type ONLINE ONLINE TTTTDB1
ora....SM2.asm application ONLINE ONLINE TTTTDB2
ora....B2.lsnr application ONLINE ONLINE TTTTDB2
ora....db2.gsd application OFFLINE OFFLINE
ora....db2.ons application ONLINE ONLINE TTTTDB2
ora....db2.vip ora....t1.type ONLINE ONLINE TTTTDB2
ora.ttttdb.db ora....se.type ONLINE ONLINE TTTTDB1
TTTTDB2:/home/grid$
|
|
中国·北京 重庆 联系方式：
|
|
|
