How To Set


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
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.)
     Check zamong agent and server log together if you have problems.
6) To stop : ./zamongctl stop

2. Parameters in zamong.conf file


Directory path where the zamong_agent file is located.


IP address of zamong server


Port number used by zamong server


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.


AIX: 1 ,    LINUX: 2


If the version is Oracle,  Write 1120400


Execute query "select instance_name from v$instance"


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 ;


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


Directory path where the zamong server file is located.


Port number used by zamong server


IP address of Mariaydb or Mysql server


Username to connect to Mariaydb or Mysql


Mariadb or Mysql user password


Port number used by Mariadb or Mysql


Database name of Mariadb or Mysql


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.
key_buffer_size = 120M
sort_buffer_size = 16M
join_buffer_size = 10M
max_allowed_packet = 32M
concurrent_insert = 2

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

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 -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

define('__HOST__', '');
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)

require_once("config.php") ;

function _f_dbconn()
$conn = mysqli_connect(__HOST__, __USER__, __PASSWORD__ ,__DATABASE__ , __PORT__ );
// $conn = mysqli_connect(__HOST__, __USER__, __PASSWORD__ ,__DATABASE__ , 0 , __SOCKET__ );


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