Nagios Support Forum

Hello Team,

Is there any plugin available to throw critical alert when the user oracle on server xyz is locked? Server is solaris 10.

I'm not aware of any and didn't find anything with a quick search of the exchange so it looks like one would need to be written. Some helpful guides:

http://nagios-plugins.org/doc/guidelines.html​
https://assets.nagios.com/downloads/nag ... napi.html​
https://exchange.nagios.org/directory/T ... ipt/detail
https://library.nagios.com/library/prod ... s-in-perl/

You mean like this?
(from consol labs if I'm allowed to note that)

./check_oracle_health --help
Copyright (c) 2008 Gerhard Lausser

Check various parameters of Oracle databases

--mode
the mode of the plugin. select one of the following keywords:
tnsping (Check the reachability of the server)
connection-time (Time to connect to the server)
password-expiration (Check the password expiry date for users)

Command definition:
/usr/bin/env TNS_ADMIN=/home/nagios LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect $_HOST_ORACLE_CONNECT$ --username $_HOST_ORACLE_USERNAME$ --password $_HOST_ORACLE_PASSWORD$ --mode $ARG1$ --warning $ARG2$ --critical $ARG3$ $ARG4$ $ARG5$

Service Def... uses the command

$ARG1$ = password-expiration
$ARG2$ = 14:
$ARG3$ = 2:
$ARG4$ = --name 'Some Regex to match name'
$ARG5$ = --regex
$ARG6$ = --noperfdata

Warning if account will expire in 14 days or less
Critical if account will expire is 2 days or less

At least this is what I do. Works great. You can figure out the rest...

Steve B

@aditya.c.anand, does the password-expiration option pointed out by @SteveBeauchemin do what you need?