Centos7.6静默安装Oracle19c

安装步骤

yum -y install bc binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat elfutils-libelf elfutils-libelf-devel fontconfig-devel libxcb smartmontools libX11 libXau libXtst libXrender libXrender-devel

groupadd oinstall
groupadd dba
groupadd asmdba
groupadd backupdba
groupadd dgdba
groupadd kmdba
groupadd racdba
groupadd oper
useradd -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper -m oracle

vi /etc/hosts
172.17.9.210 cos998

vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 16451328
kernel.shmmax = 33692319744
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

sysctl -p

vi /etc/selinux/config
SELINUX=disabled
#SELINUXTYPE=targeted

setenforce 0

systemctl status firewalld.service
systemctl stop firewalld.service  # 停止 firewall
systemctl disable firewalld.service # 禁止 firewall 开机启动

mkdir -p /home/oracle/app/oracle/product/19.5.0
unzip LINUX.X64_193000_db_home.zip -d /home/oracle/app/oracle/product/19.5.0/
cd /home/oracle
chown -R oracle:oinstall app
chmod -R 755 app

vi /etc/security/limits.conf
@oinstall soft nofile 2048
@oinstall hard nofile 65536
@oinstall soft nproc 16384
@oinstall soft stack 10240

su - oracle

vi .bash_profile
export ORACLE_BASE=/home/oracle/app/oracle
export ORACLE_HOME=/home/oracle/app/oracle/product/19.5.0
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin
export ORACLE_HOSTNAME=cos998
export ORACLE_SID=mapgis
export TNS_ADMIN=/home/oracle/app/oracle/product/19.5.0/network/admin
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/network/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

source .bash_profile

cd $ORACLE_HOME/install/response
cp db_install.rsp db_install.rsp.bak
vi db_install.rsp
oracle.install.option=INSTALL_DB_SWONLY       # 29行
UNIX_GROUP_NAME=oinstall              # 34行
INVENTORY_LOCATION=/home/oracle/app/oraInventory  # 41行
ORACLE_HOME=/home/oracle/app/oracle/product/19.5.0  # 45行
ORACLE_BASE=/home/oracle/app/oracle         # 50行
oracle.install.db.InstallEdition=EE         # 62行
oracle.install.db.OSDBA_GROUP=dba         # 79行
oracle.install.db.OSOPER_GROUP=oper         # 85行
oracle.install.db.OSBACKUPDBA_GROUP=backupdba   # 90行
oracle.install.db.OSDGDBA_GROUP=dgdba       # 95行
oracle.install.db.OSKMDBA_GROUP=kmdba       # 100行
oracle.install.db.OSRACDBA_GROUP=racdba       # 105行
oracle.install.db.rootconfig.executeRootScript=false  # 120行
#数据库类型，一般类型
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE # 173行

cd $ORACLE_HOME

./runInstaller -silent -responseFile /home/oracle/app/oracle/product/19.5.0/install/response/db_install.rsp

exit

sh /home/oracle/app/oraInventory/orainstRoot.sh
sh /home/oracle/app/oracle/product/19.5.0/root.sh

su - oracle

cd $ORACLE_HOME/assistants/dbca 

cp dbca.rsp dbca.rsp.bak

vi dbca.rsp
gdbName=mapgis #32行
sid=mapgis #42行
templateName=General_Purpose.dbc #223行
characterSet=ZHS16GBK #468行
sampleSchema=true #565行
totalMemory=2048 #604行
sysPassword=mapgisAa123456
systemPassword=mapgisAa123456

# 这里速度特别慢，千万不要取消掉
nohup dbca -silent -createDatabase -responseFile /home/oracle/app/oracle/product/19.5.0/assistants/dbca/dbca.rsp > ~/dbca.log 2>&1 &

cd $ORACLE_HOME/assistants/netca

cp netca.rsp netca.rsp.bak

netca /silent /responseFile /home/oracle/app/oracle/product/19.5.0/assistants/netca/netca.rsp

vi $TNS_ADMIN/listener.ora
# 添加
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = mapgis)
      (SID_NAME = mapgis)
    )
  )

lsnrctl start

参考

Linux（centos7）静默安装Oracle11gR2

Linux（Centos7）静默安装Oracle19C