ASM instance and DB instance not starting Automatically in Oracle 10gR2 RAC on Sun
After Server Reboot, my ASM instance on one Node and DB instances on both the nodes are not starting Automatically.
When i check crs_stat -t, it shows all the services except the above three to have started.
I also tried the entry of oracle sid and oracle home with FLAG=Y in /var/opt/oracle/oratab file for automatic DB instance startup, also created a dbora file for calling the $ORACLE_HOME/rdbms/admin/dbstart and dbshut during system startup.
Can anybody help me?
Clusterware starts the cluster resource so you must check CRS log files
Try to start manually.
srvctl start asm -n
srvctl start database -d < db name > -n < node name >
Then look for errors
Originally Posted by mahsnj
whats that got to do with starting the database automatically?
For ASM Auto Start:
srvctl modify instance -d epprod1 -i epprod11 -s +ASM1
Now you should be able to see asm instance name for the REQUIRED_RESOURCES parameter of the database instance of
crs_stat -p ora.epprod1.epprod11.inst | grep REQUIRED_RESOURCES
ASM started automatically after Server Reboot with CRS.
For Auto DB Restart:
We checked the crsd.log and instance log file generated after enabling more tracing as suggested by oracle.
The CRS was searching for spfile located in the ASM location "+DG_01/epprod1/spfileepprod1.ora" and both my instances were using pfile from local destinations i.e. "$ORACLE_HOME/dbs/init.ora"
We just created the spfile using following command:
SQL> create spfile='+DG_01/epprod1/spfileepprod1.ora' from pfile;
And Reboot the nodes and the DB instances came up automatically.
Thanks for all your help.
Click Here to Expand Forum to Full Width