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