作者:鸡__腿孜然小朋友 | 来源:互联网 | 2018-07-10 14:29
今天接到通知,下周去一个新客户那边部署新环境,问题是时间还很紧,让下周一就去,时间紧还不是大问题,问题是产品的中间件Weblogic跟数据库Oracle我都好久没玩
今天接到通知,下周去一个新客户那边部署新环境,问题是时间还很紧,让下周一就去,时间紧还不是大问题,问题是产品的中间件Weblogic跟数据库Oracle我都好久没玩
今天接到通知,下周去一个新客户那边部署新环境,问题是时间还很紧,让下周一就去,时间紧还不是大问题,问题是产品的中间件Weblogic跟数据库Oracle我都好久没玩了,没得办法,只能提前演练一下了,为了下次找起来更加方便,就把过程整理到本博客上面来,也可以方便其他童鞋的查询吧。
谁要是跟我纠结时间这么紧,哪来的时间写博客的,我跟谁急哦!方便自己,也方便大家嘛!
华丽分割线
一.查看系统配置信息
[root@web-db ~]# hostname --fqdn //查看主机名
web-db
[root@web-db ~]# ifconfig eth0 //查看本机IP地址
eth0
Link encap:Ethernet HWaddr 06:F1:96:00:00:C0
inet addr:192.168.153.153 Bcast:192.168.153.255 Mask:255.255.255.0
inet6 addr: fe80::4f1:96ff:fe00:c0/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:1706513 errors:0 dropped:0 overruns:0 frame:0
TX packets:877952 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:2565533900 (2.3 GiB) TX bytes:59768622 (56.9 MiB)
[root@web-db ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1
localhost localhost.localdomain localhost6 localhost6.localdomain6
192.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 //查看内存跟交换分区信息
total
used
free
shared buffers
cached
Mem:
7870
2876
4993
0
12
2609
-/+ buffers/cache:
254
7616
Swap:
5760
0
5760
[root@web-db ~]# df -H //查看分区挂载信息
Filesystem
Size Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
9.1G 3.6G 5.1G 41% /
tmpfs
4.2G
0 4.2G 0% /dev/shm
/dev/vda1
508M 33M 449M 7% /boot
/dev/vdb5
30G 181M 28G 1% /u01
当然,有朋友会问:你用的是物理机还是虚拟机?
我这么有钱,想想就知道我用的是什么了,是不是?
[root@web-db ~]# lscpu
Architecture:
x86_64
CPU op-mode(s):
32-bit, 64-bit
Byte Order:
Little Endian
CPU(s):
8
On-line CPU(s) list: 0-7
Thread(s) per core: 1
Core(s) per socket: 1
CPU socket(s):
8
NUMA node(s):
1
Vendor ID:
GenuineIntel
CPU family:
6
Model:
13
Stepping:
3
CPU MHz:
2393.998
BogoMIPS:
4787.99
Hypervisor vendor:
KVM
Virtualization type: full
L1d cache:
32K
L1i cache:
32K
L2 cache:
4096K
NUMA 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-core
baseurl=file:///media
enabled=1
gpgcheck=0[root@web-db ~]# yum clean all
Loaded plugins: product-id, subscription-manager
Updating certificate-based repositories.
Unable to read consumer identity
Cleaning repos: rhel6u3-core
Cleaning up Everything[root@web-db ~]# cat package.list //需要安装的依赖包信息列表
binutils
compat-libcap1
compat-libstdc++-33
compat-libstdc++-33*.i686
elfutils-libelf-devel
gcc
gcc-c++
glibc*.i686
glibc
glibc-devel
glibc-devel*.i686
ksh
libgcc*.i686
libgcc
libstdc++
libstdc++*.i686
libstdc++-devel
libstdc++-devel*.i686
libaio
libaio*.i686
libaio-devel
libaio-devel*.i686
make
sysstat
unixODBC
unixODBC*.i686
unixODBC-devel
unixODBC-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 = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576[root@web-db ~]# sysctl -p //让修改立即生效
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
error: "net.bridge.bridge-nf-call-ip6tables" is an unknown key
error: "net.bridge.bridge-nf-call-iptables" is an unknown key
error: "net.bridge.bridge-nf-call-arptables" is an unknown key
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.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=============##
oracle
soft nproc 2047
oracle
hard nproc 16384
oracle
soft nofile 1024
oracle
hard nofile 65536
oracle
soft stack 10240
[root@web-db ~]# cat /etc/pam.d/login
##======Setting For Oracle 11G R2========##
session required
pam_limits.so
[root@web-db ~]# cat /etc/profile
##===Setting For Oracle 11G R2=====##
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
[root@web-db ~]# source /etc/profile