Friday, February 12, 2016

Oracle RAC Instance not restarting automatically

Oracle RAC Instance not restarting automatically


Hi everybody,

we've got problems with 11.2 instances not restarting automatically. We've got a 2 node RAC, the Grid version is 11.2, 
but with 10.2 databases instances (asm instance in 11.2). All instances restart correctly so far. 
Recently, I created 2 new instances in version 11.2. Now when I restart the cluster, the 2 new instances (11.2) do not start automatically. 
Since I'm a newbie with rac, I don't find what's wrong. I've done some checks with srvctl, but since there's 2 oracle's home, I'm a bit confused.


Thanks for your suggestions.




Hi,


1. crsctl status res ora.orcl.db -p|grep -i AUTO_START
if result is "AUTO_START=never", execute step 3.  if result is restore: it behave in this way "Restores the resource to the same state that it was in when the server stopped". so you can still decided to change it to always.

2.  crsctl modify res ora.orcl.db -attr "AUTO_START=always"
srvctl modify database -d orcl -y automatic

Rgds
Satheesh



For the srvtctl I know that it must be started from the correct home. Satheesh, as you stated it, my AUTO_START was in "restore".
Since I shutdown both instances with srvctl before I restart the Linux cluster, the instances have stayed down. 


Thank you satheesh for solving my issue.


No comments: