5 Replies Latest reply: Jun 29, 2012 8:28 AM by onedbguru RSS

    NTP(Network Time Protocol) Error whil installing Oracle 11gR2 RAC

    user8665771
      Dear Friends,

      I have installed oracle 11gr2 clusterware software in two node RAC. While i run the CLUVFY.SH, It shows error in NTP configuration.

      1)I add "-x" parameter in "/etc/sysconfig/ntp" configuration file. and start the ntpd service and run the cluvfy.sh . then i got the below error.

      Check: CTSS state
      Node Name State
      ------------------------------------ ------------------------
      rac2 Observer
      rac1 Observer
      CTSS is in Observer state. Switching over to clock synchronization checks using NTP


      Starting Clock synchronization checks using Network Time Protocol(NTP)...

      NTP Configuration file check started...
      The NTP configuration file "/etc/ntp.conf" is available on all nodes
      NTP Configuration file check passed

      Checking daemon liveness...

      Check: Liveness for "ntpd"
      Node Name Running?
      ------------------------------------ ------------------------
      rac2 no
      rac1 no
      Result: Liveness check failed for "ntpd"
      PRVF-5415 : Check to see if NTP daemon is running failed
      Result: Clock synchronization check using Network Time Protocol(NTP) failed


      PRVF-9652 : Cluster Time Synchronization Services check failed

      Post-check for cluster services setup was unsuccessful on all the nodes.

      =============================================================================================
      2)Down the ntpd service in both nodes and run the CLUVFY.SH.

      Check: CTSS state
      Node Name State
      ------------------------------------ ------------------------
      rac2 Observer
      rac1 Observer
      CTSS is in Observer state. Switching over to clock synchronization checks using NTP


      Starting Clock synchronization checks using Network Time Protocol(NTP)...

      NTP Configuration file check started...
      The NTP configuration file "/etc/ntp.conf" is available on all nodes
      NTP Configuration file check passed

      Checking daemon liveness...

      Check: Liveness for "ntpd"
      Node Name Running?
      ------------------------------------ ------------------------
      rac2 no
      rac1 yes
      Result: Liveness check failed for "ntpd"
      PRVF-5415 : Check to see if NTP daemon is running failed
      Result: Clock synchronization check using Network Time Protocol(NTP) failed


      PRVF-9652 : Cluster Time Synchronization Services check failed

      Post-check for cluster services setup was unsuccessful on all the nodes.

      ==========================================================================
      3)Based on some website advice, I down the ntpd service and move the "/etc/ntpd.conf" to another location.Then i got the below error.

      Result: Query of CTSS for time offset passed

      Check CTSS state started...
      Check: CTSS state
      Node Name State
      ------------------------------------ ------------------------
      rac2 Observer
      CTSS is in Observer state. Switching over to clock synchronization checks using NTP


      Starting Clock synchronization checks using Network Time Protocol(NTP)...

      NTP Configuration file check started...

      ERROR:
      PRVF-5402 : Warning: Could not find NTP configuration file "/etc/ntp.conf" on node "rac2"
      PRVF-5405 : The NTP configuration file "/etc/ntp.conf" does not exist on all nodes
      rac2
      PRVF-5414 : Check of NTP Config file failed on all nodes. Cannot proceed further for the NTP tests
      Result: Clock synchronization check using Network Time Protocol(NTP) failed


      PRVF-9652 : Cluster Time Synchronization Services check failed
      =============================================================


      What should i do to solve this issue?? Please help me ...
        • 1. Re: NTP(Network Time Protocol) Error whil installing Oracle 11gR2 RAC
          onedbguru
          You typically get this error because oracle cannot read the /etc/sysconfig/* files. Oracle in their infinite wisdom decided to retrieve this information from these system config files that are typically locked down so "normal" users can't see how the sys admin has things configured.

          add world read to the ntp* file on all nodes. also to limits.conf
          • 2. Re: NTP(Network Time Protocol) Error whil installing Oracle 11gR2 RAC
            anand prakash - oracle
            Hi,

            can you paste the output of

            ./cluvfy comp clocksync

            You can also have look at CTSSD Runs in Observer Mode Even Though No Time Sync Software is Running (Doc ID 1054006.1)


            Anand
            • 3. Re: NTP(Network Time Protocol) Error whil installing Oracle 11gR2 RAC
              user8665771
              Hi,

              Thanks for replying.

              Please share that how should i give permission to oracle user to read ntpd.conf in "limits.conf"


              Thanks in advance
              • 4. Re: NTP(Network Time Protocol) Error whil installing Oracle 11gR2 RAC
                user8665771
                Hi,

                I start the ntpd start the service in both node and done the CLUVFY.SH.

                The output is below,

                Checking if CTSS Resource is running on all nodes...
                Check: CTSS Resource running on all nodes
                Node Name Status
                ------------------------------------ ------------------------
                rac2 passed
                rac1 passed
                Result: CTSS resource check passed


                Querying CTSS for time offset on all nodes...
                Result: Query of CTSS for time offset passed

                Check CTSS state started...
                Check: CTSS state
                Node Name State
                ------------------------------------ ------------------------
                rac2 Observer
                rac1 Observer
                CTSS is in Observer state. Switching over to clock synchronization checks using NTP


                Starting Clock synchronization checks using Network Time Protocol(NTP)...

                NTP Configuration file check started...
                The NTP configuration file "/etc/ntp.conf" is available on all nodes
                NTP Configuration file check passed

                Checking daemon liveness...

                Check: Liveness for "ntpd"
                Node Name Running?
                ------------------------------------ ------------------------
                rac2 yes
                rac1 yes
                Result: Liveness check passed for "ntpd"

                Checking NTP daemon command line for slewing option "-x"
                Check: NTP daemon command line
                Node Name Slewing Option Set?
                ------------------------------------ ------------------------
                rac2 yes
                rac1 yes
                Result:
                NTP daemon slewing option check passed

                Checking NTP daemon's boot time configuration, in file "/etc/sysconfig/ntpd", for slewing option "-x"

                Check: NTP daemon's boot time configuration
                Node Name Slewing Option Set?
                ------------------------------------ ------------------------
                rac2 yes
                rac1 yes
                Result:
                NTP daemon's boot time configuration check for slewing option passed

                NTP common Time Server Check started...
                PRVF-5410 : Check of common NTP Time Server failed
                PRVF-5416 : Query of NTP daemon failed on all nodes

                Result: Clock synchronization check using Network Time Protocol(NTP) passed


                Oracle Cluster Time Synchronization Services check passed

                ========================================================================================


                [oracle@rac1 ~]$ /u01/app/grid/oracle/product/10.2.0/db_1/bin/cluvfy comp clocksync

                Verifying Clock Synchronization across the cluster nodes

                Checking if Clusterware is installed on all nodes...
                Check of Clusterware install passed

                Checking if CTSS Resource is running on all nodes...
                CTSS resource check passed


                Querying CTSS for time offset on all nodes...
                Query of CTSS for time offset passed

                Check CTSS state started...
                CTSS is in Observer state. Switching over to clock synchronization checks using NTP


                Starting Clock synchronization checks using Network Time Protocol(NTP)...

                NTP Configuration file check started...
                NTP Configuration file check passed

                Checking daemon liveness...
                Liveness check passed for "ntpd"

                NTP daemon slewing option check passed

                NTP daemon's boot time configuration check for slewing option passed

                NTP common Time Server Check started...
                PRVF-5410 : Check of common NTP Time Server failed
                PRVF-5416 : Query of NTP daemon failed on all nodes

                Clock synchronization check using Network Time Protocol(NTP) passed


                Oracle Cluster Time Synchronization Services check passed

                Verification of Clock Synchronization across the cluster nodes was successful.
                [oracle@rac1 ~]$

                ================================================================================

                I hope the problem solved. Am i correct??
                • 5. Re: NTP(Network Time Protocol) Error whil installing Oracle 11gR2 RAC
                  onedbguru
                  Looks good to me...

                  It took me a while to figure out that with some sys admins locking down /etc/sysconfig, that oracle could not find answers to it's config questions. typically in only needs to be world-readable during installation and node add/delete.