Hi All,
Need your inputs on below issue. We install the Oracle DB monitoring pack on Oracle Linux 9 poller. The issue is the plugin works normally on root user but not on centreon-engine account.
Tried to re-compile the perl DBD::Oracle module but still the same issue.
Followed the docs - centreon docs
droot@pollerOEL9 DBD-Oracle-1.83]# /usr/lib/centreon/plugins/centreon_oracle.pl --plugin=database::oracle::plugin --hostname='10.236.96.223' --port='1521' --servicename='' --sid='GOJDA12P' --mode='tnsping'
OK: Connection established to listener 'GOJDA12P'.
centreon-engine@pollerOEL9 ~]$ /usr/lib/centreon/plugins/centreon_oracle.pl --plugin=database::oracle::plugin --hostname='10.236.96.223' --port='1521' --servicename='' --sid='GOJDA12P' --mode='tnsping'
CRITICAL: Cannot connect: install_driver(Oracle) failed: Can't locate loadable object for module DBD::Oracle in @INC (@INC contains: /usr/lib/centreon/plugins FatPacked::94888255245912=HASH(0x564ce4bf4e58) /usr/local/lib64/perl5/5.32 /usr/local/share/perl5/5.32 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at (eval 28) line 3.
Compilation failed in require at (eval 28) line 3.
Perhaps a module that DBD::Oracle requires hasn't been fully installed
at /usr/lib/centreon/plugins/centreon_oracle.pl line 11079.Already installed the oracle instant and perl library for Oracle
- oracle-instantclient-basic
- oracle-instantclient-sqlplus
- oracle-instantclientdevel
droot@pollerOEL9~]# rpm -qa | grep -i oracle
oracle-logos-90.2-1.0.2.el9.x86_64
oracle-logos-90.2-1.0.4.el9.x86_64
oraclelinux-release-9.4-1.0.6.el9.x86_64
oraclelinux-release-el9-1.0-15.el9.x86_64
oracle-logos-httpd-90.2-1.0.4.el9.noarch
centreon-plugin-Applications-Oracle-Ovm-Api-20240411-123504.el9.noarch
centreon-plugin-Applications-Oracle-Ucp-Jmx-20240411-123504.el9.noarch
centreon-plugin-Applications-Oracle-Goldengate-Ssh-20240411-123504.el9.noarch
centreon-plugin-Network-Oracle-Infiniband-Snmp-20240411-123504.el9.noarch
centreon-plugin-Network-Oracle-Otd-Snmp-20240411-123504.el9.noarch
centreon-plugin-Hardware-Storage-Oracle-Zs-Restapi-20240411-123504.el9.noarch
centreon-plugin-Hardware-Storage-Oracle-Zs-Snmp-20240411-123504.el9.noarch
centreon-plugin-Applications-Databases-Oracle-20240613-153121.el9.noarch
oracle-instantclient-basic-21.12.0.0.0-1.x86_64
oracle-instantclient-devel-21.12.0.0.0-1.x86_64
oracle-instantclient-sqlplus-21.12.0.0.0-1.x86_64
perl library for Oracle
/usr/local/lib64/perl5/5.32/DBD/Oracle
/usr/local/lib64/perl5/5.32/DBD/Oracle.pm
/usr/local/lib64/perl5/5.32/DBD/Oracle/GetInfo.pm
/usr/local/lib64/perl5/5.32/DBD/Oracle/Object.pm
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Aix.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Cygwin.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Hpux.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Linux.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Macos.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Sun.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Vms.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Win32.pod
/usr/local/lib64/perl5/5.32/DBD/Oracle/Troubleshooting/Win64.pod
/usr/local/lib64/perl5/5.32/auto/DBD/Oracle
/usr/local/lib64/perl5/5.32/auto/DBD/Oracle/.packlist
/usr/local/lib64/perl5/5.32/auto/DBD/Oracle/Oracle.h
/usr/local/lib64/perl5/5.32/auto/DBD/Oracle/Oracle.so
/usr/local/lib64/perl5/5.32/auto/DBD/Oracle/dbdimp.h
/usr/local/lib64/perl5/5.32/auto/DBD/Oracle/mk.pm
/usr/local/lib64/perl5/5.32/auto/DBD/Oracle/ocitrace.h
