International conference dial-in numbers

USA: +1-719-867-0497
Canada, Montreal : +1 514 669 5945
Canada, Toronto : +1 647 426 9171
Canada, Vancouver : +1 604 221 6522
Argentina (toll free) : 0800 666 3182
Australia (toll free) : 1 800 214 647
Australia, Brisbane : +61 (0) 7 3015 0533
Australia, Melbourne : +61 (0) 3 8687 0565
Australia, Sydney : +61 (0) 2 8017 6235
Austria (toll free) : 0800 8866 3425
Austria, Vienna : +43 (0) 1 25302 1798
Bahrain (toll free) : 800 81107
Bahrain, Manama : +973 1619 8737
Belarus (toll free) : 8 820 0011 0348
Belgium (toll free) : 0800 39624
Belgium, Brussels : +32 (0) 2 400 1997
Brazil, Rio de Janeiro : +55 21 2730 6947
Brazil, Sao Paulo : +55 11 5582 6535
Bulgaria (toll free) : 00800 111 4990
Bulgaria, Sofia : +359 (0) 2 491 6043
Chile (toll free) : 123 0020 9731
China (national) : +400 613 8106
China, Beijing : +86 10 5667 0009
China, Shanghai : +86 21 2039 7090
Colombia (toll free) : 01 800 518 0793
Croatia (toll free) : 0800 7748
Cyprus (toll free) : 800 97427
Czech Republic (toll free) : 800 701 542
Czech Republic, Prague : +420 225 986 555
Denmark (toll free) : 80 70 35 97
Denmark, Copenhagen : +45 32 72 78 23
Egypt (toll free) : 0800 000 0594
Estonia (toll free) : 800 011 1581
Estonia, Tallinn : +372 622 6552
Finland (toll free) : 0800 772 246
Finland, Helsinki : +358 (0) 9 2310 1538
France (national) : 0811 655 117
France (toll free) : 0800 947 302
France, Paris : +33 (0) 1 70 37 16 79
Germany (national) : 01801 001 361
Germany (toll free) : 0800 588 9168
Germany, Frankfurt : +49 (0) 69 2222 13418
Germany, Munich : +49 (0) 89 2030 31233
Greece (toll free) : 00800 128 823
Greece, Athens : +30 211 181 3854
Hong Kong : +852 3018 9113
Hong Kong (toll free) : 800 968 236
Hungary (toll free) : 068 002 0145
Hungary, Budapest : +36 1408 8876
Iceland (toll free) : 800 9838
India, Bangalore : +91 (0) 80 6127 6712
India, Chennai : +91 (0)44 6688 6063
India, Delhi : +91 (0) 11 6641 1383
India, Mumbai : +91 (0)22 6187 5037
Indonesia (toll free) : 001 803 016 2550
Ireland (national) : 1890 907 643
Ireland (toll free) : 1800 937 670
Ireland, Dublin : +353 (0) 1 526 9507
Israel (toll free) : 1809 25 1023
Israel, Tel Aviv : +972 (0)3 763 0522
Italy (toll free) : 800 148 218
Italy, Milan : +39 02 3600 8017
Italy, Rome : +39 06 8750 0691
Japan (mobile) : 0120 699 333
Japan (toll free) : 0120 613 811
Japan, Osaka : +81 (0) 6 4560 2409
Japan, Tokyo : +81 (0) 3 4588 9621
Kazakhstan (toll free) : 8800 333 7567
Latvia (toll free) : 8000 4478
Latvia, Riga : +371 6601 3628
Lithuania (toll free) : 8800 31564
Lithuania, Vilnius : +370 5205 5469
Luxembourg : +352 2088 1466
Luxembourg (toll free) : 800 24498
Malaysia (toll free) : 1 800 816 151
Malaysia,Kuala Lumpur : +60 (0) 3 7724 8009
Mexico (toll free) : 01 800 054 0372
Mexico, Mexico City : +52 55 4777 2366
Morocco (toll free) : 0800 091 305
Morocco, Casablanca : +212 (0) 520 48 0031
Netherlands (toll free) : 0800 023 1435
Netherlands, Amsterdam : +31 (0) 20 715 3984
New Zealand (toll free) : 0800 452 959
New Zealand, Auckland : +64 (0) 9 9291 828
New Zealand, Christchurch : +64 (0) 3 974 2600
New Zealand, Wellington : +64 (0) 4 909 4588
Norway (toll free) : 800 56094
Norway, Oslo : +47 21 00 48 41
Panama (toll free) : 00 800 226 5972
Peru (toll free) : 0800 55093
Philippines (toll free) : 1 800 111 013 98
Philippines, Manila : +63 (0)2 395 3428
Poland (toll free) : 00 800 121 4355
Poland, Warsaw : +48 22 295 3572
Portugal (toll free) : 800 788 164
Portugal, Lisbon : +351 2142 45174
Romania (toll free) : 0800 885 826
Romania, Bucharest : +40 (0)2 1529 3993
Russia (toll free) : 8 800 500 9282
Russia, Moscow : +7 495 646 1856
Singapore : +65 6622 1377
Singapore (toll free) : 800 616 3204
Slovakia (toll free) : 0800 606 326
Slovakia, Bratislava : +421 (0)2 3321 5492
Slovenia (toll free) : 0800 80032
Slovenia, Ljubljana : +386 1 600 8688
South Africa (toll free) : 0800 999 690
South Africa, Johannesburg : +27 (0)11 589 8322
South Korea (toll free) : 080 801 6897
South Korea, Seoul : +82 (0) 2 6007 0081
Spain (toll free) : 900 828 073
Spain, Barcelona : +34 93 800 1972
Spain, Madrid : +34 91 114 7294
Sweden (toll free) : 0200 123 800
Sweden, Stockholm : +46 (0) 8 5065 3967
Switzerland (toll free) : 0800 841 685
Switzerland, Geneva : +41 (0) 22 595 4840
Switzerland, Zurich : +41 (0) 44 580 7229
Taiwan (toll free) : 0800 666 592
Taiwan, Taipei : +886 (0) 2 2650 7328
Thailand (toll free) : 001 800 6136 1472
Turkey (toll free) : 00 800 4488 28089
Turkey, Istanbul : +90 212 375 50 51
UAE (toll free) : 8000 3570 2668
UK (03) : +44 (0)330 336 6004
UK (national) : 0844 581 8064
UK (national) : 0845 351 2800
UK (toll free) : 0800 358 6405
Ukraine (toll free) : 0800 500 892
Uruguay (toll free) : 0004 019 0192
USA /Canada (toll free) : 1-877-647-3411
Venezuela (toll free) : 0 800 100 8301
Vietnam (toll free) : 122 801 82

New Update for “OpsLogix Capacity Management Pack V1.0.0.98”

We are happy to announce a new update release V1.0.0.98 for our Capacity Management Pack.

This version of the Management Pack is upgrade compatible with the previous release (v1.0.0.67). If you have already purchased the Management Pack and have a valid support contract, you can login to the customer download area and download this version.

Version 1.0.0.98 contains following changes:

  • Fixed bug related to the empty data shown (a zero percentile or incorrect data) in the reports due to server original settings.
  • Various bug fixes related to the performance of retrieving data.

OMS and Oracle a great fit!

Important notice: This post is a working example of OMS and Oracle. Please note that as the OMS platform continues to be extended our solutions will be updated concurrently to reflect and support these coming changes. During the writing of this blog all features described here within are accurate and current. The described OpsLogix OMS extension Management Pack is, at present, available at no cost to all customers that already have an OpsLogix Oracle Management Pack License.

 

Here at OpsLogix we are always looking to integrate our products with the latest technologies. For SCOM this means that we have created a fantastic Oracle Management Pack that monitors your Oracle environment on any platform without any extra software installation on your Oracle boxes. Yes, that’s right, no extra software on your Oracle production servers is required. The Oracle Management Pack has been tried, tested and proven to work in multiple industry sectors, including Fortune 500 companies for the past 3 years. OMS (Operations Management Suite) is a brand new, exciting product created by Microsoft. For this reason, we decided to integrate it with our Oracle MP.

In this blog I will demonstrate how easy it is to collect all of your Oracle alert logs and analyze them using OMS.

Prerequisites

Before we begin, ensure that your infrastructure meets the prerequisites below:

  • A working SCOM 2012 R2 environment
  • Oracle server access (windows or Linux)
  • A OpsLogix Oracle Management Pack & license
  • The OpsLogix OMS Extension management Pack
  • A Microsoft account (Live, Hotmail and/or Office 365)

Setup the OMS account

The process of setting up the OMS account has already been outlined in the link below. Click the link and follow the “onboarding” instructions to set up your OMS account.


http://download.microsoft.com/download/3/7/E/37E21FFE-7E3B-4EB3-A0FE-A07E66ECB9F9/Microsoft_Operations_Management_Suite_Resources.pdf


Notice: You don’t have to pay for OMS. There is a free plan! The only restrictions are daily upload limits of 500 MB of data and a retention period of 7 days. However, for Oracle alerts or event analyzing it is a great place to begin. After you have followed the steps above you should have added your SCOM management group to OMS. Check this by opening the OMS dashboard, shown below, and select Overview -> Settings -> Connected Sources. You should see your management group listed alongside the number of servers and last data input.  


 
 

Setup the Oracle Monitoring

Below are the steps for setting up Oracle Monitoring. Please also read the installation guide included in the software package.

  1. Open as SCOM administrator the Operations manager Console and Import the “OpsLogix Oracle Management Pack” files included in the software package.
  2. Apply the Oracle License using the OpsLogix Licensing dashboard in the SCOM Operations management console.
  3. The next step is to add the Oracle instances you want to monitor. This you can do in the SCOM console using the OpsLogix Oracle configuration dashboard.

    Since the management pack only uses ODAC connections you only have to specify the connection parameters (IP,user, pwd etc.) to the Oracle instance so that NO other software needs to be installed (for example: the Oracle client) for this Oracle instance. You can add Oracle to Windows, Linux, Unix etc., provided you have the correct connection parameters.

  4. If you have successfully added the Oracle instance you should now see the monitoring being populated. You should wait until you see the Oracle instance’s state view.
  5. Oracle’s state view is active with a health state.  

Setup the OMS Oracle Monitoring

We are now going to enable the Oracle Alerts in OMS.

  1. Using the SCOM console, import the OpsLogix OMS Oracle extension management pack. (This is a separate download and not included in the Oracle MP software package.)
  2. By default, only the Oracle instances that are members of the SCOM group, “OpsLogix Oracle OMS group” are enabled to collect the alert logs.
  3. For every Oracle member in this group, configure the alert log monitoring by creating an extra view as described in the Oracle Management installation manual. This view will enable you to monitor the Oracle alert logs without having to have SYSDBA privileges. (You will, however, need a one-time SYSDBA account to create this view.)

Viewing the OMS Oracle Alert collection

The next step is to verify that the Oracle alerts are picked up by OMS.

  1. Open a web browser and go to : https://login.mms.microsoft.com/signin.aspx?ref=ms_mms.
  2. Login using the Microsoft account you created in the “Setup the OMS account” section.
  3. The main OMS dashboard should appear. Select the “Log Search”.

     

  4. Now do a log search to retrieve all Oracle alert events. Type in the search box “Type=Event EventLog=Oracle”.

    The first time you do this you will probably see 0 events found.


  5. Now we can generate some test Oracle Alerts so OMS can collect them.

    Open an SQLPLUS connection to the Oracle instance you have configured to collect the alerts for and logon as SYSDBA. Type the following command to generate a test alert into the Oracle Alerts log:   exec dbms_system.ksdwrt(2, ‘ORA-00000 Test Event’);

  6. It could take up to five minutes for OMS to pick up this generated alert. If everything is working you will see an event in the log search.

    *Please note that this alert will NOT be visible in SCOM because we don’t store these alerts in the SCOM databases, remember that we are collecting ALL Oracle messages. If we did store these alerts the sheer volume of Oracle alert log messages could kill the performance and free space existing within the SCOM environment. That being said, the OMS environment is configured precisely to handle massive amounts of data without any problems!!  


  7. We can now see that our test events are collected in OMS. Now we should let OMS collect the test events for a couple of days so that we have some data to work on.

 
 

ORACLE OMS search query’s

Now it’s time to write OMS queries that we can use to help us analyze the Oracle alert logs. I have given you some examples below:

Description

QUERY

All Oracle Events

Type=Event EventLog=Oracle

All Oracle Events with only the message and time

Type=Event EventLog=Oracle | Select Source , TimeGenerated , RenderedDescription

All Oracle Events With the word Test in it

Type=Event EventLog=Oracle Test | Select Source , TimeGenerated , RenderedDescription

Count the number of messages that have test in it

Type=Event EventLog=Oracle Test | measure count() by Source

Count per oracle instance with the number of events with ORA ID 500 in it

Type=Event EventLog=Oracle EventID=500 | measure count() by Source

Group by ORA event ID and count

Type=Event EventLog=Oracle | measure count() by EventID

 
 

Another great resource on how to make queries OMS can be found here: https://azure.microsoft.com/nl-nl/documentation/articles/operational-insights-search/

Keep in mind that you can also use the Table view instead of the default List view. With some outputs it may be more user friendly to export and read the Table or List views in Excel.


 
 

I hope this post helps you discover for yourself the Power of OMS and Oracle together while using the OpsLogix Oracle Management Pack. Check back often, as I will be creating follow-up posts. I will be giving you examples of how to collect Oracle AUDITING events to OMS so that you can do security checks using OMS!  

(If you are interested in more OMS details, you can follow my blog. Touching SCOM – Michel Kamp )

Thanks,

Michel Kamp