深蓝快车
专业技术服务提供商;专业存储设备提供商

重新恢复 Oracle Database RAC1 节点失败成功案例:SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G 数据库 RAC1 单节点失败 -->成功案例-->霍工--> 13301272832 (微信同号)

产品

技术

配件

IT疑难问题解决方案1

IT疑难问题解决方案2

小型机服务

服务器服务

存储服务

维保

机房搬迁

操作系统|双机

数据库

备份/恢复

Oracle灾备

应急服务

楼宇监控

深蓝快车

技术中心

案例

联系我们

重新恢复 Oracle Database RAC1 节点失败成功案例:SUN V880 小型机 + SUN 3510存储 + Oracle Database 9i 数据库 RAC1 单节点失败 -->成功案例
重新恢复 Oracle Database RAC2 节点失败成功案例:SUN V880 小型机 + SUN 3510存储 + Oracle Database 9i 数据库 RAC2 单节点失败 -->成功案例
重新恢复 Oracle Database RAC 节点失败成功案例:SUN V880 小型机 + SUN 3510存储 + Oracle Database 9i 数据库 RAC 单节点失败 -->成功案例
重新恢复 Oracle Database 节点失败成功案例:SUN V880 小型机 + SUN 3510存储 + Oracle Database 9i 数据库 单节点失败 -->成功案例
重新恢复 Oracle Database RAC1 节点失败成功案例:SUN M5000 小型机 + HPE 3PAR 7400C 存储 + Oracle Database 11G 数据库 RAC1 单节点失败
重新恢复 Oracle Database RAC2 节点失败成功案例:SUN M5000 小型机 + HPE 3PAR 7400C 存储 + Oracle Database 11G 数据库 RAC2 单节点失败
重新恢复 Oracle Database RAC 节点失败成功案例:SUN M5000 小型机 + HPE 3PAR 7400C 存储 + Oracle Database 11G 数据库 RAC 单节点失败
重新恢复 Oracle Database 节点失败成功案例:SUN M5000 小型机 + HPE 3PAR 7400C 存储 + Oracle Database 11G 数据库 单节点失败
重新恢复 Oracle Database RAC1 节点失败成功案例:SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G 数据库 RAC1 单节点失败 -->成功案例
重新恢复 Oracle Database RAC2 节点失败成功案例:SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G 数据库 RAC2 单节点失败 -->成功案例
重新恢复 Oracle Database RAC 节点失败成功案例:SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G 数据库 RAC 单节点失败 -->成功案例
重新恢复 Oracle Database 节点失败成功案例:SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G 数据库 单节点失败 -->成功案例
重新恢复 Oracle Database RAC1 节点失败成功案例:Oracle SPARC T4-4 小型机 + EMC VNX5600 存储 + Oracle Database 11G 数据库 RAC1 单节点失败 -->成功案例
重新恢复 Oracle Database RAC2 节点失败成功案例:Oracle SPARC T4-4 小型机 + EMC VNX5600 存储 + Oracle Database 11G 数据库 RAC2 单节点失败 -->成功案例
重新恢复 Oracle Database RAC 节点失败成功案例:Oracle SPARC T4-4 小型机 + EMC VNX5600 存储 + Oracle Database 11G 数据库 RAC 单节点失败 -->成功案例
重新恢复 Oracle Database 节点失败成功案例:Oracle SPARC T4-4 小型机 + EMC VNX5600 存储 + Oracle Database 11G 数据库 单节点失败 -->成功案例
重新恢复 Oracle Database RAC1 节点失败成功案例:SUN 6800 小型机 + HDS9570V存储 + Oracle Database 11G 数据库 RAC1 单节点失败 -->成功案例
重新恢复 Oracle Database RAC2 节点失败成功案例:SUN 6800 小型机 + HDS9570V存储 + Oracle Database 11G 数据库 RAC2 单节点失败 -->成功案例
重新恢复 Oracle Database RAC 节点失败成功案例:SUN 6800 小型机 + HDS9570V存储 + Oracle Database 11G 数据库 RAC 单节点失败 -->成功案例
重新恢复 Oracle Database 节点失败成功案例:SUN 6800 小型机 + HDS9570V存储 + Oracle Database 11G 数据库 单节点失败 -->成功案例
重新恢复 Oracle Database RAC1 节点失败成功案例:SUN V890 小型机 + SUN 6130 存储 + Oracle Database 11G 数据库 RAC1 单节点失败 -->成功案例
重新恢复 Oracle Database RAC2 节点失败成功案例:SUN V890 小型机 + SUN 6130 存储 + Oracle Database 11G 数据库 RAC2 单节点失败 -->成功案例
重新恢复 Oracle Database RAC 节点失败成功案例:SUN V890 小型机 + SUN 6130 存储 + Oracle Database 11G 数据库 RAC 单节点失败 -->成功案例
重新恢复 Oracle Database 节点失败成功案例:SUN V890 小型机 + SUN 6130 存储 + Oracle Database 11G 数据库 单节点失败 -->成功案例
ora.asm ora.asm.type OFFLINE OFFLINE TTTTDB1
Oracle RAC ASM1 CRS-0184: Cannot communicate with the CRS daemon
Oracle RAC ASM2 CRS-0184: Cannot communicate with the CRS daemon
ora.CRS.dg ora....up.type OFFLINE OFFLINE TTTTDB1
CRS-0184: Cannot communicate with the CRS daemon
CRS-0223: Resource 'ora.asm' has placement error
CRS-1714:Unable to discover any voting files, retrying discovery in 15 seconds
CRS-2660: Resource 'ora.TTTTDB1.gsd' or all of its instances are disabled
CRS-4000: Command Startfailed, or completed with errors
CRS-4124: Oracle High Availability Services startup failed
CRS-4530 Communications failure contacting Cluster Synchronization Services daemon
CRS-4530 Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
CRS-4535: Cannot communicate with ClusterReady Services
CRS-4535: Cannot communicate with ClusterReady Services
ora.ttttdb.db OFFLINE OFFLINE Instance Shutdown
DATA MOUNTED CONNECTED
ora.DATA.dg ora....up.type OFFLINE OFFLINE TTTTDB1
DATA UMOUNTED
Oracle Grid CRS-0184: Cannot communicate with the CRS daemon
ora....B1.lsnr application OFFLINE OFFLINE TTTTDB1
ORA-01102: cannot mount database in EXCLUSIVE mode
ora.scan1.vip ora....ip.type OFFLINE OFFLINE TTTTDB1
ORA-00204: error in reading (block 3, # blocks 8) of controlfile
ORA-00205: error in identifying control file, check alert log for more inf.
oracle非法关机引起redolog丢失,导致数据库实例无法正常启动(ORA-00313 ORA-00312 ORA-00376)
ORA-00376:此时无法读取文件3
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00821: Specified value of sga_target 4072M is too small, needs to be at least 13896M,数据恢复技术服务
ORA-00845: MEMORY_TARGET not supported on this system
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01078: failure in processing system parameters
ORA-01113:文件7需要介质恢复
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file,数据恢复技术服务
ora-01190:控制文件或数据文件3来自最后一个RESETLOG之前
ORA-01552 cannot use system rollback segment for non-system tablespace
ORA-01624: 日志3是紧急修复实例
ORA-01658 oracle导入数据出错:ORA-01658:无法为表空间TESt中的段创建INITIAL区
ORA-00823: Specified value of sga_target greater than sga_max_size
ORA-03113: end-of-file on communication channel,数据恢复技术服务
ora-04031 无法分配XXX字节的共享内存(XXX)”的解决办法
ORA-07391: sftopn: fopen error, unable to open text file
ORA-27072: File I/O error
ORA-32001: write to SPFILE requested bu no SPFILE specified at startup.
SQL 错误: ORA-65096: 公用用户名或角色名无效
ASM Disk Group mount failure,数据恢复技术服务
ASM Disk Group 中只能mount 一个节点DATA的磁盘
CRS-4535: Cannot communicate with Cluster Ready Services,数据恢复技术服务
CRS-0184: Cannot communicate with the CRS daemon,数据恢复技术服务
CRS-0215: Could not start resource 'ora.test.db 2 1',数据恢复技术服务
CRS-4124: Oracle HighAvailability Services startup failed,数据恢复技术服务
CRS-4535: Cannot communicate with Cluster Ready Services,数据恢复技术服务
[INS-06006] Passwordless SSH connectivity not set up between the following node(s),数据恢复技术服务
[INS-20802] Oracle Cluster Verification Utility failed,数据恢复技术服务
[INS-32016] The selected Oracle home contains directories or files,数据恢复技术服务
[INS-40724] No locally defined network interface matches the SCAN,数据恢复技术服务
CRS-0215: Could not start resource 'ora.test.db 2 1',数据恢复技术服务
invalid stored block lengs,数据恢复技术服务
libmpfr.so.1()(64bit) is needed by cpp-4.4.6-3.el6.x86_64
oracle实例名: error while loading shared libraries: libskgxp10.so: cannot open shared object file: No such file or directory.
Linux-x86_64 Error
Oracle Custer Verification Utility Failed (see details) Recommended,数据恢复技术服务
ohasd failed to start at/u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443,数据恢复技术服务
SP2-0042: unknown command "DATAFILE" - rest of line ignored.
TNS-12541: TNS: 无监听程序
ORA-00334: archived log: '+DATA//dbm/onlinelog/group_1.log
ORA-01034: ORACLE not available,数据恢复技术服务
ORA-01078: failure in processing system parameters,数据恢复技术服务
ORA-01110 数据文件坏,数据恢复技术服务
ORA-01589: must use RESETLOG or NORESETLOGS option for database open,数据恢复技术服务
ORA-02019: connection description for remote database not found,数据恢复技术服务
ORA-003111:cannot read header from archived log
ORA-12504: TNS:listener was not given the SID in CONNECT_DATA,数据恢复技术服务
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor,数据恢复技术服务
TNS-12535: TNS: 操作超时,数据恢复技术服务
ORA-15018: diskgroup cannot be created,数据恢复技术服务
ORA-15081 failed to submit an IO operation to disk
oracle Database 11.2 Error Messages
oracle Database 19C Error Messages
oracle Database 21C Error Messages
Oracle Database 技术支持电话: 13301272832 (微信同号)
Moble: 13301272832 (微信同号)
Tel:  010-82666745
联系人:   霍经理
QQ:   619804118
E-mail:   bjslkc@163.com
公司:北京深蓝融鑫科技发展有限公司

重新搭建系统成功案例:SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G 数据库 -->成功案例-->霍工--> 13301272832 (微信同号)


重新搭建系统成功案例:SUN M8000 + HDS9500 + Oracle Database 11G -->成功案例-->霍工--> 13301272832 (微信同号)

重新搭建 硬件 系统成功案例:SUN M8000 + HDS9500存储 1)硬件环境描述: SUN M8000 + HDS9500存储 2)操作描述: SUN Solaris 10 操作系统 3)数据库描述: Oracle Database: 11G

重新搭建 Solaris操作系统 成功案例:Solaris 操作系统 1)重新安装Solaris 操作系统。 2)重新配置主机名称。 3)重新配置IP地址。 4)重新安装SSH。 5)重新配置SSH. 6)重新分配新逻辑分区。

重新搭建 Oracle Database 成功案例: Oracle Database 11G for Solaris 1)重新安装Oracle Database 11G 数据库。 2)重新上传Oracle数据库文件。 3)重新配置安装Oracle数据的CDE图形界面安装环境的配置。 4)重新安装Oracle Database 11G 数据库的安装。 5)重新安装Oracle Database 11G 数据库的安装过程中疑难问题的解决。 6)重新安装Oracle Database 11G 数据库成功。 7)重新配置Oracle Database 11G 数据库的监听文件。 8)重新配置Oracle Database 11G 数据库的重新创建新实例数据库。 9)重新启动监听成功。 10)重新启动数据库成功。 11)重新安装、配置Oracle Database 11G 数据库的成功。

重新恢复 Oracle Database RAC1 节点失败成功案例:两台SUN M8000 小型机 + HDS9500存储 + Oracle Oracle Database 11G数据库 RAC1 单节点失败 -->解决成功案例-->霍工 13301272832 (微信同号) 重新恢复 Oracle Database RAC2 节点失败成功案例:两台SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G数据库 RAC2 单节点失败 -->解决成功案例-->霍工 13301272832 (微信同号)

重新恢复 Oracle Database RAC1 节点失败成功案例:两台SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G数据库 RAC1 单节点失败 -->解决成功案例-->霍工 13301272832 (微信同号) 重新恢复 Oracle Database RAC2 节点失败成功案例:两台SUN M8000 小型机 + HDS9500存储 + Oracle Database 11G数据库 RAC2 单节点失败 -->解决成功案例-->霍工 13301272832 (微信同号)

CRS-0184: Cannot communicate with the CRS daemon-->解决方法-->霍工--> 13301272832 (微信同号)

+ASM1 CRS-0184: Cannot communicate with the CRS daemon-->解决方法-->霍工--> 13301272832 (微信同号)

+ASM2 CRS-0184: Cannot communicate with the CRS daemon-->解决方法-->霍工--> 13301272832 (微信同号)

Grid 1$ CRS-0184: Cannot communicate with the CRS daemon-->解决方法-->霍工--> 13301272832 (微信同号)

Grid 2$ CRS-0184: Cannot communicate with the CRS daemon-->解决方法-->霍工--> 13301272832 (微信同号)

Oracle RAC ASM1 CRS-0184: Cannot communicate with the CRS daemon-->解决方法-->霍工--> 13301272832 (微信同号)

Oracle RAC ASM2 CRS-0184: Cannot communicate with the CRS daemon-->解决方法-->霍工--> 13301272832 (微信同号)

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,数据恢复技术服务-->解决方法-->霍工-->13301272832(微信同号)


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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) ora.FRA1.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) ora.FRA1.dg ora....up.type OFFLINE OFFLINE TTTTDB1 -->解决方法-->霍工-->13301272832(微信同号) 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. (错误) -->解决方法-->霍工-->13301272832(微信同号) CRS-4000: Command Startfailed, or completed with errors. -->解决方法-->霍工-->13301272832(微信同号) [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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) 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 -->解决方法-->霍工-->13301272832(微信同号) FRA1 CONNECTED -->解决方法-->霍工-->13301272832(微信同号)

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 -->解决方法-->霍工--> 13301272832 (微信同号) 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 -->解决方法-->霍工--> 13301272832 (微信同号) SQL>

错误:ORA-01102: cannot mount database in EXCLUSIVE mode -->解决方法-->霍工--> 13301272832 (微信同号)

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 -->解决方法-->霍工--> 13301272832 (微信同号)

ora.ttttdb.db 1 ONLINE ONLINE TTTTDB2 Open 2 ONLINE OFFLINE Instance Shutdown -->解决方法-->霍工--> 13301272832 (微信同号)

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 -->解决方法-->霍工--> 13301272832 (微信同号)

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 -->解决方法-->霍工--> 13301272832 (微信同号)

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$

中国·北京 重庆 联系方式:
北京 联系方式:
1)联系人:   霍 工
2)手 机: 13301272832 (微信同号)
3)QQ: 619804118
4)联系电话:(010)82666745
5)传   真:(010)82666745
6)E-mail:   bjslkc@163.com
7)公司:北京深蓝融鑫科技发展有限公司
8)公司地址、乘车路线及公司位置地图
重庆 联系方式:
1)联系人:   霍 工
2)手 机: 13301272832 (微信同号)
3)QQ: 619804118
4)联系电话:(010)82666745
5)传   真:(010)82666745
6)E-mail:   bjslkc@163.com
7)公司:北京深蓝融鑫科技发展有限公司
8)公司地址、乘车路线及公司位置地图
 

Beijing ShenLan Rongxin Technology Development Co., Ltd. All Rights Reserved.
北京深蓝融鑫科技发展有限公司 版权所有,不得转载.
主体备案编号:京ICP备05042544号