Site icon IT Tutorial

ORA-39511: Start of CRS resource for instance ‘223’ failed with error:[CRS-5702: Resource, ORA-32004 CRS-0223 During Full Exadata Database Startup

Hi,

When I startup any instance in the Full exadata, i got ” ORA-39511: Start of CRS resource for instance ‘223’ failed with error:[CRS-5702: Resource, ORA-32004 CRS-0223 ” errors.

 

ORA-39511: Start of CRS resource for instance

Details of error are as follows.

 

[MSD4]/home/oracle $ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Sat Mar 28 19:35:31 2020
Version 18.7.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connected to an idle instance.

SQL>
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-39511: Start of CRS resource for instance '223' failed with error:[CRS-5702: Resource 'ora.MSD.db' is already running on 'msdidb04'
CRS-0223: Resource 'ora.MSD.db' has placement error.
clsr_start_resource:260 status:223
clsrapi_start_db:start_asmdbs status:223
]
SQL> exit
Disconnected
[MSD4]/home/oracle $

 

 

CRS-5702: Resource, ORA-32004 CRS-0223

 

Even though related instance are off, but it couldn’t startup.

 

 

To solve this problem, stop Instance via SRVCTL as follows.

srvctl stop instance -db DB_NAME -n INSTANCE_NAME

 

[MSD4]/home/oracle $  srvctl stop instance -db MSD -n msdidb04

 

Now you can startup this instance also.

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

Exit mobile version