|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
重新搭建系统成功案例:IBM P720 小型机 + EMC VNX5100存储 + Oracle Database 11.2.0.3 数据库 -->成功案例-->霍工--> 13301272832 (微信同号) |
|
重新搭建系统成功案例:IBM P720 + EMC VNX5100 + Oracle Database 11.2.0.3 -->成功案例-->霍工--> 13301272832 (微信同号) |
重新搭建 硬件 系统成功案例:IBM P720 + EMC VNX5100存储
1)硬件环境描述:
IBM P720 + EMC VNX5100存储
2)操作描述:
IBM AIX 6.1 操作系统
3)数据库描述:
Oracle Database: 11G
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
![](http://www.chinama.com.cn/images/IBM_Power_720.jpg) |
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
![](http://www.chinama.com.cn/images/EMC_VNX5500.jpg) |
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
重新搭建 AIX操作系统 成功案例:AIX 操作系统
1)重新安装AIX 操作系统。
2)重新配置主机名称。
3)重新配置IP地址。
4)重新安装SSH。
5)重新配置SSH.
6)重新分配新逻辑分区。
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
重新搭建 Oracle Database 成功案例: Oracle Database 11G for AIX6.1
1)重新安装Oracle Database: 11.2.0.3 数据库。
2)重新上传Oracle数据库文件。
3)重新配置安装Oracle数据的CDE图形界面安装环境的配置。
4)重新安装Oracle Database: 11.2.0.3 数据库的安装。
5)重新安装Oracle Database: 11.2.0.3 数据库的安装过程中疑难问题的解决。
6)重新安装Oracle Database: 11.2.0.3 数据库成功。
7)重新配置Oracle Database: 11.2.0.3 数据库的监听文件。
8)重新配置Oracle Database: 11.2.0.3 数据库的重新创建新实例数据库。
9)重新启动监听成功。
10)重新启动数据库成功。
11)重新安装、配置Oracle Database: 11.2.0.3 数据库的成功。
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
重新恢复 Oracle Database RAC1 节点失败成功案例:两台IBM P740 小型机 + MacroSAN 5000存储 + Oracle Database 11.2.0.3数据库 RAC1 单节点失败
-->解决成功案例-->霍工 13301272832 (微信同号)
重新恢复 Oracle Database RAC2 节点失败成功案例:两台IBM P740 小型机 + MacroSAN 5000存储 + Oracle Database 11.2.0.3数据库 RAC2 单节点失败
-->解决成功案例-->霍工 13301272832 (微信同号)
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
重新恢复 Oracle Database RAC1 节点失败成功案例:两台IBM P740 小型机 + MacroSAN 5000存储 + Oracle Database 11.2.0.4数据库 RAC1 单节点失败
-->解决成功案例-->霍工 13301272832 (微信同号)
重新恢复 Oracle Database RAC2 节点失败成功案例:两台IBM P740 小型机 + MacroSAN 5000存储 + Oracle Database 11.2.0.4数据库 RAC2 单节点失败
-->解决成功案例-->霍工 13301272832 (微信同号)
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
Oracle Database: RAC 疑难问题-->解决方法-->霍工--> 13301272832 (微信同号) |
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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 (微信同号) |
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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 (微信同号) |
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
CRS-4124: Oracle HighAvailability Services startup failed,数据恢复技术服务-->解决方法-->霍工-->13301272832(微信同号) |
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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.
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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:
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
[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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
[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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
[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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
CRS MOUNTED
DATA1 CONNECTED -->解决方法-->霍工-->13301272832(微信同号)
FRA1 CONNECTED -->解决方法-->霍工-->13301272832(微信同号)
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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>
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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>
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
错误:ORA-01102: cannot mount database in EXCLUSIVE mode -->解决方法-->霍工--> 13301272832 (微信同号)
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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...
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
ora.ttttdb.db
1 ONLINE ONLINE TTTTDB1 Open
2 ONLINE OFFLINE Instance Shutdown -->解决方法-->霍工--> 13301272832 (微信同号)
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
ora.ttttdb.db
1 ONLINE ONLINE TTTTDB2 Open
2 ONLINE OFFLINE Instance Shutdown -->解决方法-->霍工--> 13301272832 (微信同号)
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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 (微信同号)
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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 (微信同号)
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
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$
|
![](http://www.chinama.com.cn/images/icon-bg-2.gif) |
中国·北京 重庆 联系方式:
|
|