centos 7 安装oracle12c

将主机命名为c120

1. 

hostnamectl set-hostname c120

2. 

vi /etc/hosts
#添加如下内容
192.168.3.1 c120 #IP +主机名

3. 

vi /etc/sysctl.conf

 添加如下内容

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

保存退出 

sysctl -p

4. 

vi /etc/security/limits.conf

添加如下内容： 

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
oracle   hard   memlock    134217728
oracle   soft   memlock    134217728

 5.

安装依赖包，耐心等它跑完就行
yum install binutils -y
yum install compat-libcap1 -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install make -y
yum install nfs-utils -y
yum install net-tools -y
yum install smartmontools -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y

 6.

#创建安装oracle12c需要的用户组和用户，oinstall组用于安装数据库，dba组用于管理数据库，-g表示这个用户的主组，-G标识这个用户的其它组
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
 
useradd -u 54321 -g oinstall -G dba,oper oracle
 
passwd oracle

 7.

#设置SELINUX
vi /etc/selinux/config
 
#该更内容 SELINUX=permissive
 
setenforce Permissive
#关闭防火墙
systemctl stop firewalld
systemctl disable firewalld
#创建Oracle安装目录
mkdir -p /usr/local/products/oracle12c
chown -R oracle:oinstall /usr/local
chmod -R 775 /usr/local/

 

8.

#切换到oracle用户
su - oracle
#在最后添加如下内容
vi .bash_profile
export TMP=/tmp
export TMPDIR=$TMP
 
export ORACLE_HOSTNAME=solang
export ORACLE_UNQNAME=cdb1
export ORACLE_BASE=/usr/local/products
export ORACLE_HOME=$ORACLE_BASE/oracle12c
export ORACLE_SID=cdb1
 
export PATH=/usr/sbin:/usr/local/bin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
 
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 9.

#立即生效
source .bash_profile
echo $ORACLE_HOME

 

10 

 将oracle12c压缩包上传到  /home/oracle 目录下 并解压

unzip linuxx64_12201_database.zip

 

 11.

cd database/response/
 
vi db_install.rsp 
 
#编辑db_install.rsp，对应修改

oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/usr/local/oraInventory
ORACLE_HOME=/usr/local/products/oracle12c
ORACLE_BASE=/usr/local/products
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba

 12.

# su - oracle 在oracle用户下操作
cd ~/database
 
#静默安装oracle12c

./runInstaller -ignoreSysPrereqs -ignorePrereq -waitforcompletion \ -showProgress -silent -responseFile /home/oracle/database/response/db_install.rsp

 

13.

#切换到root用户
su
/usr/local/oraInventory/orainstRoot.sh
/usr/local/products/oracle12c/root.sh

 14.

#数据库创建，使用数据库配置助手DBCA静默模式下创建数据库


dbca -silent -createDatabase \
 -templateName /usr/local/products/oracle12c/assistants/dbca/templates/General_Purpose.dbc \
 -gdbname cdb1 -sid cdb1 -responseFile /home/oracle/database/response/dbca.rsp \
 -characterSet AL32UTF8 \
 -sysPassword OraPasswd1 \
 -systemPassword OraPasswd1 \
 -createAsContainerDatabase true \
 -numberOfPDBs 1 \
 -pdbName pdb1 \
 -pdbAdminPassword OraPasswd1 \
 -automaticMemoryManagement false \
 -ignorePreReqs

 15.

#配置监听，使用默认的netca.rsp文件
netca -silent -responseFile /home/oracle/database/response/netca.rsp

这里是一个极其漫长的等待，报错请重新执行这个语句

16.

修改为本机的主机名和oracle对应端口1521
su 切换到root授权listener.ora
chmod -R 775 /usr/local/products/oracle12c/network/admin/listener.ora
su - oracle
vi /usr/local/products/oracle12c/network/admin/listener.ora
 
#启动监听
lsnrctl start

lsnrctl status

 

 17. 下面都在root用户下执行

#将N修改为Y
vi /etc/oratab

 

 18.

vi /etc/init.d/dbora
#修改如下
 
#! /bin/sh
# description: Oracle auto start-stop script.
#
# Set ORACLE_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORACLE_HOME.
 
ORACLE_HOME=/usr/local/products/oracle12c
ORA_OWNER=oracle
 
case "$1" in
'start') 
    # Start the Oracle databases:
    # The following command assumes that the oracle login
    # will not prompt the user for any values
    # Remove "&" if you don't want startup as a background process.
    su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME" &
    touch /var/lock/subsys/dbora
    ;;
 
'stop')
    # Stop the Oracle databases:
    # The following command assumes that the oracle login
    # will not prompt the user for any values
    su - $ORA_OWNER -c "$ORACLE_HOME/bin/dbshut $ORACLE_HOME" &
    rm -f /var/lock/subsys/dbora
    ;;
esac
 

export ORA_OWNER=oracle
echo $ORA_OWNER     #ORA_OWNER设置为oracle用户

 

 19

#修改dbora组和文件权限
chgrp dba /etc/init.d/dbora
chmod 750 /etc/init.d/dbora

20.

#创建符号链接
ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora
 

 21,oracle用户下执行

#Oracle数据库开机自动启动，在oracle用户中单独启动和关闭数据库
 
$ORACLE_HOME/bin/dbstart $ORACLE_HOME
$ORACLE_HOME/bin/dbshut $ORACLE_HOME

 

 22.查看数据库是否安装成功：

 

Centos7安装oracle12c_centos7 oracle12c 安装-CSDN博客