Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
check_oracle_objects
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}}
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}}
Reviews (0)
Be the first to review this listing!