[Infiniflux] Install and setup Infiniflux(Iflux) Database (Infiniflux DB 설치)

1. Setup OS Parameters

# set the maximum number of files
ulimit -Sn
sudo vi /etc/security/limits.conf

# Reboot
#> su - 
$> init 6

#  Check maximum number of files
$> ulimit -Sn

2. Install Packages

# Download RPM Package
$> wget http://www.infiniflux.com/dist/infiniflux-std-3.0.1.8813.official-LINUX-X86-64-release.rpm

# Install RPM Package
$> sudo yum localinstall infiniflux-std-3.0.1.8813.official-LINUX-X86-64-release.rpm

# List installed package up
#> ls -al /opt/ | grep infiniflux
#> ls -al /opt/infiniflux/
#> ls -al /opt/infiniflux/versions/3.0.1

# Setup Enviroment
#> vi .bashrc

3. Start Database

# Command
# service ifluxd {start|stop|kill|restart|createdb|destorydb|check|IWA|console|port|exe|collector|help}

# Start DB
#> sudo service ifluxd start

# Check or change port
#> sudo service ifluxd port

[Oracle] How to check Archive Log Mode (아카이브 로그 모드 확인)

Online Archive log check

------------------------------------------------------------------------------
-- Redo Log Group, Member Information
--
-- CURRENT  : LGWR Process is in use
-- ACTIVE   : LGWR Process is not in use. But Recover is necessary
              because of transaction spending long time
-- INACTIVE : LGWR Process is not in use and Recovery is not necessary
------------------------------------------------------------------------------
SELECT GROUP#
     , MEMBERS
     , BYTES
     , ARCHIVED
     , STATUS
FROM V$LOG;

------------------------------
-- Redo Log File Information
------------------------------
SELECT GROUP#
    ,  STATUS
    ,  MEMBER
FROM V$LOGFILE;

[Linux] Add sudo user (Sudo 사용자 추가)

[Windows] Offline genuine product certification (오프라인 정품인증)