Oracle monitor failing after plugin update

[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

[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?

[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

[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$

[brucej543]

Made the change to the commands and waiting for the DBA to unlock the account again. I will update when this is done

[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.

[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.