今天接到通知,下周去一个新客户那边部署新环境,问题是时间还很紧,让下周一就去,时间紧还不是大问题,问题是产品的中间件weblogic跟数据库oracle我都好久没玩了,没得办法,只能提前演练一下了,为了下次找起来更加方便,就把过程整理到本博客上面来,也可以方便其他童鞋的查询吧。
谁要是跟我纠结时间这么紧,哪来的时间写博客的,我跟谁急哦!方便自己,也方便大家嘛!
华丽分割线
一.查看系统配置信息
[root@web-db ~]# hostname --fqdn //查看主机名web-db[root@web-db ~]# ifconfig eth0 //查看本机ip地址eth0link encap:ethernet hwaddr 06:f1:96:00:00:c0inet addr:192.168.153.153 bcast:192.168.153.255 mask:255.255.255.0inet6 addr: fe80::4f1:96ff:fe00:c0/64 scope:linkup broadcast running multicast mtu:1500 metric:1rx packets:1706513 errors:0 dropped:0 overruns:0 frame:0tx packets:877952 errors:0 dropped:0 overruns:0 carrier:0collisions:0 txqueuelen:1000rx bytes:2565533900 (2.3 gib) tx bytes:59768622 (56.9 mib)[root@web-db ~]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.153.153 web-db[root@web-db ~]# cat /etc/redhat-release //查看rhel发行版本red hat enterprise linux server release 6.3 (santiago)[root@web-db ~]# uname -m //查看本机cpu架构x86_64[root@web-db ~]# free -m //查看内存跟交换分区信息totalusedfreeshared bufferscachedmem:7870287649930122609-/+ buffers/cache:2547616swap:576005760[root@web-db ~]# df -h //查看分区挂载信息filesystemsize used avail use% mounted on/dev/mapper/volgroup-lv_root9.1g 3.6g 5.1g 41% /tmpfs4.2g0 4.2g 0% /dev/shm/dev/vda1508m 33m 449m 7% /boot/dev/vdb530g 181m 28g 1% /u01当然,有朋友会问:你用的是物理机还是虚拟机?
我这么有钱,想想就知道我用的是什么了,是不是?
[root@web-db ~]# lscpuarchitecture:x86_64cpu op-mode(s):32-bit, 64-bitbyte order:little endiancpu(s):8on-line cpu(s) list: 0-7thread(s) per core: 1core(s) per socket: 1cpu socket(s):8numa node(s):1vendor id:genuineintelcpu family:6model:13stepping:3cpu mhz:2393.998bogomips:4787.99hypervisor vendor:kvmvirtualization type: fulll1d cache:32kl1i cache:32kl2 cache:4096knuma node0 cpu(s):0-7咦? 怎么不是物理机,我说我什么时候这么有钱的呢?用的还是kvm虚拟机。
呵呵,开个玩笑,我们继续技术交流,禁止鄙视使用虚拟机的屌丝!
二.配置系统yum源,安装依赖包
[root@web-db ~]# mount /dev/sr0 /media/mount: block device /dev/sr0 is write-protected, mounting read-only[root@web-db ~]# cat /etc/yum.repos.d/rhel-source.repo[rhel6u3-core]name=rhel6u3-corebaseurl=file:///mediaenabled=1gpgcheck=0[root@web-db ~]# yum clean allloaded plugins: product-id, subscription-managerupdating certificate-based repositories.unable to read consumer identitycleaning repos: rhel6u3-corecleaning up everything[root@web-db ~]# cat package.list //需要安装的依赖包信息列表binutilscompat-libcap1compat-libstdc++-33compat-libstdc++-33*.i686elfutils-libelf-develgccgcc-c++glibc*.i686glibcglibc-develglibc-devel*.i686kshlibgcc*.i686libgcclibstdc++libstdc++*.i686libstdc++-devellibstdc++-devel*.i686libaiolibaio*.i686libaio-devellibaio-devel*.i686makesysstatunixodbcunixodbc*.i686unixodbc-develunixodbc-devel*.i686[root@web-db ~]# yum install `cat package.list` -y //安装依赖包
三.修改内核参数
[root@web-db ~]# cp /etc/sysctl.conf \/etc/sysctl.conf_20131016.bak//备份文件[root@web-db ~]# cat /etc/sysctl.conf //在文件爱呢最后添加如下##==========setting for oracle 11g r2============##kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6815744fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.wmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_max = 1048576[root@web-db ~]# sysctl -p //让修改立即生效net.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.core_uses_pid = 1net.ipv4.tcp_syncookies = 1error: net.bridge.bridge-nf-call-ip6tables is an unknown keyerror: net.bridge.bridge-nf-call-iptables is an unknown keyerror: net.bridge.bridge-nf-call-arptables is an unknown keykernel.msgmnb = 65536kernel.msgmax = 65536kernel.shmmax = 68719476736kernel.shmall = 4294967296kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 6815744fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 4194304net.core.wmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_max = 1048576四. 创建oracle用户以及相关权限修改
1. 创建oracle 用户组跟用户
[root@web-db ~]# groupadd oinstall[root@web-db ~]# groupadd dba[root@web-db ~]# useradd -g oinstall -g dba -m oracle[root@web-db ~]# echo oracle |passwd --stdin oracle //创建密码changing password for user oracle.passwd: all authentication tokens updated successfully.2. 修改限制
[root@web-db ~]# cp /etc/security/limits.conf /etc/security/limits.conf.20131016.bak##=============setting for oracle 11g r2=============##oraclesoft nproc 2047oraclehard nproc 16384oraclesoft nofile 1024oraclehard nofile 65536oraclesoft stack 10240[root@web-db ~]# cat /etc/pam.d/login##======setting for oracle 11g r2========##session requiredpam_limits.so[root@web-db ~]# cat /etc/profile##===setting for oracle 11g r2=====##if [ $user = oracle ]; thenif [ $shell = /bin/ksh ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi[root@web-db ~]# source /etc/profile
