这篇文章主要介绍“怎么解决Oracle 12.2应用PSU后数据库无法启动问题”，在日常操作中，相信很多人在怎么解决Oracle 12.2应用PSU后数据库无法启动问题问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”怎么解决Oracle 12.2应用PSU后数据库无法启动问题”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

环境介绍

数据库：Oracle Database 12.2

PSU：p30783652

数据库补丁应用完成，检查补丁应用情况

cd/u01/app/oracle/product/12.2.0/db_1/0Patch]$.lopatchIsinvIgrepdescARUplatformdescription::IBMAIXPatchdescription:"OJMMRELEASEUPDATE:12.2.0.1.200414(30805580)"Patchdescription:"OCWAPR2020RELEASEUPDATE12.2.0.1.200414(30882603)"Patchdescription:"DatabaseApr2028ReleaseUpdate:12.2.0.1.200414(30886680

启动数据库报错

SQL>startupORA-39510:CRSerrorperformingstartoninstance'cdb122on'cdb122CRS-2527:Unabletostart'ora.cdb122.db'becauseithasa'hard'dependencyon'ora.REDO1.dgCRS-2501:Resource'ora.REDO1.dg'isdisabledCRS-0222:Resource'ora.cdb122.db'hasdependencyerror,clsr_start_resource:260status:222clsrapi_start_db:start_asmdbsstatus:222

检查ASM磁盘组

SQL>selectname,statefromv$asm_diskgroupnamestate---------------------------------DATAMOUNTCRSMOUNT

检查资源状态

$crsctlstatueres-t....ora.DATA.dgOFFLINEOFFLINE.....

ora.DATA.dg资源状态不正常

$crsctlstartresource-allCRS-5702:Resource'ora.CRS.dg'isalreadyrunningon'dbdo01CRS-2501:Resourceora.DATA.dg'isdisabledCRS-5702:Resourpe'ora.LISTENER.Isnr'isalreadyrunningondbdoa1'CRS-5702:Resource'ora.LISTENER1529.1snr'isalreadyrunningondbdo01CRS-2501:Resource'ora.REDo1.dgisdisabledCRS-2501:Resource'ora.RED02.dg'isdisabledCRS-5702:Resource'ora.asm'isalreadyrunningon'dbdo01CRS-2527:Unabletostart'ora.cdb122.db'becauseithasa'hard'dependencyon'ora.REDO1.dgCRS-2501:Resource'ora.REDO1.dg'isdisablecCRS-2527:Unabletostart'ora.ceshidb.db'becauseithasa'hard'dependencyon'ora.DATA.dg'CRS-2501:Resource'ora.DATA.dg'isdisabledCRS-5702:Resource'ora.cssd'isalreadyrunningon'dbdoen'CRS-5702:Resource'ora.evmd'isalreadyrunningon'dbdo01CRS-2501:Resource'ora.ons'isdisabledCRS-2527:Unabletostart'ora.orainfal.db'becauseithasa"hard'dependencyon'ora.DATA.dgCRS-2501:Resource'ora.DATA.dgisdisabledCRS-2527:Unabletostart'ora.orarptst.db'becauseithasa'hard'dependencyon'ora.DATA.dgCRS-2501:Resource'ora.DATA.dg'isdisabledCRS-2672:Attemptingtostart'ora.diskmonon'dbdoe1CRS-2676:startof'ora.diskmon'on'dbdo01'succeededCRS-4000:CommandStartfailed,orcompletedwitherrors.$srvctlenablediskgroup-diskgroupdatacrsctlstartresource-all$crsctlstatueres-t

....

ora.DATA.dg ONLINE ONLINE

数据库可以正常启动

到此，关于“怎么解决Oracle 12.2应用PSU后数据库无法启动问题”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！