硬件條件 4G 2處理器 50G硬盤
oracle12c 在pdb用户界面下,创建全局用户需要为C##
静默安装oracle
yum install -y binutils.x86_64
yum install -y compat-libstdc++-33.i686 compat-libstdc++-33.x86_64
yum install -y elfutils-libelf.x86_64 elfutils-libelf-devel.x86_64
yum install -y gcc.x86_64 gcc-c++.x86_64
yum install -y glibc.i686 glibc.x86_64 glibc-common.x86_64 glibc-devel.i686 glibc-devel.x86_64 glibc-headers.x86_64
yum install -y libaio.x86_64 libaio.i686 libaio-devel.x86_64 libaio-devel.i686
yum install -y libgcc.x86_64 libgcc.i686
yum install -y libstdc++.x86_64 libstdc++.i686 libstdc++-devel.x86_64
yum install -y make.x86_64 sysstat.x86_64
yum install -y unixODBC.i686 unixODBC.x86_64 unixODBC-devel.i686 unixODBC-devel.x86_64
添加域名
vi /etc/hosts
xxxx .com
添加基础优化配置
vi /etc/sysctl.conf
添加如下内容:
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048576
fs.aio-max-nr = 1048576
添加后执行 sysctl –p 命令
vi /etc/security/limits.conf
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 10240
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
oracle soft memlock unlimited
oracle hard memlock unlimited
oracle soft core unlimited
oracle hard core unlimited
更改selinux
vi /etc/selinux
SELINUX=disabled
更改pam模块
vi /etc/pam.d/login
session required pam_limits.so
创建oracle用户
groupadd oinstall
groupadd dba
useradd –g oinstall –G dba –m oracle
passwd oracle
创建数据库存放目录
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oradata
mkdir -p /u01/app/oracle/product
将创建的目录群组信息修改为oracle用户
chown -R oracle:oinstall /u01
进入oracle用户
su -oracle
通过命令 vi ~/.bash_profile 修改Oracle用户配置文件,在配置文件中添加如下内容:
umask 022
export ORACLE_BASE=/u01/app/
export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
先下载包放到oracle安装目录下
/u01/
安装缺少的依赖包
rpm -ivh libaio-0.3.106-3.2.i386.rpm --force;
rpm -ivh compat-libstdc++-33-3.2.3-61.i386.rpm --force;
rpm -ivh libaio-devel-0.3.106-3.2.i386.rpm --force;
rpm -ivh libgcc-4.1.2-46.el5.i386.rpm --force;
rpm -ivh libstdc++-4.1.2-46.el5.i386.rpm --force;
rpm -ivh unixODBC-2.2.11-7.1.i386.rpm --force;
rpm -ivh unixODBC-devel-2.2.11-7.1.i386.rpm --force;
unzip linux.x64_11gR2_database_1of2.zip