Orcale数据库快速安装_CentOS7
1.切换至root用户
2.uname -a/-m grep MemTotal /proc/meminfo grep SwapTotal /proc/meminfo free -m
3.df -h /tmp 至少1G空间
4.查看安装依赖软件 rpm -q package_name
binutils-2.23.52.0.1-12.el7.x86_64
compat-libcap1-1.10-3.el7.x86_64
compat-libstdc++-33-3.2.3-71.el7.i686
compat-libstdc++-33-3.2.3-71.el7.x86_64
gcc-4.8.2-3.el7.x86_64 gcc-c++-4.8.2-3.el7.x86_64
glibc-2.17-36.el7.i686 glibc-2.17-36.el7.x86_64
glibc-devel-2.17-36.el7.i686
glibc-devel-2.17-36.el7.x86_64
ksh
libaio-0.3.109-9.el7.i686
libaio-0.3.109-9.el7.x86_64
libaio-devel-0.3.109-9.el7.i686
libaio-devel-0.3.109-9.el7.x86_64
libgcc-4.8.2-3.el7.i686
libgcc-4.8.2-3.el7.x86_64
libstdc++-4.8.2-3.el7.i686
libstdc++-4.8.2-3.el7.x86_64
libstdc++-devel-4.8.2-3.el7.i686
libstdc++-devel-4.8.2-3.el7.x86_64
libXi-1.7.2-1.el7.i686
libXi-1.7.2-1.el7.x86_64
libXtst-1.2.2-1.el7.i686
libXtst-1.2.2-1.el7.x86_64
make-3.82-19.el7.x86_64
sysstat-10.1.5-1.el7.x86_64
unixODBC-2.3.1-6.el7.x86_64 or later
unixODBC-2.3.1-6.el7.i686 or later
unixODBC-devel-2.3.1-6.el7.x86_64 or later
unixODBC-devel-2.3.1-6.el7.i686 or later
pam
5.添加用户及用户组
# /usr/sbin/groupadd oinstall # /usr/sbin/groupadd dba
# id oracle
# /usr/sbin/useradd -g oinstall -G dba oracle
# passwd oracle
6.修改内核参数
| Minimum Value | File | |
|---|---|---|
semmsl
|
250
32000 100 128 |
/proc/sys/kernel/sem |
shmall |
2097152 | /proc/sys/kernel/shmall |
shmmax |
Minimum: 536870912
Maximum: A value that is 1 byte less than the physical memory Recommended: More than half the physical memory See My Oracle Support Note 567506.1 for additional information about configuring |
/proc/sys/kernel/shmmax |
shmmni |
4096 | /proc/sys/kernel/shmmni |
file-max |
6815744 | /proc/sys/fs/file-max |
ip_local_port_range |
Minimum: 9000
Maximum: 65500 |
/proc/sys/net/ipv4/ip_local_port_range |
rmem_default |
262144 | /proc/sys/net/core/rmem_default |
rmem_max |
4194304 | /proc/sys/net/core/rmem_max |
wmem_default |
262144 | /proc/sys/net/core/wmem_default |
wmem_max |
1048576 | /proc/sys/net/core/wmem_max |
aio-max-nr |
1048576
Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. |
/proc/sys/fs/aio-max-nr |
| Command | |
|---|---|
semmsl, semmns, semopm, and semmni |
# /sbin/sysctl -a | grep sem
This command displays the value of the semaphore parameters in the order listed. |
shmall, shmmax, and shmmni |
# /sbin/sysctl -a | grep shm |
file-max |
# /sbin/sysctl -a | grep file-max |
ip_local_port_range |
# /sbin/sysctl -a | grep ip_local_port_range |
rmem_default |
# /sbin/sysctl -a | grep rmem_default |
rmem_max |
# /sbin/sysctl -a | grep rmem_max |
wmem_default |
# /sbin/sysctl -a | grep wmem_default |
wmem_max |
# /sbin/sysctl -a | grep wmem_max |
不符合要求的,需要按照下面的格式修改/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
使用下面的命令使修改的内核参数生效
# /sbin/sysctl -p
7.修改用户使用资源限制
/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240
8.创建目录
# mkdir -p /app/
# chown -R oracle:oinstall /app/
# chmod -R 775 /app/
$ sudo mkdir /tmp
$ sudo chmod a+wr /tmp
# exit
9.注销当前用户，通过Oracle用户登录，设置环境变量，安装程序
$ TMP=/tmp
$ TMPDIR=/tmp
$ export TMP TMPDIR
$ ORACLE_BASE=/app/oracle
$ ORACLE_SID=orcl
$export ORACLE_BASE ORACLE_SID
cd database
./runInstaller
10.安装过程中的问题记录
Error in invoking target 'agent nmhs' of makefile '/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk'.解决过程 vim /app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk
Search for the line $(MK_EMAGENT_NMECTL)
Change it to: $(MK_EMAGENT_NMECTL) -lnnz11
11.启用scott和hr用户并设置密码
12.测试连接
浙公网安备 33010602011771号