NeoKylin 7.6安装oracle 11.2.0.4

报告课题：NeoKylin 7.6安装oracle 11.2.0.4
1、  用户配置
1.1、SSH配置
# cp /etc/ssh/sshd_config /etc/ssh/sshd_config_`date +"%Y%m%d_%H%M%S"` && sed -i '/#LoginGraceTime 2m/ s/#LoginGraceTime 2m/LoginGraceTime 0/' /etc/ssh/sshd_config && grep LoginGraceTime /etc/ssh/sshd_config
# cp /etc/ssh/sshd_config /etc/ssh/sshd_config_`date +"%Y%m%d_%H%M%S"` && sed -i '/#UseDNS yes/ s/#UseDNS yes/UseDNS no/' /etc/ssh/sshd_config && grep UseDNS /etc/ssh/sshd_config
1.2、修改内核参数：
# cat <<EOF>>/etc/sysctl.conf
kernel.shmmax = 8589934591
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
fs.file-max = 6815744

kernel.shmall = 2097152
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.tcp_tw_reuse = 1
net.core.somaxconn = 65500
net.ipv4.tcp_max_orphans = 262144
net.ipv4.tcp_max_syn_backlog = 262144
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_syn_retries = 1
net.ipv4.tcp_fin_timeout = 1
net.ipv4.tcp_keepalive_time = 30
net.ipv4.tcp_keepalive_probes = 6
net.ipv4.tcp_keepalive_intvl = 5
net.ipv4.tcp_timestamps = 0
fs.aio-max-nr = 1048576
EOF

# /sbin/sysctl -p
1.3、禁用SELinux
# sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
注意：需重启主机，才能生效
1.4、修改系统限制
# cat <<EOF>>/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

# cat <<EOF>>/etc/pam.d/login
session required /lib64/security/pam_limits.so
EOF
1.5、创建用户与组
# groupadd oinstall
# groupadd dba
# groupadd oper
# useradd -g oinstall -G dba,oper oracle
# echo oracle_4U |passwd --stdin oracle
1.6、创建安装目录
# mkdir -p /u01/app/oracle/product/11.2.0/db_1
# mkdir -p /u01/app/oraInventory
# chown -R oracle:oinstall /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oraInventory
# chmod -R 755 /u01
1.7、配置yum源
# mkdir -p /etc/yum.repos.d/bak
# mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bak
# mount /dev/sr0 /mnt
# cat <<EOF>>/etc/yum.repos.d/NeoKylin7.repo
[NeoKylin7]
name= NeoKylin7
baseurl=file:///mnt
enable=1
gpgcheck=0
EOF

# yum makecache
1.8、安装包：
# yum install -y bc binutils elfutils-libelf glibc glibc-devel ksh libaio libXrender libX11 libXau libXi libXtst libgcc libstdc++ libxcb make policycoreutils policycoreutils-python smartmontools sysstat gcc libaio-devel elfutils-libelf-devel gcc-c++ libstdc++-devel pdksh dstat iotop

#手动上传并安装依赖包：pdksh-5.2.14-37.el5.x86_64.rpm和compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

sftp> lcd F:\package
sftp> put pdksh-5.2.14-37.el5.x86_64.rpm
sftp> put compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

[root@hisdb1 yum.repos.d]# rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
[root@hisdb1 yum.repos.d]# rpm -e ksh-20120801-139.el7.x86_64
[root@hisdb1 yum.repos.d]# rpm -ivh pdksh-5.2.14-37.el5.x86_64.rpm
1.9、关闭防火墙
# systemctl status firewalld.service
# systemctl stop firewalld.service
# systemctl disable firewalld.service
1.10、修改环境变量
# su - oracle
$ cat <<EOF>>/home/oracle/.bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=orcl
export PATH=\$ORACLE_HOME/bin:\$PATH
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib
EOF
$ source .bash_profile
1.11、添加域名解析
# vi /etc/hosts
# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.133.205 liujun
1.12、上传文件
# mkdir -p /u01/setup/db
--sftp上传到linux
sftp> cd /u01/setup/db
sftp> lcd F:\installmedium\11g
sftp> put p13390677_112040_Linux-x86-64_1of7.zip
sftp> put p13390677_112040_Linux-x86-64_2of7.zip
# chown -R oracle:oinstall /u01/setup/db
1.13、解压文件
# su - oracle
$ cd /u01/setup/db
$ unzip -q p13390677_112040_Linux-x86-64_1of7.zip
$ unzip -q p13390677_112040_Linux-x86-64_2of7.zip
2、DB安装
$ cd /u01/setup/db/database
$ export DISPLAY=192.168.133.1:0.0 
$ export LANG="en_US"
$ ./runInstaller

$ vi $ORACLE_HOME/sysman/lib/ins_emagent.mk
将$(MK_EMAGENT_NMECTL)修改为：$(MK_EMAGENT_NMECTL-lnnz11)

# /u01/app/oraInventory/orainstRoot.sh
# /u01/app/oracle/product/11.2.0/db_1/root.sh

3、创建监听
$ export DISPLAY=192.168.133.1:0.0
$ netca

4、创建实例
$ dbca

db安装结束.