4 Replies Latest reply: Feb 7, 2013 10:47 PM by 986120 RSS

    SRVCTL command not showing properly

    986120
      Dear experts,

      I have installed RAC 11gR2(11.2.0.1) successfully on RHEL 5.4 in my testing server.

      No. of Nodes : 2 (rac1,rac2)

      It is working fine. My database also running.

      RAC1:
      SQL> select instance_name, status from v$instance;
      INSTANCE_NAME STATUS
      -------------------------
      racdb1 OPEN
      RAC2:
      SQL> select instance_name, status from v$instance;
      INSTANCE_NAME STATUS
      -------------------------
      racdb2 OPEN
      But while am commanding the following it shows instance not running like this,
      [oracle@rac2 ~]$ srvctl status instance -d racdb -i racdb1,racdb2
      Instance racdb1 is not running on node rac1
      Instance racdb2 is not running on node rac2
      [oracle@rac2 ~]$
      [oracle@rac2 ~]$ srvctl status database -d racdb
      Instance racdb1 is not running on node rac1
      Instance racdb2 is not running on node rac2
      [oracle@rac2 ~]$
      Can anyone clarify the reason..

      --
      With thanks,
      Bala :)
        • 1. Re: SRVCTL command not showing properly
          Sebastian Solbach -Dba Community-Oracle
          Hi,

          maybe an error in 11.2.0.1. Try 11.2.0.3. and try again.

          Regards
          Sebastian
          • 2. Re: SRVCTL command not showing properly
            JohnWatson
            This is not unusual immediately after registering the database inthe OCR. Just do this,
            srvctl start database -d racdb
            of course it won't start anything because the instances are already up, but it will make the clusterware do a reality check.
            --
            John Watson
            http://skillbuilders.com
            • 3. Re: SRVCTL command not showing properly
              rcc50886
              lets do a sime test to understand :

              step1: shutdown the database on all nodes using SRVCTL
              srvctl stop database -d <db_unique_name> -o immediate
              step2: Startup the database using the sqlplus

              set env to database on node 1 and startup using the sqlplus

              sqlplus "/as sysdba"
              sql> startup;

              also open the second instance as well from second node.

              sqlplus "/as sysdba"
              sql> startup;

              step3: Now check the status using SRVCTL
              SRVCTL STATUS DATABASE -d <db_unique_name>
              now the status shows that database was not running on either nodes.
              because we didn't start the database with SRVCTL and eventhough database was open manually using sqlplus
              the cluster has no clue on it.

              So always use SRVCTl to staop/start the database in clusetr environment.

              -Thanks
              • 4. Re: SRVCTL command not showing properly
                986120
                @ john

                Thanks john now it's working and shows
                [oracle@rac1 ~]$ srvctl status database -d racdb
                Instance racdb1 is running on node rac1
                Instance racdb2 is running on node rac2
                [oracle@rac1 ~]$
                @ rcc50886

                I tried your idea too. Now it's working. and showing the same as above.


                Thanks,
                Bala:)