yum install http://repo.unmanarc.com/CentOS/7/RPMS/x86_64/mod_bw-0.92-2.el7.centos.x86_64.rpm rpm -ql mod_bw sed -i 's@extramodules/mod_bw.so@modules/mod_bw.so@g' /etc/httpd/conf.d/mod_bw.conf systemctl restart httpd originated http://bitbull.ch/notes/post/bandwith-limitation-with-apache-on-centos-7/
How to remove sound from mov on Mac OS : ffmpeg
$ brew install ffmpeg --with-faac $ /usr/local/Cellar/ffmpeg/2.6.2/bin/ffmpeg -i input.mov -vcodec copy -an output.mov
centos7 : make mod_caucho.so
# cd /usr/local/src/resin-pro-4.0.44.src/ # ./configure # cd modules/c/src/ # make for dir in common resin_os resin resinssl; do (cd $dir; make); done make[1]: Entering directory `/usr/local/src/resin-pro-4.0.44.src/modules/c/src/common' gcc -c -I/usr/include -g -O2 -DEPOLL -D_POSIX_PTHREAD_SEMANTICS -DB64 -pthread -fPIC -fno-omit-frame-pointer -O2 -DHAS_SOCK_TIMEOUT -DHAS_SENDFILE -DHAS_SPLICE -DPOLL -DHAS_JVMTI -DLINUX -D_REENTRANT -D_GNU_SOURCE -pthread -lrt -pthread -DSHM stream.c .... […]
centos7 : Bandwith Limitation mod_bw
yum install http://repo.unmanarc.com/CentOS/7/RPMS/x86_64/mod_bw-0.92-2.el7.centos.x86_64.rpm rpm -ql mod_bw systemctl restart httpd
centos 7 : set hostname Hint
hostnamectl set-hostname myhostName hostname
centos 7 : xrdp install Hint
# rpm -Uvh https://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm # rpm -Uvh http://li.nux.ro/download/nux/dextop/el7/x86_64/nux-dextop-release-0-1.el7.nux.noarch.rpm # vi /etc/yum.repos.d/xrdp.repo [xrdp] name=xrdp baseurl=http://li.nux.ro/download/nux/dextop/el7/x86_64/ enabled=1 gpgcheck=0 # yum -y install xrdp tigervnc-server # systemctl start xrdp.service # netstat -antup | grep xrdp # systemctl enable xrdp.service
oracle : change charset test => csscan
$ sqlplus /nolog SQL> conn /as sysdba SQL> @/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/csminst.sql $ csscan $ csscan Character Set Scanner v2.2 : Release 11.2.0.1.0 - Production on 일 9월 13 23:11:54 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: derp Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With […]
centos 7 : systemctl oracle Hint
make oracle daemon file vi /etc/rc.d/init.d/oracle cd /etc/rc.d/init.d ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle ln -s ../init.d/oracle /etc/rc.d/rc4.d/S99oracle ln -s ../init.d/oracle /etc/rc.d/rc5.d/S99oracle ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle systemctl daemon-reload or reboot systemctl status oracle
oracle : set language and charset Hint SQLs
SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER in ('NLS_NCHAR_CHARACTERSET','NLS_CHARACTERSET','NLS_LANGUAGE'); select distinct(nls_charset_name(charsetid)) CHARACTERSET, decode(type#, 1, decode(charsetform, 1, 'VARCHAR2', 2, 'NVARCHAR2','UNKOWN'), 9, decode(charsetform, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKOWN'), 96, decode(charsetform, 1, 'CHAR', 2, 'NCHAR', 'UNKOWN'), 112, decode(charsetform, 1, 'CLOB', 2, 'NCLOB', 'UNKOWN')) TYPES_USED_IN from sys.col$ where charsetform in (1,2) and type# in (1, 9, 96, 112); SELECT […]