ASM instance and DB instance not starting Automatically in Oracle 10gR2 RAC on Sun

[pareshjavkar]

Dear All,

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?

Thanks,
Paresh

[pando]

Clusterware starts the cluster resource so you must check CRS log files

[mahsnj]

Try to start manually.
srvctl start asm -n
srvctl start database -d < db name > -n < node name >
Then look for errors
Regards

[davey23uk]

Try to start manually.
srvctl start asm -n
srvctl start database -d < db name > -n < node name >
Then look for errors
Regards

whats that got to do with starting the database automatically?

[pareshjavkar]

Dear All,

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
node mumux112.

crs_stat -p ora.epprod1.epprod11.inst | grep REQUIRED_RESOURCES

REQUIRED_RESOURCES=ora.mumux112.vip ora.mumux112.ASM1.asm

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.

Regards,
Paresh