swachian/Oracle.md

## config.sh
#!/bin/bash
cat << EOF
+--------------------------------------------------------------+
| === Welcome to Centos System init === |
+--------------------------------------------------------------+
+--------------------------by richard--------------------------+
EOF

chkconfig --level 35 iptables off

#set ntp
yum -y install ntp
echo "*/5 * * * * /usr/sbin/ntpdate ntp.api.bz > /dev/null 2>&1" >> /etc/crontab
service crond restart
#set ulimit
echo "ulimit -SHn 65536" >> /etc/rc.local

cat >> /etc/security/limits.conf <<EOF
  * soft nofile 32768
  * hard nofile 32768
  oracle soft    nproc   2047
  oracle hard    nproc   16384
  oracle soft    nofile  4096
  oracle hard    nofile  65536
  oracle soft memlock 3145728
  oracle hard memlock 3145728


EOF


#set locale
#true > /etc/sysconfig/i18n
#cat >>/etc/sysconfig/i18n<<EOF
#LANG="zh_CN.GB18030"
#SUPPORTED="zh_CN.GB18030:zh_CN:zh:en_US.UTF-8:en_US:en"
#SYSFONT="latarcyrheb-sun16"
#EOF
#set sysctl
true > /etc/sysctl.conf
cat >> /etc/sysctl.conf << EOF
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.sem = 250 32000 100 128
fs.file-max = 65536
vm.overcommit_memory = 1
net.ipv4.tcp_max_tw_buckets = 6000
net.ipv4.tcp_sack = 1
net.ipv4.tcp_window_scaling = 1
net.ipv4.tcp_rmem = 4096 87380 4194304
net.ipv4.tcp_wmem = 4096 16384 4194304
net.core.wmem_default = 8388608
net.core.rmem_default = 8388608
net.core.rmem_max = 16777216
net.core.wmem_max = 16777216
net.core.netdev_max_backlog = 262144
net.core.somaxconn = 262144
net.ipv4.tcp_max_orphans = 3276800
net.ipv4.tcp_max_syn_backlog = 262144
net.ipv4.tcp_timestamps = 0
net.ipv4.tcp_synack_retries = 1
net.ipv4.tcp_syn_retries = 1
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_mem = 94500000 915000000 927000000
net.ipv4.tcp_fin_timeout = 1
net.ipv4.tcp_keepalive_time = 1200
net.ipv4.ip_local_port_range = 1024 65535
#vm.hugetlb_shm_group = 500 #500是oracle所在的groups
EOF
/sbin/sysctl -p
echo "sysctl set OK!!"

#set purview
chmod 644 /etc/passwd
chmod 644 /etc/shadow
chmod 644 /etc/group
chmod 644 /etc/gshadow
#disable ipv6
cat << EOF
+--------------------------------------------------------------+
| === Welcome to Disable IPV6 === |
+--------------------------------------------------------------+
EOF
echo "alias net-pf-10 off" >> /etc/modprobe.conf
echo "alias ipv6 off" >> /etc/modprobe.conf
/sbin/chkconfig --level 35 ip6tables off
echo "ipv6 is disabled!"
#disable selinux
sed -i '/SELINUX/s/enforcing/disabled/' /etc/selinux/config
echo "selinux is disabled,you must reboot!"
#vim
sed -i "8 s/^/alias vi='vim'/" /root/.bashrc
echo 'syntax on' > /root/.vimrc
#zh_cn
# sed -i -e 's/^LANG=.*/LANG="en"/' /etc/sysconfig/i18n
#init_ssh
ssh_cf="/etc/ssh/sshd_config"
#sed -i -e '74 s/^/#/' -i -e '76 s/^/#/' $ssh_cf
#sed -i "s/#Port 22/Port 65535/" $ssh_cf
#sed -i "s/#UseDNS yes/UseDNS no/" $ssh_cf
#client
#sed -i -e '44 s/^/#/' -i -e '48 s/^/#/' $ssh_cf
service sshd restart
echo "ssh is init is ok.............."


#chkser
#tunoff services
#--------------------------------------------------------------------------------
cat << EOF
+--------------------------------------------------------------+
| === Welcome to Tunoff services === |
+--------------------------------------------------------------+
EOF
#---------------------------------------------------------------------------------
for i in `ls /etc/rc3.d/S*`
do
CURSRV=`echo $i|cut -c 15-`
echo $CURSRV
case $CURSRV in
crond | irqbalance | microcode_ctl | network | random | sshd | syslog | local )
echo "Base services, Skip!"
;;
*)
echo "change $CURSRV to off"
chkconfig --level 235 $CURSRV off
service $CURSRV stop
;;
esac
done
echo "service is init is ok.............."

read -p "enter hostname :" num
echo $num
name=`hostname`
sed -i "s/$name/$num/" /etc/sysconfig/network

echo "nameserver 202.96.209.5" > /etc/resolv.conf

yum -y install gcc gcc-c++ glibc glibc-common gd gd-devel
#yum -y groupinstall "Development Tools"
yum -y install libxslt-devel libyaml-devel libxml2-devel gdbm-devel libffi-devel zlib-devel openssl-devel libyaml-devel readline-devel curl-devel openssl-devel pcre-devel git memcached-devel valgrind-devel mysql-devel ImageMagick-devel ImageMagicka iconv-devel

## ntp服务器

http://www.cnblogs.com/greenerycn/archive/2011/03/13/linux_ntp_server.html

安装完ntp服务器之后，进行配置

### 服务器配置

1. 配置文件位置为::

    /etc/ntp.conf

2. 修改配置允许局域网内机器与该服务器进行时间同步。

    将下面语句::

        restrict default kod nomodify notrap nopeer noquery

    修改为::

        restrict default nomodify

3. 修改上一层的时间服务器。

    ntp.org现在提供NTP POOL PROJECT，即ntp 服务器池项目。在中国区域，配置如下即可::

    server 0.cn.pool.ntp.org
    server 0.asia.pool.ntp.org
    server 2.asia.pool.ntp.org

    其中0.cn 是中国服务器池，后面两个是亚洲的服务器池。

    最新列表见：

        http://www.pool.ntp.org/zone/cn

### 启动服务

    /usr/sbin/ntpd -c /etc/ntp.conf -p /tmp/ntpd.pid -l /tmp/ntp.log

注意启动后需要等几分钟，否则其它机器来同步时会得到

    no server suitable for synchronization found

的错误。

### 客户端调用

`ntpdate  ntp-server-ip`

crontab添加上述命令

## Oracle.md

      
    Raw
  

              Oracle.md
            
          
    Oracle 原厂文档: http://www.oracle-base.com/articles/10g/oracle-db-10gr2-installation-on-rhel-5.php
Redhat6安装Oracle10g http://www.cnblogs.com/kerrycode/p/3250775.html
yum install setarch-2*  make-3*  glibc-2*  libaio-0* glibc-*.i686 glibc-devel-*.i386
yum install compat-libstdc++-33-3*  compat-gcc-34-3*  compat-gcc-34-c++-3*  gcc-4*  libXp-1*
yum install  openmotif-2*  compat-db-4*

yum install -y libXp-devel.i686  libXt.i686 libXtst.i686 compat-gcc* compat-glibc* compat-libstd* glibc-devel.i686 libaio-devel.i686

gunzip 1.10201_database_linux_x86_64.cpio.gz
cpio -idmv < 1.10201_database_linux_x86_64.cpio 
./runInstaller
CentOS的光盘源 http://blog.sina.com.cn/s/blog_458dc4f50101ib3j.html
oracle参数调整
SQL> alter system set sga_max_size=6000m scope=spfile;
SQL> shutdown immediate
SQL> startup
SQL> show parameter sga
SQL> alter system set sga_target=4000m scope=spfile;
安装路径 /opt/oracle, 安装完毕后运行genclntst生成客户端。
磁盘性能测试
time dd if=filetest | dd of=/dev/null
time dd -o_direct=256K if=filetest | dd of=/dev/null

网络适配
ethtool eth0 查看网络适配的信息
性能监控
sar -n DEV 5 100
iostat -x  5 100
top m c


## squid.md

      
    Raw
  

              squid.md
            
          
    yum install squid
修改/etc/squid/squid.conf 中的 http_access deny all 为 http_access allow all
然后启动squid.
随后，可以在其他机器的/etc/yum.conf中增加proxy=http://mycache.mydomain.com:3128 即可。
甚至还可以设置proxy的用户名
# 用于 yum 连接的帐户细节
proxy_username=yum-user
proxy_password=qwerty

export http_proxy=http://username:password@proxyserver:port/
设置这个全局变量则会对wget 等都有效果
	#!/bin/bash
	cat << EOF
	+--------------------------------------------------------------+
	\| === Welcome to Centos System init === \|
	+--------------------------------------------------------------+
	+--------------------------by richard--------------------------+
	EOF

	chkconfig --level 35 iptables off

	#set ntp
	yum -y install ntp
	echo "/5 * * * /usr/sbin/ntpdate ntp.api.bz > /dev/null 2>&1" >> /etc/crontab
	service crond restart
	#set ulimit
	echo "ulimit -SHn 65536" >> /etc/rc.local

	cat >> /etc/security/limits.conf <<EOF
	* soft nofile 32768
	* hard nofile 32768
	oracle soft nproc 2047
	oracle hard nproc 16384
	oracle soft nofile 4096
	oracle hard nofile 65536
	oracle soft memlock 3145728
	oracle hard memlock 3145728


	EOF


	#set locale
	#true > /etc/sysconfig/i18n
	#cat >>/etc/sysconfig/i18n<<EOF
	#LANG="zh_CN.GB18030"
	#SUPPORTED="zh_CN.GB18030:zh_CN:zh:en_US.UTF-8:en_US:en"
	#SYSFONT="latarcyrheb-sun16"
	#EOF
	#set sysctl
	true > /etc/sysctl.conf
	cat >> /etc/sysctl.conf << EOF
	net.ipv4.ip_forward = 0
	net.ipv4.conf.default.rp_filter = 1
	net.ipv4.conf.default.accept_source_route = 0
	kernel.sysrq = 0
	kernel.core_uses_pid = 1
	net.ipv4.tcp_syncookies = 1
	kernel.msgmnb = 65536
	kernel.msgmax = 65536
	kernel.shmmax = 68719476736
	kernel.shmall = 4294967296
	kernel.sem = 250 32000 100 128
	fs.file-max = 65536
	vm.overcommit_memory = 1
	net.ipv4.tcp_max_tw_buckets = 6000
	net.ipv4.tcp_sack = 1
	net.ipv4.tcp_window_scaling = 1
	net.ipv4.tcp_rmem = 4096 87380 4194304
	net.ipv4.tcp_wmem = 4096 16384 4194304
	net.core.wmem_default = 8388608
	net.core.rmem_default = 8388608
	net.core.rmem_max = 16777216
	net.core.wmem_max = 16777216
	net.core.netdev_max_backlog = 262144
	net.core.somaxconn = 262144
	net.ipv4.tcp_max_orphans = 3276800
	net.ipv4.tcp_max_syn_backlog = 262144
	net.ipv4.tcp_timestamps = 0
	net.ipv4.tcp_synack_retries = 1
	net.ipv4.tcp_syn_retries = 1
	net.ipv4.tcp_tw_recycle = 1
	net.ipv4.tcp_tw_reuse = 1
	net.ipv4.tcp_mem = 94500000 915000000 927000000
	net.ipv4.tcp_fin_timeout = 1
	net.ipv4.tcp_keepalive_time = 1200
	net.ipv4.ip_local_port_range = 1024 65535
	#vm.hugetlb_shm_group = 500 #500是oracle所在的groups
	EOF
	/sbin/sysctl -p
	echo "sysctl set OK!!"

	#set purview
	chmod 644 /etc/passwd
	chmod 644 /etc/shadow
	chmod 644 /etc/group
	chmod 644 /etc/gshadow
	#disable ipv6
	cat << EOF
	+--------------------------------------------------------------+
	\| === Welcome to Disable IPV6 === \|
	+--------------------------------------------------------------+
	EOF
	echo "alias net-pf-10 off" >> /etc/modprobe.conf
	echo "alias ipv6 off" >> /etc/modprobe.conf
	/sbin/chkconfig --level 35 ip6tables off
	echo "ipv6 is disabled!"
	#disable selinux
	sed -i '/SELINUX/s/enforcing/disabled/' /etc/selinux/config
	echo "selinux is disabled,you must reboot!"
	#vim
	sed -i "8 s/^/alias vi='vim'/" /root/.bashrc
	echo 'syntax on' > /root/.vimrc
	#zh_cn
	# sed -i -e 's/^LANG=.*/LANG="en"/' /etc/sysconfig/i18n
	#init_ssh
	ssh_cf="/etc/ssh/sshd_config"
	#sed -i -e '74 s/^/#/' -i -e '76 s/^/#/' $ssh_cf
	#sed -i "s/#Port 22/Port 65535/" $ssh_cf
	#sed -i "s/#UseDNS yes/UseDNS no/" $ssh_cf
	#client
	#sed -i -e '44 s/^/#/' -i -e '48 s/^/#/' $ssh_cf
	service sshd restart
	echo "ssh is init is ok.............."


	#chkser
	#tunoff services
	#--------------------------------------------------------------------------------
	cat << EOF
	+--------------------------------------------------------------+
	\| === Welcome to Tunoff services === \|
	+--------------------------------------------------------------+
	EOF
	#---------------------------------------------------------------------------------
	for i in `ls /etc/rc3.d/S*`
	do
	CURSRV=`echo $i\|cut -c 15-`
	echo $CURSRV
	case $CURSRV in
	crond \| irqbalance \| microcode_ctl \| network \| random \| sshd \| syslog \| local )
	echo "Base services, Skip!"
	;;
	*)
	echo "change $CURSRV to off"
	chkconfig --level 235 $CURSRV off
	service $CURSRV stop
	;;
	esac
	done
	echo "service is init is ok.............."

	read -p "enter hostname :" num
	echo $num
	name=`hostname`
	sed -i "s/$name/$num/" /etc/sysconfig/network

	echo "nameserver 202.96.209.5" > /etc/resolv.conf

	yum -y install gcc gcc-c++ glibc glibc-common gd gd-devel
	#yum -y groupinstall "Development Tools"
	yum -y install libxslt-devel libyaml-devel libxml2-devel gdbm-devel libffi-devel zlib-devel openssl-devel libyaml-devel readline-devel curl-devel openssl-devel pcre-devel git memcached-devel valgrind-devel mysql-devel ImageMagick-devel ImageMagicka iconv-devel

	http://www.cnblogs.com/greenerycn/archive/2011/03/13/linux_ntp_server.html

	安装完ntp服务器之后，进行配置

	### 服务器配置

	1. 配置文件位置为::

	/etc/ntp.conf

	2. 修改配置允许局域网内机器与该服务器进行时间同步。

	将下面语句::

	restrict default kod nomodify notrap nopeer noquery

	修改为::

	restrict default nomodify

	3. 修改上一层的时间服务器。

	ntp.org现在提供NTP POOL PROJECT，即ntp 服务器池项目。在中国区域，配置如下即可::

	server 0.cn.pool.ntp.org
	server 0.asia.pool.ntp.org
	server 2.asia.pool.ntp.org

	其中0.cn 是中国服务器池，后面两个是亚洲的服务器池。

	最新列表见：

	http://www.pool.ntp.org/zone/cn

	### 启动服务

	/usr/sbin/ntpd -c /etc/ntp.conf -p /tmp/ntpd.pid -l /tmp/ntp.log

	注意启动后需要等几分钟，否则其它机器来同步时会得到

	no server suitable for synchronization found

	的错误。

	### 客户端调用

	`ntpdate ntp-server-ip`

	crontab添加上述命令