Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the problem that the database cannot be started after the application of PSU in Oracle 12.2". In the daily operation, it is believed that many people have doubts about how to solve the problem that the database cannot be started after the application of PSU in Oracle 12.2. the editor consulted all kinds of materials and sorted out a simple and useful method of operation. I hope it will be helpful for you to answer the doubt that "how to solve the problem that the database cannot be started after the application of PSU in Oracle 12.2"! Next, please follow the editor to study!

Environment introduction

Database: Oracle Database 12.2

PSU:p30783652

Database patch application is complete. Check the patch application.

Cd / u01/app/oracle/product/12.2.0/db_1/0Patch] $.lopatch Isinv Igrep descARU platform description:: IBM AIXPatch description: "OJMM RELEASE UPDATE: 12.2.0.1.200414 (30805580)" Patch description: "OCW APR 2020 RELEASE UPDATE 12.2.0.1.200414 (30882603)" Patch description: "Database Apr 2028 Release Update: 12.2.0.1.200414 (30886680)

Start the database error report

SQL > startupORA-39510: CRS error performing start on instance 'cdb122 on' cdb122CRS-2527: Unable to start 'ora.cdb122.db' because it has a' hard' dependency on 'ora.REDO1.dgCRS-2501: Resource' ora.REDO1.dg' is disabledCRS-0222: Resource 'ora.cdb122.db' has dependency error,clsr_start_resource: 260 status: 222 clsrapi _ start_db: start_asmdbs status:222

Check the ASM disk group

SQL > select name, state from v$asm_diskgroupname state--DATA MOUNTCRS MOUNT

Check the status of resources

$crsctl statue res-t....ora.DATA.dg OFFLINE OFFLINE.

Ora.DATA.dg resource status is abnormal

$crsctl start resource-allCRS-5702: Resource 'ora.CRS.dg' is already running on' dbdo01CRS-2501: Resource ora.DATA.dg' is disabledCRS-5702: Resourpe 'ora. LISTENER.Isnr' is already running on dbdoa1'CRS-5702: Resource 'ora.LISTENER 1529.1 snr' is already running on dbdo01CRS-2501: Resource 'ora.REDo1.dg is disabledCRS-2501: Resource' ora.RED02.dg' is disabledCRS-5702: Resource 'ora.asm' is already running on' dbdo01CRS-2527: Unable to start 'ora.cdb122.db' because it has a' hard' dependency on 'ora.REDO1.dgCRS-2501: Resource' ora.REDO1.dg' is disablecCRS-2527: Unable to start 'ora.ceshidb. Db' because it has a 'hard' dependency on' ora.DATA.dg'CRS-2501: Resource 'ora.DATA.dg' is disabledCRS-5702: Resource' ora.cssd' is already running on 'dbdoen'CRS-5702: Resource' ora.evmd' is already running on 'dbdo01CRS-2501: Resource' ora.ons' is disabledCRS-2527: Unable to start 'ora.orainfal.db' because it has a "hard' dependency on' ora.DATA.dgCRS-2501: Resource 'ora.DATA.dg is disabledCRS-2527: Unable to Start 'ora.orarptst.db' because it has a' hard' dependency on' ora.DATA.dgCRS-2501: Resource 'ora.DATA.dg' is disabledCRS-2672: Attempting to start' ora.diskmon on' dbdoe1CRS-2676: start of 'ora.diskmon' on' dbdo01' succeededCRS-4000: Command Start failed Or completed with errors.$srvctl enable diskgroup-diskgroup datacrsctl start resource-all$crsctl statue res-t

....

Ora.DATA.dg ONLINE ONLINE

The database can start normally.

At this point, the study on "how to solve the problem that the database cannot be started after the application of PSU in Oracle 12.2" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.