Skip to main content

Oracle GoldenGate SSH

Monitoring Connector Assets​

Monitored Objects​

The Monitoring Connector includes monitoring of status and lags of Oracle GG Processes thanks to GGSCI command-line utility.

Collected Metrics​

Metric nameDescriptionUnit
process statusProcess status
processname#process.lag.secondsprocessus lag at checkpoint
processname#process.time.checkpoint.secondsprocessus time since checkpoint

Prerequisites​

The centreon-engine user performs a SSH connection to a remote system user. This user must have enough privileges to run ggsci command.

Setup​

  1. Install the Centreon Plugin on every Poller:
yum install centreon-plugin-Applications-Oracle-Goldengate-Ssh
  1. On the Centreon Web interface in Configuration > Monitoring Connector Manager, install the Oracle GoldenGate SSH Monitoring Connector

Configuration​

  • Add a new Host and apply the App-Oracle-Goldengate-SSH-custom Host Template

Once the template applied, some Macros have to be configured:

MandatoryNameDescription
GGSHOMEDirectory of ggsci
ORACLEHOMEOracle home directory

3 SSH backends are available to connect to the remote server: sshcli, plink and libssh which are detailed below.

MandatoryNameDescription
XSSHBACKENDName of the backend: sshcli
XSSHUSERNAMEBy default, it uses the user running process centengine on your Poller
SSHPASSWORDCannot be used with backend. Only ssh key authentication
SSHPORTBy default: 22
SSHEXTRAOPTIONSCustomize it with your own if needed. E.g.: --ssh-priv-key=/user/.ssh/id_rsa

With that backend, you have to validate the target server fingerprint manually (with the SSHUSERNAME used).

FAQ​

How to check in the CLI that the configuration is OK and what are the main options for ?​

Once the Plugin installed, log into your Poller using the centreon-engine user account and test by running the following command :

/usr/lib/centreon/plugins/centreon_oracle_gg_ssh.pl \
    --plugin=apps::oracle::gg::local::plugin \
    --mode=processes \
    --hostname=10.30.2.81 \
    --ssh-username=centreon \
    --ssh-password='centreon-password' \
    --ssh-backend=libssh \
    --filter-type=REPLICAT \
    --verbose

Which output something similar to:

CRITICAL: Process 'REPLICAT:RP_TS02' status: ABENDED | 'REPLICAT:RP_TSO1#process.lag.seconds'=0s;;;0; 'REPLICAT:RP_TSO1#process.time.checkpoint.seconds'=4s;;;0; 'REPLICAT:RP_TS02#process.lag.seconds'=172472s;;;0; 'REPLICAT:RP_TS02#process.time.checkpoint.seconds'=1462s;;;0; 'REPLICAT:RP_TS03#process.lag.seconds'=0s;;;0; 'REPLICAT:RP_TS03#process.time.checkpoint.seconds'=4s;;;0;
Process 'REPLICAT:RP_TSO1' status: RUNNING, lag: 0, time since checkpoint: 4s
Process 'REPLICAT:RP_TS02' status: ABENDED, lag: 1d 23h 54m 32s, time since checkpoint: 24m 22s
Process 'REPLICAT:RP_TS03' status: RUNNING, lag: 0, time since checkpoint: 4s

The command above gets the status of Oracle GoldenGate processes (--mode=processes). It uses a SSH username centreon (--ssh-username=centreon), a SSH password centreon-password (--ssh-password='centreon-password'), uses a SSH backend libssh (--ssh-backend='libssh') and it connects to the host 10.30.2.81 (--hostname=10.30.2.81) on the SSH default port 22 (--ssh-port=22).

All the options that can be used with this plugin can be found over the --help options:

/usr/lib/centreon/plugins/centreon_oracle_gg_ssh.pl \
    --plugin=apps::oracle::gg::local::plugin \
    --mode=processes \
    --help

I have that error message: UNKNOWN: Command error: Host key verification failed.. What does it mean ?​

It means you haven't manually validated the target server fingerprint with ssh or plink on the Centreon Poller.