Home Directory Plugins Databases Oracle check_oracle_objects

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com


Remember Me


0 votes

Help Support Ethan Galstad's New Project:

Help Support Ethan

A Message From The Founder...

As the founder of Nagios, I'm asking for your help in a cause that's dear to my heart.

I'm launching a new project to help better the world by providing the information, ideas, and inspiration that I believe can improve the lives of people everywhere.

I know you're busy managing networks, but I would appreciate it if you would consider liking my Facebook page and showing your support for the content and messages I produce by sharing them with your friends and family.

You can learn more about my project by visiting ethangalstad.me/nagios. Thank you for your time. I wish you all the best in your endeavors, whatever they may be.

- Ethan

Perl script for checking the number of invalid objects in an Oracle database
Perl script for checking the number of invalid objects in an Oracle database
You can also retrieve the name and the owner of invalid objects

Example : Warn if any invalid objects is found, critical if the number exceed 50 :
{{check_oracle_objects -SID=TEST -dbuser=system -dbpassword=manager -w=0 -c=50
WARNING: 3 invalid object(s)}}

Example : same as previous example, and list all invalid objects :
{{check_oracle_objects -SID=TEST -dbuser=system -dbpassword=manager -w=0 -c=50 -detail=1
WARNING: 3 invalid object(s): SPACE.T_121 SPACE.T_663 SPACE.T_1067}}