CentOS7.6安装Oracle 11g2R

一.系统优化

1.安装依赖

yum install -y bash-completion bash-completion-extras \
tree screen lrzsz nmap tree dos2unix nc wget \
vim lsof tcpdump gcc glibc gcc-c++ make net-tools unzip

2.关闭selinux,firewalld

sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/configsetenforce 0systemctl stop firewalld.servicesystemctl disable firewalld.service

二.安装图形化界面

1.安装桌面

yum groupinstall -y "Desktop"yum groupinstall -y "Chinese Support"yum groupinstall -y "GNOMEDesktop"yum groupinstall -y "X Window System"yum install -y xorg-x11-appsyum groupinstall -y "GNOME"(centos 8)

2.检查X是否安装成功

yum grouplist

3.安装vncserver

yum -y install tigervnc-serveryum -y install vnc

4.Windows安装VNC Viewer

http://down-ww3.newasp.net/pcdown/soft/liu/vnc_viewer.zip

5.新建连接桌面

三.安装Oracle数据库

xshell 操作

1.创建安装包存放目录

mkdir -p /opt/soft

2.下载Oracle 11g安装包(安装包自备)

wget https://47.102.140.54/files/linux.x64_11gR2_database_1of2.zipwget https://47.102.140.54/files/linux.x64_11gR2_database_2of2.zip

3.安装依赖包

yum -y install compat-libstdc++-33.x86_64 \
elfutils-libelf-devel.x86_64 \
libstdc++-devel.x86_64 gcc-c++.x86_64 \
libaio-devel.x86_64 unixODBC-devel.x86_64 glibc*

4.配置交换分区

关闭交互分区swapoff -a创建一个交换区文件dd if=/dev/zero of=/opt/swap bs=1024 count=20480000将目的文件设置为swap分区文件mkswap swap激活swap，立即启用交换分区文件
swapon swap把交换区记录到系统里边echo "/opt/swap swap swap defaults 0 0" >> /etc/fstab查看交互分区大小swapon

5.配置环境变量

vim /opt/soft/prd.shexport softpath=/opt/softexport installpath=/optmkdir -p $softpathsource /opt/soft/prd.sh

6.创建Oracle安装包解压目录

mkdir -p $softpath/oracle/

7.解压Oracle安装包

unzip /opt/soft/linux.x64_11gR2_database_1of2.zip -d $softpath/oracle/unzip /opt/soft/linux.x64_11gR2_database_2of2.zip -d $softpath/oracle/

8.创建用户组，用户

groupadd oinstallgroupadd dbauseradd -g oinstall -g dba -m oracleid oracleuid=1000(oracle) gid=1001(dba) groups=1001(dba)

9创建安装目录

mkdir -p /opt/oracle/product/11.2.0

10.设置配置文件的目录

mkdir -p /opt/oraInventory

11.设置数据库连接对象

mkdir -p /opt/oracle/oradata

12.修改权限

chown -R oracle:dba /opt/oraInventorychmod -R 777 /opt/oraInventorychown -R oracle:dba /opt/oraclechown -R oracle:dba /opt/soft/oracle

13.切换到oracle用户下面，修改 .bash_profile

su - oraclevim .bash_profileexport ORACLE_BASE=/opt/oracleexport ORACLE_OWNER=oracleexport ORACLE_SID=orclexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0export PATH=$PATH:$HOME/bin:.:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/libexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8export LD_LIBRARY_PATH=$ORACLE_HOME/libsource .bash_profile

14.修改系统版本

echo 'redhat-7' > /etc/redhat-releasecat /etc/redhat-releaseredhat-7

15.修改sysctl.conf文件

vim /etc/sysctl.conffs.suid_dumpable=1fs.aio-max-nr=1048576fs.file-max=6815744kernel.shmall=2097152kernel.shmmax=1309440000kernel.shmmni=4096kernel.sem=250 32000 100 128net.ipv4.ip_local_port_range=9000 65500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048586#生效sysctl -p

16.增加参数

vim /etc/security/limits.conforacle soft nofile 1024oracle hard nofile 65536oracle soft nproc 16384oracle hard nproc 16384oracle soft stack 10240

VNC Viewer 操作

17.执行runInstaller开始安装

xhost + 192.168.60.200su - oracleexport DISPLAY=192.168.60.200:1.0/opt/soft/oracle/database/runInstaller -jreLoc /etc/alternatives/jre_1.8.0

18.安装界面

19.拷贝Oracle的命令拷到系统目录上（root用户）

sh /opt/oracle/product/11.2.0/root.sh

20.创建数据库监听

netca

21.配置Net Manager

netmgr

22.创建数据库

dbca