Node 2 startup issue
We are running 2 node RAC 11.2.0.3 on ODA
For one of the databases the node 2 database was not starting up and following message was displayed
I was not able to start the node 2 using sqlplus either, then noticed that the db_reco_dest_size was diferent in node 1 & node 2, so I changed the value in node 2 to be same as node 1 and started using sqlplus, the database came up fine. Then I shutdown the database and tried to bring up using srvctl.
For one of the databases the node 2 database was not starting up and following message was displayed
> srvctl start instance -d rmstst -i rmstst2
PRCR-1013 : Failed to start resource ora.rmstst.db
PRCR-1064 : Failed to start resource ora.rmstst.db on node saodah92
CRS-2800: Cannot start resource 'ora.asm' as it is already in the INTERMEDIATE state on server 'saodah92'
I was not able to start the node 2 using sqlplus either, then noticed that the db_reco_dest_size was diferent in node 1 & node 2, so I changed the value in node 2 to be same as node 1 and started using sqlplus, the database came up fine. Then I shutdown the database and tried to bring up using srvctl.
0