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.
Details of error are as follows.
[MSD4]/home/oracle $ sqlplus / as sysdba SQL*Plus: Release 126.96.36.199.0 - Production on Sat Mar 28 19:35:31 2020 Version 188.8.131.52.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 $
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.
92 views today, 2 views in last 3 hour