Page 1 of 1
Oracle monitor failing after plugin update
Posted: Thu Aug 08, 2019 6:48 am
by brucej543
Just updated to 5.6.5 and updated Components and Wizards. After update ALL Oracle Monitor agents are in error status with ORS-28000: the account is locked (DBD ERROR: OCI SessionBegin). The three oracle wizards that were updated: oracle_query, oracle_tablespace and oracle_serverspace. System profile attached
Re: Oracle monitor failing after plugin update
Posted: Thu Aug 08, 2019 9:54 am
by mbellerue
Thank you for providing the profile, I will look into it right away. For now, the error message states that the account is locked. Can you verify that the Oracle account specified for monitoring is working as expected, or unlock it if it is indeed locked?
Re: Oracle monitor failing after plugin update
Posted: Thu Aug 08, 2019 11:03 am
by brucej543
Had the DBA check the account and it was locked, He unlocked the account and then went to invalid username/password, DBA verified password and now the went back to account is locked status
Re: Oracle monitor failing after plugin update
Posted: Thu Aug 08, 2019 11:30 am
by mbellerue
Let's try rolling back the change that was made. I think the command is breaking with the added single quotes.
If you go to Configure -> Core Config Manager -> Commands, and search for check_xi_oracle, that should bring up the 3 Oracle commands. They currently look like this,
Code: Select all
/bin/bash -c 'source /usr/local/nagiosxi/etc/configwizards/oracle/oracle && $USER1$/check_oracle_health $ARG1$'
Try changing them to this,
Code: Select all
source /usr/local/nagiosxi/etc/configwizards/oracle/oracle && $USER1$/check_oracle_health $ARG1$
Re: Oracle monitor failing after plugin update
Posted: Thu Aug 08, 2019 11:42 am
by brucej543
Made the change to the commands and waiting for the DBA to unlock the account again. I will update when this is done
Re: Oracle monitor failing after plugin update
Posted: Thu Aug 08, 2019 12:12 pm
by brucej543
DBA unlocked account and the service alerts are working correctly now.
Thank you for your assistance in correcting the issue.
You may want to pull back the plugins updates or correct them.
Re: Oracle monitor failing after plugin update
Posted: Thu Aug 08, 2019 12:13 pm
by mbellerue
Excellent, good to know this worked for you. I will get this info out, and see what we can do for a fix to the wizards. Closing thread.