Bug 2181358

Summary: nagios-plugins missng dbarch option - oracle
Product: [Fedora] Fedora EPEL Reporter: marcin.gregorczyk86
Component: nagios-pluginsAssignee: Guido Aulisi <guido.aulisi>
Status: NEW --- QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: unspecified    
Version: epel8CC: b.heden, guido.aulisi, herrold, igor.raits, lemenkov, smooge
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: ---
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description marcin.gregorczyk86 2023-03-23 20:15:17 UTC
Description of problem:
Version 2.3.3-4.el8 has dbarch option to check if archiver is working. 
--dbarch)
    archchk=`ps -ef | grep -v grep | grep -c "ora_arc.*_${2}"`
    if [ ${archchk} -ge 1 ] ; then
        echo "${2} OK - ${archchk} ARCH process(es) running"
        exit $STATE_OK
    else
        echo "${2} Archiver is not running"
        exit $STATE_CRITICAL
    fi
    ;;

version 2.3.3-6.el8 has no such function: 
[root@xxx ~]# /usr/lib64/nagios/plugins/check_oracle --dbarch xxx
Usage:
  check_oracle --tns <Oracle Sid or Hostname/IP address>
  check_oracle --db <ORACLE_SID>
  check_oracle --login <ORACLE_SID>
  check_oracle --connect <ORACLE_SID>
  check_oracle --cache <ORACLE_SID> <USER> <PASS> <CRITICAL> <WARNING>
  check_oracle --tablespace <ORACLE_SID> <USER> <PASS> <TABLESPACE> <CRITICAL> <WARNING>
  check_oracle --oranames <Hostname>
  check_oracle --help
  check_oracle --version
[root@aem1 ~]#



Version-Release number of selected component (if applicable):
nagios-plugins-oracle 2.3.3-6.el8

How reproducible:
update nagios-plugins-oracle 2.3.3-6.el8  and test if it is possible to check archiver is running. 

Steps to Reproduce:
1./usr/lib64/nagios/plugins/check_oracle --dbarch xxx
2.
3.

Actual results:
Usage:
  check_oracle --tns <Oracle Sid or Hostname/IP address>
  check_oracle --db <ORACLE_SID>
  check_oracle --login <ORACLE_SID>
  check_oracle --connect <ORACLE_SID>
  check_oracle --cache <ORACLE_SID> <USER> <PASS> <CRITICAL> <WARNING>
  check_oracle --tablespace <ORACLE_SID> <USER> <PASS> <TABLESPACE> <CRITICAL> <WARNING>
  check_oracle --oranames <Hostname>
  check_oracle --help
  check_oracle --version

Expected results:
[root@yyy db]# /usr/lib64/nagios/plugins/check_oracle --dbarch yyy
yyy OK - 4 ARCH process(es) running

Additional info: