따분한일상

일단, Oracle Client의 user home에 쌓이는 로그는 삭제하여도 무방합니다.

Client에서 로그가 쌓이는 것을 막기 위해서는 아래 절차를 따르시면 됩니다.

 1. /etc/profile 파일에 아래 내용이 있는지 확인후 없으면 입력(source /etc/profile 명령어로 적용)

 export TNS_ADMIN=$ORACLE_HOME/network/admin

 2. 위 $ORACLE_HOME/network/admin 경로에 있는 sqlnet.ora 파일을 편집(없으면 생성)하여 아래 내용 입력

 DIAG_ADR_ENABLED=off

TRACE_LEVEL_CLIENT=off

LOG_FILE_CLIENT=/dev/null

Exchange 2010에서 네이버 메일로 변경 하기 위하여, 메일 계정 추출함

메일 계정과 DisplayName이 나옴

dsquery user | dsget user -samid -upn -acctexpires -desc -display -dn -expand -disabled -l

참고사이트 : http://forums.petri.com/showthread.php?t=7690#

MySQL Long 쿼리를 메일로 Alert 하여 내부 공유 하는 Script

[okayjava@oradb ~]$ cat /home/okayjava/bin/mysql_longquery_detector.sh

#!/bin/bash

#MySQL Long Query Detector Made by Okayjava

ymd=`date +"%Y%m%d"`

hm=`date +"%H%M"`

pid=`echo $$`

mailfile=/tmp/mysql_slowlog_$pid.txt

now_hm=`date +"%H%M"`

logfile=/www/com/log/batch/long_query_$ymd.log

while [ $hm -eq $now_hm ] 

do

#date  >> $logfile

/usr/bin/mysql -urcs -prcs123 -h192.168.1.250 << EOF  > $mailfile

use tvideo;

DROP TEMPORARY TABLE IF exists tmp_processlist;

CREATE TEMPORARY TABLE tmp_processlist

(

  SEQ bigint unsigned NOT NULL  AUTO_INCREMENT,

  ID bigint NOT NULL DEFAULT '0',

  USER varchar(16) NOT NULL DEFAULT '',

  HOST varchar(64) NOT NULL DEFAULT '',

  DB varchar(64) DEFAULT NULL,

  COMMAND varchar(16) NOT NULL DEFAULT '',

  TIME int NOT NULL DEFAULT '0',

  STATE varchar(64) DEFAULT NULL,

  INFO longtext,

  primary key (SEQ)

) engine='MyISAM' ;

# Between 을 이용하여, 수행 시간을 조절 한다.

insert into tmp_processlist ( ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO )

SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO

FROM   INFORMATION_SCHEMA.PROCESSLIST

WHERE  info IS NOT NULL 

 AND    INFO    NOT LIKE '%PROCESSLIST%'

 AND    (TIME BETWEEN 10 AND 20 

                 OR TIME BETWEEN 600 AND 610

                 OR TIME > 1800

                 )

;

set @maxleng = 1500000;

set @curdate = sysdate();

SELECT concat('\r\n user | ', user, '\r\n Host : ', Host,'\r\n DB : ', db, '\r\n esp. sec : ',time ,'\r\n', max(mmsStr ) ) as msg

FROM (

        SELECT *

        , Case When @curSeq <> curSeq Then

                        @str := concat ( '\r\n\r\n=======\r\n',SEQ ,'-', ID,'-',@curdate ,'\r\n=========\r\n' , info) 

                Else

                        @str := concat (@str ,'\r\n\=======\r\n',  SEQ ,'-', ID,'-',@curdate ,'\r\n=========\r\n' , info ) 

                End as mmsStr

        , @curSeq := curSeq

        FROM (

                        SELECT  SEQ,ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO 

                                , Case When @curSum + length(info) > @maxleng Then

                                                @curSeq := @curSeq + 1

                                        Else 

                                                @curSeq

                                        End as curSeq

                                , Case When @curSum + length(info) > @maxleng Then

                                                @curSum := length(info) 

                                        Else 

                                                @curSum := @curSum + length(info) 

                                        End as curSum

                        FROM tmp_processlist 

                        , (SELECT  @curSum := 0, @curSeq := 1 ) r

        ) as a 

         , (SELECT  @str := '' , @curSeq ) r

) fff

GROUP BY curSeq

HAVING max(length(mmsStr));

DROP TEMPORARY TABLE IF exists tmp_processlist;

EOF

if [ -s $mailfile ]

then

        cat $mailfile | /bin/mail -s "250 MySQL Server Long Query Detector" email1@aa.com,email2@aa.com -c cc1@aa.com, cc2@aa.com

fi

#rm $mailfile

sleep 10

now_hm=`date +"%H%M"`

done

서버 시간 설정

[root@web102 ~]# crontab -l

MAILTO=""

0 0 * * * /usr/bin/rdate -s time.bora.net && /sbin/clock -w

wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

sudo rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm

yum -y install apr*  openssl-devel libtermcap-devel ncurses-devel libxml* curl-devel libjpeg* libpng* freetype-devel  libmcrypt* libmhash mhash* pcre-devel lua-devel libxml2-devel ncurses-devel zlib zlib-devel curl libtermcap-devel libc-client-devel bison gcc g++ cpp gcc-c++ freetype freetype-devel freetype-utils gd gd-devel libjpeg libjpeg-devel libpng libpng-devel curl curl-devel flex php-mbstring lrzsz libexif-devel libtool

wget http://downloads.sourceforge.net/project/mcrypt/MCrypt/2.6.8/mcrypt-2.6.8.tar.gz

wget http://downloads.sourceforge.net/project/mcrypt/Libmcrypt/2.5.8/libmcrypt-2.5.8.tar.bz2

tar jxf libmcrypt-2.5.8.tar.bz2

cd libmcrypt-2.5.8

./configure

make

make install

ln -s /usr/local/lib/libmhash.so.2 /usr/lib/libmhash.so.2

wget http://www.youtu.kr/mirror/mhash-0.9.9.9.tar.gz

wget https://ko.osdn.net/frs/g_redir.php?m=kent\&f=mhash%2Fmhash%2F0.9.9.9%2Fmhash-0.9.9.9.tar.gz

# tar zxvf mhash-0.9.9.9.tar.gz

# cd /root/setup/etc/mhash-0.9.9.9; LD_LIBRARY_PATH=/usr/local/lib ./configure --prefix=/usr/local/

# make && make install

# ln -s /usr/local/lib/libmhash.so.2 /usr/lib/libmhash.so.2

# ln -s /usr/local/lib/libmhash.so.2 /usr/lib64/libmhash.so.2

Mcrypt download

http://downloads.sourceforge.net/project/mcrypt/MCrypt/2.6.8/mcrypt-2.6.8.tar.gz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fmcrypt%2Ffiles%2FMCrypt%2F2.6.8%2F&ts=1403153316&use_mirror=jaist

./configure

make && make install

/bin/rm: cannot remove `libtoolT': No such file or directory

# autoreconf --force --install 

# libtoolize --automake --force 

# automake --force --add-missing 

PHP Compile

./configure \

--with-apxs2=/usr/local/apache2/bin/apxs \

--with-config-file-path=/usr/local/apache2/conf \

--prefix=/usr/local/php \

--with-mysql=/usr/local/mysql \

--with-freetype-dir=/usr/include/freetype2/freetype \

--disable-debug \

--disable-rpath \

--enable-bcmath \

--enable-exif \

--enable-ftp \

--enable-ftp=shared \

--enable-gd-native-ttf \

--enable-inline-optimization \

--enable-mbregex \

--enable-mbstring \

--enable-sockets \

--enable-sysvsem \

--enable-sysvshm \

--enable-wddx \

--enable-zip \

--with-curl \

--with-freetype-dir=/usr \

--with-gd \

--with-gettext \

--with-iconv \

--with-jpeg-dir=/usr/local/lib \

--with-libxml-dir=/usr/lib \

--with-mcrypt \

--with-mhash \

--with-mysql \

--with-mysqli \

--with-openssl \

--with-png-dir=/usr/local/lib \

--with-libxml-dir=/usr/lib \

--with-zlib \

--with-pear

Note that the MySQL client library is not bundled anymore!

'./configure' \

'--with-apxs2=/svc/BVM/web/apache-2.2.23/bin/apxs' \

'--with-config-file-path=/svc/BVM/web/apache-2.2.23/conf' \

'--prefix=/svc/BVM/was/php-5.4.6' \

'--with-freetype-dir=/usr/include/freetype2/freetype' \

'--disable-debug' \

'--disable-rpath' \

'--enable-bcmath' \

'--enable-exif' \

'--enable-ftp' \

'--enable-ftp=shared' \

'--enable-gd-native-ttf' \

'--enable-inline-optimization' \

'--enable-mbregex' \

'--enable-mbstring' \

'--enable-sockets' \

'--enable-sysvsem' \

'--enable-sysvshm' \

'--enable-wddx' \

'--enable-zip' \

'--with-curl' \

'--with-freetype-dir=/usr' \

'--with-gd' \

'--with-gettext' \

'--with-iconv' \

'--with-jpeg-dir=/usr/local/lib' \

'--with-mcrypt' \

'--with-mhash' \

'--with-mysql=/svc/BVM/MYSQL/mysql-5.5.25a/' \

'--with-mysqli=/svc/BVM/MYSQL/mysql-5.5.25a/mysql_config' \

'--with-openssl' \

'--with-png-dir=/usr/local/lib' \

'--with-libxml-dir=/usr/lib' \

'--with-zlib' \

'--with-pear' \

"$@"

make && make install

/etc/hosts

#ORACLE

192.168.135.106 aoadb-scan

192.168.135.89  oradb1

192.168.135.90  oradb1

[root@aoacrm1 php-5.4.6]# cat > /usr/lib/oracle/tnsnames.ora

AOA =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = oradb1)(PORT = 1527))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = AOA)

    )

  )

OCI8 install

ln -s /svc/AOA/was/php-5.4.6/lib/php/extensions/no-debug-zts-20100525/oci8.so /svc/AOA/was/php-5.4.6/lib/php/extensions/oci8.so

cp /data/backup/php.ini /svc/AOA/web/apache-2.2.25/conf/php.ini

php -q /data/backup/test.php

오라클 설치

yum install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel make sysstat

리눅스(CentOS 6.2)에 Oracle 11g 설치

ㅇ Package Requirements

binutils-2.20.51.0.2-5.11.el6.i686

compat-libcap1-1.10-1.i686

compat-libstdc++-33-3.2.3-69.el6.i686

gcc-4.4.4-13.el6.i686

gcc-c++-4.4.4-13.el6.i686

glibc-2.12-1.7.el6.i686

glibc-devel-2.12-1.7.el6.i686

ksh

libgcc-4.4.4-13.el6.i686

libstdc++-4.4.4-13.el6.i686

libstdc++-devel-4.4.4-13.el6.i686

libaio-0.3.107-10.el6.i686

libaio-devel-0.3.107-10.el6.i686

make-3.81-19.el6.i686

sysstat-9.0.4-11.el6.i686

[root@localhost ~]# yum install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel make sysstat

ㅇ 그룹과 계정 생성

groupadd oinstall; groupadd dba;useradd -g oinstall -G dba oracle;passwd oracle

[root@localhost ~]# groupadd oinstall

[root@localhost ~]# groupadd dba    

[root@localhost ~]# id oracle       

id: oracle: No such user            

[root@localhost ~]# useradd -g oinstall -G dba oracle

[root@localhost ~]# passwd oracle

ㅇ 커널 파라미터 설정

/etc/sysctl.conf 파일 제일 아래쪽에 복사

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

ㅇ Resource Limits for Oracle

 etc/security/limits.conf 파일 제일 아래에 다음을 넣어준다.

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  1024

oracle              hard    nofile  65536

oracle              soft    stack   10240

ㅇ 오라클 설치 디렉토리 만들기

[root@localhost test0]# mkdir -p /app

[root@localhost test0]# chown -R oracle:oinstall /app

[root@localhost test0]# chmod -R 775 /app

ㅇ 오라클 환경변수 만들기

[oracle@localhost ~]$ vi /home/oracle/bash_profile

(profile 파일 제일 아래에 추가)

export ORACLE_BASE=/app/oracle

export ORACLE_SID=CENTORA

export ORACLE_HOME=/app/oracle/dbhome

export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl

ㅇ 추가 프로그램 설치

# yum install unixODBC, unixODBC-devel, pdksh

# rpm -Uvh --nodeps pdksh-5.2.14-8.i386.rpm

< style type="text/css"> #hiddenmorepopup { display:block; }< /style>

아파치 2.2.x
wget http://archive.apache.org/dist/httpd/httpd-2.2.13.tar.gz
tar -xvzf httpd-2.2.13.tar.gz
cd httpd-2.2.13
./configure --prefix=/usr/local/apache2 --enable-so \
              --enable-ssl --with-ssl=/usr/local/ssl \
              --enable-rewrite \
              --enable-suexec --with-suexec-caller=bin \
              --enable-deflate --enable-headers \
              --enable-dav \
              --with-included-apr --enable-lib64 --libdir=/usr/lib64 \
              --with-mpm=worker

#--enable-lib64 --libdir=/usr/lib64 64비트 시스템일경우 추가
#--enable-ssl ssl https 인증서 사용시 필요
#--enable-rewrite 주소 재작성 모듈
#--enable-suexec cgi 실행 권한 관련
#--enable-deflate --enable-headers 압축관련(이미지등)
#--enable-dav subversion에서 사용됨
#--with-included-apr 아파치 소스에 포함된 apr을 그대로 사용하도록 지정
#--with-mpm=worker 아파치의 프로세스 동작 설정(기본 옵션은 prefork)

make && make install

출처: <http://wiki.nettem.co.kr/Wiki.jsp?page=Apache_Install_Linux>