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

Login

Remember Me

Directory Tree

check_oracle_objects

Rating
0 votes
Favoured:
0
Hits
98267
Files:
FileDescription
check_oracle_objectscheck_oracle_objects
Nagios CSP

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Monitoring Made Magically Better

  • Nagios Core on Overdrive
  • Powerful Monitoring Dashboards
  • Time-Saving Configuration Wizards
  • Open Source Powered Monitoring On Steroids
  • And So Much More!
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}}