Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Can't start asm and database. PRCR-1079 CRS-2674:

Hi db admins,

I have a problem on the test environment. Colleagues restored the virtual machine from the previous day's snapshot. and now we have problem to start oracle asm and oracle database.

SQL> startup;
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service

$ srvctl start asm
PRCR-1079 : Failed to start resource ora.asm
CRS-2674: Start of 'ora.driver.afd' on 'myhostname' failed

$crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg

ONLINE OFFLINE myhostname STABLE

ora.DATA2.dg

ONLINE OFFLINE myhostname STABLE

ora.LISTENER.lsnr

ONLINE ONLINE myhostname STABLE

ora.LISTENER_OEM.lsnr

ONLINE ONLINE myhostname STABLE

ora.OCR.dg

ONLINE OFFLINE myhostname STABLE

ora.asm

ONLINE OFFLINE myhostname STABLE

ora.ons

OFFLINE OFFLINE myhostname STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd

1 ONLINE OFFLINE STABLE

ora.diskmon

1 ONLINE OFFLINE STABLE

ora.driver.afd

1 ONLINE OFFLINE STABLE

ora.evmd

1 ONLINE ONLINE myhostname STABLE

ora.testDB.db

1 ONLINE OFFLINE STABLE
--------------------------------------------------------------------------------

Can anyone help me find a solution to restart the database?

if you need any more information, I will send it to you.

Thank you.

Comments
Post Details
Added on Mar 15 2024
1 comment
54 views