-
ASM instance and DB instance not starting Automatically in Oracle 10gR2 RAC on Sun
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
-
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
Regards
-
Originally Posted by mahsnj
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?
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|