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


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 ;

4. Linux kernel parameter "shmmax" for test environment

If you want to create a test environment for zamong, We recommend that the "kernel.shmmax" parameter on linux oracle server is configured to the value that is guided in Oracle installation documentation.
           kernel.shmmax :    Half the size of physical memory in bytes
If linux oracle server uses default value of kernel.shmmax parameter, linux os allocates more smaller sga memory segments to oracle instance than the normal case. So zamong agent may not work with following error.

           20180103 14:30:11 start
           20180103 14:30:11 home_dir : /oracle/zamong
           20180103 14:30:14 complete stage 0
           20180103 14:30:14 complete stage 1
           20180103 14:30:14 internal error and exit

HOW TO MODIFY "kernel.shmmax"

Refer to this oracle document

     (1) Enter the command ' sbin/sysctl -a | grep shm ' to display the current values.
     (2) Modify kernel.shmmax value to half the size of physical memory in bytes.
           vi /etc/sysctl.conf
     (3) Enter the command ' /sbin/sysctl -p ' to change the current values of the kernel parameters.
           ( or /sbin/sysctl --system )
     (4) Enter the command ' /sbin/sysctl -a ' to confirm that the values are set correctly.
     (5) Restart oracle instance.


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__ );


If linux firewall service is enabled on zamong server, you need to check following :

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