User Lock issue

[aditya.c.anand]

Hello Team,

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

[cdienger]

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/

[SteveBeauchemin]

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

[cdienger]

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