How to configure Oracle Parameters for PRODUCTION(ORACLE DC) in zabbix

 

Note:- Before configuring Oracle Parameter monitoring, we need to do background work in the proxy server which is one time installation.

 

For adding Oracle server in the zabbix we required below two:

1.      Oracle package installation in the proxy server which is one time installation.

2.      Oracle Username & Password & Oracle port no

 

Step1:-   Oracle package installation in the proxy server:

 

Download below three clients and install in proxy server.

Download Package

Download Package

Download Package

 

# yum install git

# git clone https://github.com/bicofino/Pyora.git

# yum install python-argparse.noarch

 

# unzip instantclient-basic-linux.x64-11.2.0.4.0.zip

# unzip instantclient-sdk-linux.x64-11.2.0.4.0.zip

# unzip instantclient-sqlplus-linux.x64-11.2.0.4.0.zip

 

# mv   instantclient_11_2   /usr/local/

 

#   vi /etc/profile                                        à  Add below line in the profile file.

export ORACLE_HOME=/usr/local/instantclient_11_2

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME

 

#  cd  /usr/local/instantclient_11_2

# ln -s libclntsh.so.11.1   libclntsh.so

#  vi /etc/ld.so.conf.d/oracle.conf                  à Add below line in the oracle.conf  file

/usr/local/instantclient_11_2

 

# yum install python-pip python-devel python –y

# pip install --upgrade setuptools

#  pip install --upgrade pip

#  yum install gcc make -y

#  yum -y install libaio bc flex -y

#  pip install cx_oracle

# cd /usr/lib/zabbix/externalscripts ( Note :-  Copy pyora.sh or pyora.py file in this path )

 

Step 2:-  Verification :

#  ./pyora.py --username root  --password  P@$$w0rd --address 192.168.178.110:1546 --database PROD activeusercount 

#  ./pyora.py --username root   --password  P@$$w0rd  --address 192.168.178.110:1546 --database PROD show_tablespaces

# ./pyora.py --username root  --password  P@$$w0rd  --address 192.168.178.110:1546  --database PROD tablespace SYSTEM

 

 

Step 3:-  Add the line below to the file /etc/zabbix_agentd.conf in central server.

#  vi   /etc/zabbix/zabbix_agentd.conf

UserParameter=pyora[*],/etc/zabbix/pyora.py --username $1 --password $2 --address $3 --database $4 $5 $6 $7 $8 

 

Step 4:-  Now at Zabbix front end:

{$ADDRESS}                 192.168.178.110:1546

{$DATABASE}              PROD

{$USERNAME}             root

{$PASSWORD}             P@$$w0rd

{$ARCHIVE}                 ARCHIVE

{$HIGH}                       90

 

 

Step 5:-   Cross check the data from the proxy server.

# zabbix_get -s 192.168.178.110 -k pyora[root, P@$$w0rd,192.168.178.110,PROD,version]

 

# zabbix_get -s 192.168.178.110 -k pyora[root, P@$$w0rd,192.168.178.110,PROD,query_temp]

 

 

PLEASE WRITE A FEEDBACK OR SUGGESTIONS TO BELOW EMAIL ID’S.

prashantkumar.chawan@gmail.com

info@mytara.co.in