8 Replies Latest reply: Jan 30, 2013 3:48 AM by Sebastian Solbach -Dba Community-Oracle RSS

    DBSTART auto not working...

    Jcgo-Oracle
      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
          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-Oracle
            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
              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-Oracle
                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
                  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-Oracle
                    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-Oracle
                      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-Oracle
                        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