This discussion is archived
7 Replies Latest reply: Jul 2, 2012 7:29 AM by Yoav RSS

CELLCLI Changing alert threshould

Yoav Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi,
    Do you mean the database machine name or RDBMS db name ?
    Thanks
  • 3. Re: CELLCLI Changing alert threshould
    Yoav Newbie
    Currently Being Moderated
    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
    AndyKlock Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    AndyKlock Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

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