CRS-2552: There are no available instances of resource

I got ” CRS-2552: There are no available instances of resource ” error in Oracle database during Add instance to RAC Database.

CRS-2552: There are no available instances of resource

Details of error are as follows. We have 2 node instances in the RAC, I have added the new Nodes to RAC, When I start the Instance on the new server, I got this error.

SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-39511: Start of CRS resource for instance '223' failed with error:[CRS-2552: There are no available instances of resource 'ora.MSDBdg.db' to start.
CRS-0223: Resource 'ora.MSDBdg.db' has placement error.
clsr_start_resource:260 status:223
clsrapi_start_db:start_asmdbs status:223
]
SQL>

There are no available instances of resource

This CRS-2552 error is related with the  missing of Resource on the SRVCTL service.

To solve this error, You need to add instance using SRVCTL utility as follows.

srvctl add instance -db MSDBDG -instance MSDBDG3 -node msdbadm03

[MSDBDG1 izmir]/u01/app/oracle/product/19.0.0/dbhome_1/bin $ ./srvctl add instance -db MSDBDG -instance MSDBDG3 -node msdbadm03

Now try to startup this instance again as follows.

SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2.1445E+11 bytes
Fixed Size 30145368 bytes
Variable Size 9.7174E+10 bytes
Database Buffers 1.1704E+11 bytes
Redo Buffers 207720448 bytes
Database mounted.
SQL> 
SQL> 
SQL> show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name           string
cell_offloadgroup_name     string
db_file_name_convert       string
db_name string             MSDB
db_unique_name string      MSDBDG
global_names boolean FALSE
instance_name string      MSDBDG3
lock_name_space           string
log_file_name_convert     string
pdb_file_name_convert     string

PRCR-1064 : Failed to start resource ora.asm on node

If you got for the ASM Instance , Manually starting ASM instance on node 4,  it failed with below errors:

$ srvctl start asm -n <rachost4>
PRCR-1013 : Failed to start resource ora.asm
PRCR-1064 : Failed to start resource ora.asm on node <rachost4>
CRS-2552: There are no available instances of resource 'ora.asm' to start

$ srvctl modify asm -count 4

$ srvctl modify asm -count ALL

Do you want to learn more details about SRVCTL, then Click this Link and read the articles.

What is the SRVCTL and Useful SRVCTL Commands in Oracle RAC