7 Replies Latest reply: Jul 2, 2012 9:29 AM by Yoav RSS

    CELLCLI Changing alert threshould

    Yoav
      Hi,

      I am trying to change the threshold of CL_TEMP :
      CellCLI> list alertdefinition detail
      ....
               name:                   StatefulAlert_CL_TEMP
               alertShortName:         CL_TEMP
               alertSource:            Metric
               alertType:              Stateful
               description:            "Threshold Alert"
               metricName:             CL_TEMP
      I tried :
      CellCLI> alter threshold CL_TEMP comparison=">", critical=34
      CELL-02591: Threshold does not exist: CL_TEMP
      Any suggestion ?
      Thanks
        • 1. Re: CELLCLI Changing alert threshould
          Saurabh Gupta-OC
          try this:

          CellCLI> alter threshold CL_TEMP.<db_name> comparison=">", critical=34

          i.e.

          if db_name=proddb then

          CellCLI> alter threshold CL_TEMP.proddb comparison=">", critical=34

          Regards,
          Saurabh
          • 2. Re: CELLCLI Changing alert threshould
            Yoav
            Hi,
            Do you mean the database machine name or RDBMS db name ?
            Thanks
            • 3. Re: CELLCLI Changing alert threshould
              Yoav
              Hi,
              I tried database machine name and rdbms name and in bot cases it still failed :
              CellCLI> alter threshold CL_TEMP.dm01db01 comparison=">", critical=34
              
              CELL-02591: Threshold does not exist: CL_TEMP.dm01db01
              
              CellCLI> alter threshold CL_TEMP.psdwh comparison=">", critical=34
              
              CELL-02591: Threshold does not exist: CL_TEMP.psdwh
              Thanks
              • 4. Re: CELLCLI Changing alert threshould
                Andy Klock
                Hi Yoav. Tying this metric to a database probably isn't warrented since it is measuring the temperature of the CELL. If you don't have a threshold defined for this metric you may just have to create one yourself.
                CellCLI> list metricdefinition CL_TEMP detail
                         name:                   CL_TEMP
                         description:            "Temperature (Celsius) of the server, provided by the BMC"
                         metricType:             Instantaneous
                         objectType:             CELL
                         unit:                   C
                
                CellCLI> list metriccurrent CL_TEMP detail
                         name:                   CL_TEMP
                         alertState:             normal
                         collectionTime:         2012-06-28T16:03:28+00:00
                         metricObjectName:       xxxxxxxx_net0
                         metricType:             Instantaneous
                         metricValue:            24.0 C
                         objectType:             CELL
                
                CellCLI> list threshold
                
                CellCLI> describe threshold
                        name
                        comparison              modifiable
                        critical                modifiable
                        observation             modifiable
                        occurrences             modifiable
                        warning                 modifiable
                
                
                
                CellCLI> create threshold CL_TEMP.cl_threshold warning=30, critical=34,comparison='>'
                Threshold CL_TEMP.cl_threshold successfully created
                
                CellCLI> list threshold
                         CL_TEMP.cl_threshold
                
                CellCLI> list threshold where name = 'CL_TEMP.cl_threshold' detail
                         name:                   CL_TEMP.cl_threshold
                         comparison:             >
                         critical:               34.0
                         warning:                30.0
                
                CellCLI> drop threshold CL_TEMP.cl_threshold
                Threshold CL_TEMP.cl_threshold successfully dropped
                Note there is a related Bug 13359059 : THRESHOLD ON CL_TEMP METRIC ARE NOT WORKING, so you may want to check to see if that applies to your environment.
                • 5. Re: CELLCLI Changing alert threshould
                  Yoav
                  Hi Andy,
                  Thank your for your feedback.

                  I am getting an alert temperature from the exadata CELLs .
                  For example:
                   
                  Description The critical threshold for the following metric has been crossed. 
                  Metric Name CL_TEMP 
                  Metric Description Temperature (Celsius) of the server, provided by the BMC 
                  Object Name dm01cel01 
                  Current Value 33.0 C 
                  Threshold Value 32.0 C 
                  Thats shows that the Threshold is ALREADY exists and it set to 32.0 C and its current value is 33 C
                  All i want is to CHANGE the value from 32 to 34.
                  I dont wan to create new threshold as you suggested.

                  In my case:
                   
                  CellCLI> list metricdefinition CL_TEMP detail 
                           name:                   CL_TEMP 
                           description:            "Temperature (Celsius) of the server, provided by the BMC" 
                           metricType:             Instantaneous 
                           objectType:             CELL 
                           unit:                   C 
                  And:
                   
                  CellCLI> list metriccurrent CL_TEMP detail 
                           name:                   CL_TEMP 
                           alertState:             normal 
                           collectionTime:         2012-06-29T20:23:46+03:00 
                           metricObjectName:       dm01cel03 
                           metricType:             Instantaneous 
                           metricValue:            31.0 C 
                           objectType:             CELL 
                  But:
                   
                  
                  CellCLI> list threshold 
                  
                  CellCLI> list threshold where name = 'CL_TEMP' 
                  
                  CellCLI> 
                  So, whats wrong with the following command ?
                  list threshold --> Return nothing , but i showed above The CL_TEMP threshold exists and do alert me by email when the value of 32 has been crossed .
                   
                  CellCLI> alter threshold CL_TEMP comparison=">", critical=34 
                  CELL-02591: Threshold does not exist: CL_TEMP 
                  Thanks Again for you help
                  • 6. Re: CELLCLI Changing alert threshould
                    Andy Klock
                    Hi Yoav, I see what you mean. I'm not sure how or if you can alter those. I reviewed doc e13861 and poked about cellcli but nothing jumped out at me.
                    CellCLI> help alter cell
                    
                      Usage: ALTER CELL {
                          | SHUTDOWN SERVICES { RS | MS | CELLSRV | ALL }
                          | RESTART SERVICES { RS | MS | CELLSRV | ALL }
                          | RESTART BMC
                          | STARTUP SERVICES { RS | MS | CELLSRV | ALL }
                          | LED { ON | OFF }
                          | VALIDATE { MAIL | SNMP | CONFIGURATION }
                          | VALIDATE SYSLOGCONF facility.priority
                          | CONFIGUREBMC
                          | attribute_name = attribute_value  [, attribute_name = attribute_value]...
                    ALTER CELL CONFIGUREBMC looked like a possibility, but "list cell detail" provided only the following attributes:
                    name:                   
                    bbuTempThreshold:       
                    bbuChargeThreshold:     
                    bmcType:                
                    cellVersion:            
                    cpuCount:               
                    diagHistoryDays:        
                    fanCount:               
                    fanStatus:              
                    id:                     
                    interconnectCount:      
                    interconnect1:          
                    iormBoost:              
                    ipaddress1:             
                    kernelVersion:          
                    locatorLEDStatus:       
                    makeModel:              
                    metricHistoryDays:      
                    notificationMethod:     
                    notificationPolicy:     
                    offloadEfficiency:      
                    powerCount:             
                    powerStatus:            
                    releaseVersion:         
                    releaseTrackingBug:     
                    smtpFrom:               
                    smtpFromAddr:           
                    smtpPort:               
                    smtpServer:             
                    smtpToAddr:             
                    smtpUseSSL:             
                    snmpSubscriber:         
                                            
                                            
                                            
                    status:                 
                    temperatureReading:     
                    temperatureStatus:      
                    upTime:                 
                    cellsrvStatus:          
                    msStatus:               
                    rsStatus:               
                    So, not there.

                    Did you try the command that I posted previously about creating your own threshold? Possibly that one will take precedence, though I saw no such language in the usage notes, but you never know.

                    Otherwise I see two options:

                    1) Open an SR
                    2) Turn down the AC in your data center :)

                    Good luck.
                    • 7. Re: CELLCLI Changing alert threshould
                      Yoav
                      Hi Andy,
                      Did you try the command that I posted previously about creating your own threshold? Possibly that one will take precedence
                      I just tried the commands recommanded by you. I will wait few days and check which thresould is been used.
                      Thanks Again for your time.