Systems Management (OpenView-OP Mgmt) Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Urgent Help - DBSPI Configuration

SOLVED
Go to Solution
Advisor

Urgent Help - DBSPI Configuration

Hello,

 

We are using OML 9.10 and have also deployed DBSPI 12.x.

Since, the default Deployed DBSPI policies were not providing expected results, we are currently re-configuring them.

 

So, we had copied all the required shipped DBSPI polices to a New group with New Names. Say, renamed DBSPI-0001 to xxx_DBSPI-0001, DBSPI-0206 to xxx_DBSPI-0206 etc ...

 

Also, few Polices have also been modified to alert for multiple thresholds.

For ex, we have added couple of rules under "xxx_DBSPI-0206 " , alerting for thresholds like 5% and 20%. (Not sure if we can add the rules manually to the monitor policies).

 

Similarly, the collector polices has been renamed from "DBSPI-Ora-15min-Favorites" to "DBSPI-Ora-20min-Favorites". Also, the command is updated with -t option (dbspicao -m 203,206,58,62,64-65,136,334 -x suffix=_en -t xxx_).

 

But the issue is that, we are not receving any alerts from DBSPI after these modifications.

What is the mistake that we have done here.

 

Need quick help on ths please.

 

Thanks

 

1 ACCEPTED SOLUTION
Honored Contributor Honored Contributor

Re: Urgent Help - DBSPI Configuration

Hi Dhina,

 

Good to hear that everything goes fine now.

Please mark the reply that fulfill you request as accepted solution to help other locate the solution easily.

Regards,
Mahmoud Ibrahim
http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • 14 REPLIES
    Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    The -t option looks correct, but I have never used the -x option.

     

    Since you are on OML 9, have you considered using the versioning capability instead of renaming the policies?  This would avoid the problem you have.

    Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    Hi Dhina,
    You have said that you renamed it from from "DBSPI-Ora-15min-Favorites" to "DBSPI-Ora-20min-Favorites".
    I think you meant "xxx_DBSPI-Ora-20min-Favorites".

    I think you have to add -c in your collector policy command
    dbspicao -c xxx_DBSPI-Ora-20min-Favorites -m 203,206,58,62,64-65,136,334 -x suffix=_en -t xxx_
    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Advisor

    Re: Urgent Help - DBSPI Configuration

    Hi Mahmoud,

     

    As suggested by you, we added the -c option for the collector, now it looks like what you recommended - dbspicao -c xxx_DBSPI-Ora-20min-Favorites -m 203,206,58,62,64-65,136,334 -x suffix=_en -t xxx_         

     

    But still no Luck.

     

    The collection seems to be happening, as checked the DBSPI Trace logs.

    But not sure, why the Alerts gets generated based on the thresholds defined in xxx_DBSPI-xxxx polices.

    (We have added few rules for multiple thresholds in these policies).

     

    We are also able to see DBSPI related Graphs in OVPM.

     

    Not sure where the issue is ?

     

    Any other options to validate this.

     

    Appreciate if anyone can help on this.

     

     

    Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    Hello again,
    So you enabled tracing, could you send it to me to analyse.

    Also check that agent is receiving opcmon alerts
    Try:
    opcmon xxx_DBSPI-XXXX=value

    replace xxx with the actual value and XXX with the metric number
    Ensure that the value is exceeding the threshold to receive a event in your OM console.
    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    Hi Dhina,

    You may follow the below steps in for troubleshooting:

    You decided to reduce a threshold value for a certain policy (Suppose DBSPI-0016 ) and to deploy it on a group of servers (SiteA)

    1- Open DBSPI-0016 policy and modify the following.
    a- Threshold value to match your need.
    b- in the automatic action add " -t siteA -" to the end of the DBSPI command.

    2- Save the policy as siteA-DBSPI-0016


    3- Create a copy of the Schedule Task policy located under "Ora-User Defined Metrics (Win)" in DBSPI policy group

    a- change the command to match your metric

    From:
    dbspicao -m 7XX -x suffix=_en
    to:
    dbspicao -m 16 -x suffix=_en -t siteA-

    b- Change the interval to match your need.

    c- refer the the online help to now the default intervals for each policy.

    e- save the policy and give it a new name as needed.

    4- Deploy both policies to the node.


    Note: in the example above I used "siteA-" to define the new DB group, you can use different names to match your implementation.

    This was part of my answer in the below thread.

    http://h30499.www3.hp.com/t5/Systems-Management-OpenView-OP/DBSPI-for-OMW/m-p/4780131/highlight/true
    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Advisor

    Re: Urgent Help - DBSPI Configuration

    Hello,

     

    Please find the trace log attached.

     

    We did try to run, opcmon LFG_DBSPI-0206=2, but no Alert got trigerred.

    Also tried LFG_DBSPI-0001=2, no luck.

     

    Actually, we have few Measurement threshold policies to monitor CPU/Mem, even they did not trigger alerts for opcmon commands.But i have never tried opcmon before, not sure, if the syntax is correct ?

    But yes, we are getting test alerts trigerred by opcmsg.

     

    One more thing that i would like to high-light is that, when we renamed the DBSPI Measurement thresold policies, and tried to save, it asked us to fill the ObjectName (as it said that its mandatory, while the shipped policy has no values mentioned for object-name. This was weird).so we put some static values like, Tablespace, DBStatus and saved the polices. Not sure, if this is having some impact.

     

    Do we have any specific docs for customizing DBSPI polciies for OML 9.10.

     

    Thanks.

     

    Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    Hi Dhina,
    I think the issue is in the object name, as this means that it will only display alerts that matches this object name
    Object name here matches the database name for example.

    See this example below from the trace file
    2012-02-21T17:30:01.246 Met_0058(2548): itoiface CLI: buffer=opcmon LFG_DBSPI-0058=78.137636 -object "DBSPTW03:db_recovery_file_dest" -option "dbname=DBSPTW03" -option "cli_threshold=-1" -option "local_threshold=-1.00" -option "adest=D:\oracle\product\10.2.0/flash_recovery_area"

    Look in this part:
    opcmon LFG_DBSPI-0058=78.137636 -object "DBSPTW03:db_recovery_file_dest"
    the object is a database index
    When opcmon send this message it will not match because you entered somthing diffrent in object field in your policy

    You have to use wild card in the name to match all the possible objects
    You may use <*> which represent asterisk in OM understanable pattern matching format.
    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Advisor

    Re: Urgent Help - DBSPI Configuration

    Hi Mahmoud,

     

    Yeah, you are correct.

    We changed the object name to <*>.

    Now, when we tried to send a Alert manually using opcmon, it was sucessful (we used "opcmon LFG_DBSPI-0206=15 -object "Test"  -option "dbname=DBSPTW03" -option "cli_threshold=-1" -option "local_threshold=-1.00" -option "tablespace_name=SYSAUX").

     

    But the Alert is not getting generated automatically now.

     

    Few of theTablespaces are above 95%, but we did not receive any alerts. (LFG_DBSPI-0206 has been customized for 3 conditions - 5%,10% and 20%).

     

    TABLESPACE_NAME     size MB     free MB % used

    USERS                  5           5      8

    UNDOTBS1             25          20     23

    SYSAUX              280          10     96

    SYSTEM              480           5     99

    TEMP  **TEMP**       20           0    100

     

    The trace logs says that it collecting the Data for this metrics -

    2012-02-21T17:30:04.990 Met_0206(2548): itoiface CLI: buffer=opcmon LFG_DBSPI-0206=99.175633 -object "DBSPTW03:SYSAUX"  -option "dbname=DBSPTW03" -option "cli_threshold=-1" -option "local_threshold=-1.00" -option "tablespace_name=SYSAUX"

     

    2012-02-21T17:30:04.072 Met_0206(2548): itoiface CLI: buffer=opcmon LFG_DBSPI-0206=98.551206 -object "DBSPTW03:SYSTEM"  -option "dbname=DBSPTW03" -option "cli_threshold=-1" -option "local_threshold=-1.00" -option "tablespace_name=SYSTEM"

     

    But not sure, if these are breaching the configured thresholds (<5%,<10% and < 20 %).

     

    Do we need to do something with the collector policy like changing "dbspicao -c LFG_DBSPI-Ora-14min-Favorites -m 203,206,58,62,64-65,136,334 -x suffix=_en -t LFG_" to somthing like "dbspicao -c LFG_DBSPI-Ora-14min-Favorites -m 203,206:5,206:10,206:20,58,62,64-65,136,334 -x suffix=_en -t LFG_"

     

    Awaiting for ur valuable inputs.

     

    Thanks

    Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    Hi Dhina,
    I think you are comparing to the value of 5, 10 and 20 while is seams from the log file it is a maximum value so you may configure them as 80, 90, and 95.
    Please do not include percentage in your values as it is not accepted in comparison.
    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Advisor

    Re: Urgent Help - DBSPI Configuration

    Hello,

     

    As you said, the Trace shows that the Values are shown on how much % it is utilized (Logs say it as 99.175633 & 98.551206).

    But if we look at the DBSPI-0206 policy, it by default has a threshold for <10%.

    So we had included rules for <5% and 20%.

     

    (This Default shipped policy was deployed to few of our DB servers, and they are sending alerts without issues).

     

    Now this is causing a bit of confusion. Not sure which is correct approch here.

     

     

    Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    Hello,
    You are right about minimum value and my answer is based on the trace analysis.

    Based on DBSPI Guides, It should check for mimimum value and this what you have configured and you said it is not working.

    Based on the trace log it send just the value of the % used not the free space.

     

    There is a note on the online help.


    The space metrics (3/203, 6/206 and 16/216) are very complicated and should be well understood before using or making changes to them.
    Please refer to the section titled 'Customizing Tablespace Metrics' in the 'Configuration Guide' for details.

     

    Regards,

    Mahmoud Ibrahim

     

    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Highlighted
    Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    [ Edited ]

     Hi,

    This is how it works:

     

     

    Metric 6 and Metric 206 - Percentage of Free Tablespace

     

    Metrics 006/206 calculates the percentage of available space in a tablespace as follows:

     

    1 It selects all non-temporary tablespaces from DBA_TABLESPACES, then calculates the amount of space available from

    DBA_FREE_SPACE as a sum(BLOCKS) from DBA_FREE_SPACE.

     

    2 It next calculates the space used by the data files as sum(BLOCKS) from DBA_DATA_FILES for the tablespace.

     

    3 If any of the data files have autoextend enabled

    (AUTOEXTENSIBLE = 'YES' from DBA_DATA_FILES),

    the total amount of space available within the file system where the data file resides is calculated:

    (total_fs_space (in BLOCKS))

     

    4 Now the maximum size allowed can be calculated for the data file ((MAXBLOCKS -

    BLOCKS)/INCREMENT_BY) * INCREMENT_BY from DBA_DATA_FILES) and the

    maximum file system space available to autoextend

    ((total_fs_space/INCREMENT_BY) * INCREMENT_BY).

    The lesser of the two values is used as the amount of file system space available: (fs_free_space).

     

    5 The ratio is then calculated as:

    Ratio=(sum_dbafree_space + fs_free_space)/(sum_dba_datafiles + fs_free_space) *100

    For metric 6, if the ratio is less than the command line threshold - count the tablespace in the alarm count. If no command line threshold is specified for 6, an internal threshold of 80 percent is used. For 206, the percentage is always sent to the agent to compare against the threshold.

     

    --- this is the data collected from your system

     

    get_vparm_value_ora_9: name=db_block_size  return_value_buffer=8192

    E0206_TblSpaceFreePctCnt: Fetching data
    Metric #0206: SQL = [select tablespace_name from dba_tablespaces ]
    ovam_get_ts_auto_extend: ts_name 'SYSAUX', autoextend '1'
    Starting get_fs_free_space for [SYSAUX]
    get_fs_free_space: SQL [SELECT a.file_name, (b.maxextend - a.blocks),b.inc FROM DBA_DATA_FILES a, SYS.FILEXT$ b WHERE a.tablespace_name=:buff AND a.file_id = b.file#; ]
    get_fs_free_space: Start fetching...
    get_fs_free_space: Start dbspi_arch_fsfree...
    dbspi_arch_fsfree: file='D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSPTW03\SYSAUX01.DBF' block_size='8192.000000'
    _fsCacheFindByPath: searching file system data cache for info about 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSPTW03\SYSAUX01.DBF'
    Looking for path: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSPTW03\SYSAUX01.DBF'; found 'D:'
    getDiskUsageInfo: using cached data for path 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSPTW03\SYSAUX01.DBF'
    mount point name='D:' free bytes='38641127424'
    returning mount point='D:' free blocks='4716934'


    file_system->mount_point_name= D:
    Number of free filesystem blocks=4716934.000000
    data_file.max_blocks=4158462.000000
    data_file.increment=1280.000000
    max_ora_blocks=4157440.000000
    max_fs_blocks=4716800.000000
    blocks_to_allocate=4157440.000000
    Data File D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSPTW03\SYSAUX01.DBF fs_space_block[0]=4157440.000000
    mp_index=1
    Tablespace_name=SYSAUX 
    sum_dba_freespace(blocks)=1272.000000
    sum_dba_datafiles(blocks)=35840.000000 
    sum_fs_space(blocks)=4157440
    db_block_size=8192.000000 

     ratio=99.175633

     

    ------

    So based on the above because Autoextend is enabled it calculate the total free space of the drive hosting this table space.

    That's why the value is 99.175633 as the database file may be fully written but the disk still has free space for this system to extend when needed so the free space is 99 percent so no alerts will be received when you configure threshold as 10 or 20 because the calculated value is not breaching those values.

     

     

    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • Advisor

    Re: Urgent Help - DBSPI Configuration

    Hi Mahmoud,

     

    Thanks a Lot for such a valuable explanation.

     

    Now, the AutoExtend feature of the Table spaces are made False, and we have started seeing alerts from DBSPI.

    Also, we have started seeing alerts for DB shutdown .. etc ..

     

    As you rightly said, the issue was with the "object Name" in the instance Filters, where we gave static values.

    Not its been given as <*> and, we are seeing expected results.

     

    Thanks a Lot Again.

    Honored Contributor Honored Contributor

    Re: Urgent Help - DBSPI Configuration

    Hi Dhina,

     

    Good to hear that everything goes fine now.

    Please mark the reply that fulfill you request as accepted solution to help other locate the solution easily.

    Regards,
    Mahmoud Ibrahim
    http://www.mahmoudthoughts.com
  • Say thanks by clicking the "Kudos! Star" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.