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

It is an expected behavior in 12.2,with Oracle Flex ASM, you can consolidate all the storage requirements into a single set of disk groups. All these disk groups are mounted by and managed by a small set of Oracle ASM instances running in a single cluster.  Irrespective of number of nodes in the cluster, only three ASM instances will be created.

Modify the Oracle ASM instance count, or cardinality, with the SRVCTL modify asm command.

For example:

$ srvctl modify asm -count 4

$ srvctl modify asm -count ALL

 

Note: if you don’t have pre 12c databases configured in the cluster, no need to change the cardinality of ASM. Node 4 can still communicate with ASM even though ASM4 is not running.

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

 2,396 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply