How To Set

ZAMONG AGENT > Setup

If you have any problems with setting up zamong, Please email us.
For table descriptions used by zamong, see this link.

1. Installation procedure

1) Download a zamong_agent file
2) Extract like 'tar xvf aix_zamong_agent_xxxxxx.tar '
3) Edit zamong.conf and set ORACLE_SID you want to monitor in user profile.
4) Don't set the oralce site profile (glogin.sql, login.sql) in $ORACLE_HOME/sqlplus/admin directory.
     If you do, you may get an error like 'error: get env'. zamong agent program checks it only when it starts.
5) Run ./zamongctl start      (Zamong zagent must be executed by oracle background process owner.)
     echo $ORACLE_SID.   Check zamong agent and server log together if you have problem.
6) To stop : ./zamongctl stop

2. Parameters in zamong.conf file

home_dir

Directory path where the zamong_agent file is located.

collector_ip

IP address of zamong server

collector_port

Port number used by zamong server

db_alias

Alias of instance_name. It is used for the zamong web page.
This alias is also used for table name prefix in Mariadb(Mysql).
The alias must be unique among all instances.

os_number

AIX: 1 ,    LINUX: 2

oracle_version_number

If the version is Oracle 11.2.0.4,  Write 1120400

instance_name

Execute query "select instance_name from v$instance"

db_name

Execute query "select name from v$database"

3. Check init parameter (Only in linux)


If OS is Linux, you should not use the memory_target parameter to use zamong agent.
You can use sga_target and pga_aggregate_target parameter instead. Refer to this example

how to check :    select name , value from v$parameter where name='memory_target' ;
If value is 0,   memory_target is not set.
(for example) If memory_target is 4294967296 (4g), then

           alter system reset memory_target   scope=spfile ;
           alter system set sga_target=3g   scope=spfile ;
           alter system set pga_aggregate_target=1000m   scope=spfile ;
           shutdown immediate ;
           startup

ZAMONG SERVER > Setup

1. Installation procedure

1) Pre-requirements : Install Mariadb or Mysql
2) download zamong_server file
3) extract like 'tar zxvf zamong_server_xxx.tar.gz '
4) edit zamongserver.conf
5) grant privileges in Mariadb
6) run ./zamongsvrctl start     
        Zamong server will check if a db connection is available when the process starts.
        If shared library error occurs, please set LD_LIBRARY_PATH. refer to this link
        You can check the log file for errors.
7) To stop : ./zamongsvrctl stop

2. Parameters in zamongserver.conf file

home_dir

Directory path where the zamong server file is located.

zamong_listen_port

Port number used by zamong server

db_server_ip

IP address of Mariaydb or Mysql server

db_connect_user

Username to connect to Mariaydb or Mysql

string_for_connection

Mariadb or Mysql user password

db_connection_port

Port number used by Mariadb or Mysql

database_name

Database name of Mariadb or Mysql

table_check_interval

Seconds. Frequency of checking table. We normally set 180

Mariadb or Mysql Configuration

1. Configure my.cnf for Zamong

        Please refer to this link for Mariadb installation
        Zamong creates tables every day using myisam storage engine.
        For table descriptions used by zamong, see this link.
[mysqld]
key_buffer_size = 120M
sort_buffer_size = 16M
join_buffer_size = 10M
max_allowed_packet = 32M
concurrent_insert = 2
skip-name-resolve


Don't set these variables in my.cnf file.
# skip-host-cache
# skip-networking
# bind-address

You must set these variables in my.cnf file for zamong.
concurrent_insert = 2
max_allowed_packet = 32M
skip-name-resolve

2. Create Database and Grant Privileges

MariaDB [(none)]> create database zamong default character set ascii ;
MariaDB [(none)]> grant all privileges on zamong.* to 'mong'@'%' identified by 'z1mong' ;
MariaDB [(none)]> grant all privileges on zamong.* to 'mong'@'localhost' identified by 'z1mong' ;
MariaDB [(none)]> grant all privileges on zamong.* to 'mong'@'HOSTNAME' identified by 'z1mong' ;

MariaDB [(none)]> flush privileges ;
MariaDB [(none)]> exit ;

[ Please check if you can access Mariadb or Mysql ]
zamong@monitor:/home/zamong/zsvr> mysql -u mong -pz1mong -D zamong
zamong@monitor:/home/zamong/zsvr> mysql -u mong -pz1mong -D zamong -h 192.168.25.50 -P 3306
    there should be no spaces between '-p' and password.    ( If connection was failed, check the firewall )

ZAMONG Web UI(Dashboard) > Setup

1. Installation procedure

        Before you configure zamong web,  You must finish setup of apache http server, php and maraidb(mysql).

1) download a zamong_web file
2) extract like 'tar zxvf zamong_web_xxx.tar.gz '
3) move zamong web source directory to Http Server DocumentRoot (ex: "/var/www/html" )
4) edit zamong/config.php ( mariadb(mysql) connection infomation ). edit connectdb.php file.
5) open chrome web browser and enter the following URL : 'http://http_server_ip_address/zamong'      
      Zamong Web Dashboard only supports the Chrome browser.
      To view sql text with multibyte language character sets such as chinese korean japanese, refer to this

2. config.php example

<?php
define('__HOST__', '127.0.0.1');
define('__DATABASE__', 'zamong') ;
define('__PORT__', 3306 );
define('__USER__', 'mong');
define('__PASSWORD__', 'z1mong');
// define('__SOCKET__', '/tmp/mysql.sock' );
?>

3. connectdb.php example (If you get an connection error, Change the location of "//" in the code below)

<?php
require_once("config.php") ;

function _f_dbconn()
{
$conn = mysqli_connect(__HOST__, __USER__, __PASSWORD__ ,__DATABASE__ , __PORT__ );
// $conn = mysqli_connect(__HOST__, __USER__, __PASSWORD__ ,__DATABASE__ , 0 , __SOCKET__ );
...........
}
?>

NETWORK CHECK

Zamong agent process must be able to connect to the zamong server process.

When zamong server starts, zamong server listens connection requests(tcp) from zamong agents.
You can modify zamongserver.conf file to change the port number.
So you need to open the port used by the zamong server in the firewall system.
And you need to open the port in Linux operating systems using firewall utility 'Iptables' service built for Linux operating systems(centos 5.x ~ 6.x).
In Centos 7.x, The default firewall system has changed.
CentOS 7, a firewall system called 'firewalld' was installed by default.

[example - iptables command for centos5.x ~ 6.x.    as root user]
1) iptables configuration for zamogn server
    iptables -A INPUT -p tcp -m tcp --dport 37750 -j ACCEPT
    service iptables save
    service iptables restart

2) iptables configuration for mariadb or mysql
    iptables -A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT
    service iptables save
    service iptables restart

3) iptables configuration for apatch http
    iptables -A INPUT -p tcp -m tcp --dport 80 -j ACCEPT
    service iptables save
    service iptables restart



[example - firewalld command for centos7.x]
1) stop firewalld
    systemctl stop firewalld

2) prevent the firewall from running when rebooting
    systemctl disable firewalld

3) open ports
    firewall-cmd --zone=public --add-port=3306/tcp --permanent
    firewall-cmd --zone=public --add-port=37750/tcp --permanent
    firewall-cmd --zone=public --add-port=80/tcp --permanent
    firewall-cmd --reload

4) check list of opened ports
    firewall-cmd --list-ports