My company has asked me to monitor DBA script within SCOM. This has to run by a PowerShell script (triggered from a SCOM machine) to a oracle database. The log file of the script has to be saved on a shared disk. Also I need to get a alerts or events in SCOM if an oracle database gets under a certain limit (<10% disk space)
I haven’t found any information as of yet to monitor this. Is this even possible?
would it be sufficient if we use SCOM to check the log file? Unless it is binary or encrypted we can check the content if it matches a specific pattern or if it contains some key words in a specified order.
We also could just check if the log file is current (last write time) or the size …
Regards to the Oracle DBs; we could check file or folder size and set it to relation of the disk where there are stored.
It might be possible to solve your requirement without really ‘touching’ Oracle.
If you need further ideas or support let us know. 😉
in this case perhaps this will work
- Extend the PowerShell script to write events into the Windows Eventlog
- Use SCOM to monitor the Eventlog of the machine that runs the PowerShell script
Here two URLs:
Please let me know if this could work or if you need more ideas / support.
DId you find any solution for your requirement?
to better explain the problem it could help if you could provide a simple diagram of the environment to see where what runs at the moment. – Free layouts can be done with draw.io https://www.draw.io/
Also it may help if you could post that script.
Why did the solution approach with the ‘event detection’ did not work out for you?