ASM instance and DB instance not starting Automatically in Oracle 10gR2 RAC on Sun
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Clusterware starts the cluster resource so you must check CRS log files

  3. #3
    Join Date
    Apr 2006
    Posts
    23
    Try to start manually.
    srvctl start asm -n
    srvctl start database -d < db name > -n < node name >
    Then look for errors
    Regards

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote 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?

  5. #5
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    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
  •  


Click Here to Expand Forum to Full Width