Feeling lucky today?. Due to a feet operation I’m in recovery at home. So my mind was spinning to do something. I was always wondering why there wasn’t a ORACLE management pack for MOM. Of course you could buy one form Netiq example , but the complete version will have more overhead that you want (I tried it). No I want a FREE and simple one!.
Ok so you’re lucky, here’s the free oracle MP.
I’m NOT a oracle expert so there maybe missing some checks but it’s a start. If you give me some remarks then I have a look at it.
What does it for all oracle instances:
– it monitors the oracle alert files. And report the important ORA-xxx messages and oracle text messages. (last one disabled by default).
– it monitors oracle NT services state changes.
– it collects important performance counters from the instances. (v$ views)
– It monitors the free space on tablespaces. And report if below 25% free.
– Oracle instances discovery. Automatically finds all instances and SIDs in all homes.
To use all the monitor features you must do a little configuration on the oracle instances and the mp.
At the oracle servers:
1. Change the alertlogfile locations. (no shutdown required)
1) open the enterprise manager login to the instance under system sysdba
2) go to configuration -> all initialization parameters
3) Change the “background_dump_dest” to “c:oraclealertlogs” You can change this path but then you have also to change the MOM alert log file provider.
4) Then apply.
5) Do step 1 .. 4 for every instance you have running on any server.
Now all the alert logs are written to a standard location. This is needed because the
Path of the “MOM application log provider” cannot be dynamically configured.
2. Install the ORACLE ODBC driver and client tools (connectivity) on the oracle servers.
3. The performance and table space check use a oracle account to login. You specify this at the respond rules. I use the system user for this. But better is to create a special account for this. If you do be sure it can read the sys.v$ views and the tablespace table.
At the mom oracle mp:
Import the MOM ORACLE MP
change the user and passwords of the respond script of the rules:
[MITS] ORACLE [MITS] ORACLE CHECKS [MITS] Collect Oracle free tablespace info
[MITS] ORACLE [MITS] ORACLE PERFORMANCE V$ COLLECTIONS*
change the path of the “providers[MITS] oracle alert log files” provider to the location you have changed in step 1 “change the alertlogfile locations”
change or create more alert rules for notification.
do a commit.
What you will see at the operator console:
Open the mom operator console go to the “Alerts[MITS] Oracle” folder.
Open the mom operator console go to the “Performance[MITS] Oracle” folder.
There should me more views created but it’s a start.
Hope you enjoy this MP.
Download at : https://blogs.infosupport.com/files/folders/10895/download.aspx
Thanks for sharing it.
why does i have to install “2. Install the ORACLE ODBC driver and client tools (connectivity) on the oracle servers.” on the Oracle Servers? Did you mean the MOM Management-Servers?
The Scripts will run on the Agent (so the oracle servers) and it uses an Oracle ODBC connection to query. So you must have installed this step 2. By default ODBC drivers will be installed but the client tools are’nt. You can check it by making a new ODBC connection with the windows ODBC tool in your control pannel local on your oracle server. If the ‘test’ is succesfull its ok.
I’m getting this error in Event Viewer of the servers with Oracle.
Event ID: 9100
An error occurred on line 119 while executing script ‘[MITS] Oracle v$ prefcounter collection ‘
Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener
Have any idea what causes this error?
I forget to say that i have installed your oracle management pack 🙂
And the error above is from one of the scripts of the management pack.
This has something to do with the TSN connection string. It seems that your Oracle service name has a different Listner name. Complex story but I have the fix but not right now. BTW. In a couple of weeks I wil post a revision of the Oracle Management pack for SCOM2007.