This discussion is archived
8 Replies Latest reply: Jan 30, 2013 1:48 AM by Sebastian Solbach (DBA Community) RSS

DBSTART auto not working...

JCGO Newbie
Currently Being Moderated
I have used this note: 281912.1 for enabling auto start upon boot.....

environment is 2 node RAC with ASM....11.2.0.3 but for some reason, it doesnt work...
I dont see any error messages,......


any ideas?

thanks
  • 1. Re: DBSTART auto not working...
    Balazs Papp Expert
    Currently Being Moderated
    what happens if you run the scripts manually?

    anyway, why bother with this if you have Grid Infrastructure (11.2 RAC)?
  • 2. Re: DBSTART auto not working...
    JCGO Newbie
    Currently Being Moderated
    why bother with this?

    The DB does not start automatically after reboot....
    so i need to check to make sure they do
  • 3. Re: DBSTART auto not working...
    phaeus Pro
    Currently Being Moderated
    Hello,
    you are on the wrong way with node 281912.1.

    In a RAC System for example Linux the Grid Infrastruturce should spawn automaticly. If it starts successfully and the start requirements are meet it would start your databases as long they are registerd in the Cluster Layer as active ressource.

    So first you must check your cluster layer in a rac system. Also the log files in GRID_HOME/log.

    regards
    Peter
  • 4. Re: DBSTART auto not working...
    JCGO Newbie
    Currently Being Moderated
    Hi Peter


    SRVCTL reveals that server pool is already registered in Clusterware and also....
    Start Options: Open.


    Does that mean its enabled for restart?
  • 5. Re: DBSTART auto not working...
    phaeus Pro
    Currently Being Moderated
    Hello,
    first you should check is your cluster status. After reboot and the clusterware has started you should do
    [root@rac01 ~]# $GRID_HOME/bin/crsctl status res -t
    --------------------------------------------------------------------------------
    NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.DG_CLUSTER.dg
                   ONLINE  ONLINE       rac01                                        
                   ONLINE  ONLINE       rac02                                        
    All Reources have a status and also your db. TARGET and State is that what you should check.

    If you get a status then also check your registerd database.
    ora.TEST.db
          1        ONLINE  ONLINE       rac01                    Open                
          2        ONLINE  ONLINE       rac02                    Open                
    If your status is OFFLINE but the target is ONLINE check your logfiles
    If the command not work, check your cluster status and the logfiles.
    If your database is not listed as in the example check your registration

    Maybe you have not set the dependency diskgroups for a database, in that case it can fail because the database starts even the diskgroup is offline.

    Try to start with crsctl

    regards
    Peter
  • 6. Re: DBSTART auto not working...
    JCGO Newbie
    Currently Being Moderated
    Start options: open
    Stop options: immediate
    Database role: PRIMARY
    Management policy: AUTOMATIC
    Server pools: use1prod
    Database instances: use1prod1,use1prod2
    Disk Groups: DATA
    Mount point paths:
    Services:
    Type: RAC
    Database is administrator managed


    Above is from srvctl config command...

    Let me check the other output and post it here
  • 7. Re: DBSTART auto not working...
    JCGO Newbie
    Currently Being Moderated
    NAME TARGET STATE SERVER STATE_DETAILS
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.DATA.dg
    ONLINE ONLINE useqxdbx1p
    ONLINE ONLINE useqxdbx2p
    ora.FRA.dg
    ONLINE ONLINE useqxdbx1p
    ONLINE ONLINE useqxdbx2p
    ora.LISTENER.lsnr
    ONLINE ONLINE useqxdbx1p
    ONLINE ONLINE useqxdbx2p
    ora.OCR_VOTE_DG1.dg


    DB opn node 1, which is the one I am testing on says

    ora.use1prod.db
    1 OFFLINE OFFLINE Instance Shutdown
    2 ONLINE ONLINE useqxdbx2p Open
    ora.useqxdbx1p.vip
  • 8. Re: DBSTART auto not working...
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    the Oracle Grid Infrastructure remembers the status of the DB before the restart of the clusterware.
    Hence if you did a normal shutdown of the DB before you did restart the node, the GI will not start the instance.
    However if you simply did restart the node without shutting down the instance in advance, the instance would have been started.
    So everything works as expected. Just make sure, you don't shutdown the DB manually, and the cluster will take care to restart the DB in any case.

    You can see this on the "TARGET". If TARGET is OFFLINE, then the instance will not be started. If TARGET is ONLINE, it will be. The TARGET changed to offline, because you manually did shutdown the instance.

    Regards
    Sebastian

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points