Oracle19C安装 单实例 -- 静默安装

                    Oracle19C安装 单实例 -- 静默安装

创建用户，配置yum安装oracle_preinstall，修改系统限制参数，修改系统内核，创建目录，修改权限，配置oracle用户环境变量。

清参考 https://blog.csdn.net/ghl0451/article/details/108197788

groupadd -g 5001 dba
groupadd -g 5002 asmdba
groupadd -g 5003 backupdba
groupadd -g 5004 dgdba
groupadd -g 5005 kmdba
groupadd -g 5006 racdba
groupadd -g 5007 oper
groupadd -g 5008 oinstall
useradd -u 5000 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle
wget http://yum.oracle.com/public-yum-ol7.repo -O /etc/yum.repos.d/public-yum-ol7.repo
wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
yum install oracle-database-preinstall-19c.x86_64 -y
rpm -ivh /softwares/oracle-database-ee-19c-1.0-1.x86_64.rpm

echo "
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
oracle   soft   data    unlimited
oracle   hard   data    unlimited
" >> /etc/security/limits.conf

echo "
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
" >> /etc/sysctl.conf
sysctl -p

mkdir -p /u01/app/oracle/product/19.3.0/db_1
chown -R oracle:oinstall /u01
echo "
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1
export ORACLE_SID=HPCDW
export LANG=en_US.UTF-8
export PATH=.:\${PATH}:\${ORACLE_HOME}/bin
export LD_LIBRARY_PATH=\${ORACLE_HOME}/lib:\${LD_LIBRARY_PATH}
" >> /home/oracle/.bash_profile

响应文件

[oracle@ghlhost ~]$ cat db.rsp 
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0
oracle.install.option=INSTALL_DB_AND_CONFIG
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_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
oracle.install.db.rootconfig.executeRootScript=true
oracle.install.db.rootconfig.configMethod=ROOT
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=HPCDW
oracle.install.db.config.starterdb.SID=HPCDW
oracle.install.db.config.starterdb.password.ALL=******
oracle.install.db.ConfigureAsContainerDB=false
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=1580
oracle.install.db.config.starterdb.installExampleSchemas=true
oracle.install.db.config.starterdb.managementOption=DEFAULT
oracle.install.db.config.starterdb.omsPort=0
oracle.install.db.config.starterdb.enableRecovery=false
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u01/app/oracle/oradata
[oracle@ghlhost ~]$

 修改相应的密码
oracle.install.db.config.starterdb.password.ALL=******

上传数据库软件到$ORACLE_HOME,并解压

开始静默安装数据库

[oracle@ghlhost ~]$ $ORACLE_HOME/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /home/oracle/db.rsp
Launching Oracle Database Setup Wizard...

[WARNING] [INS-32047] The location (/u01/app/oraInventory) specified for the central inventory is not empty.
   ACTION: It is recommended to provide an empty location for the inventory.
[WARNING] [INS-30011] The ADMIN password entered does not conform to the Oracle recommended standards.
   CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
   ACTION: Provide a password that conforms to the Oracle recommended standards.

 Enter password for 'root' user: 
[WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2020-08-24_04-29-47PM.log
   ACTION: Identify the list of failed prerequisite checks from the log: installActions2020-08-24_04-29-47PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
 /u01/app/oracle/product/19.3.0/db_1/install/response/db_2020-08-24_04-29-47PM.rsp

You can find the log of this install session at:
 /tmp/InstallActions2020-08-24_04-29-47PM/installActions2020-08-24_04-29-47PM.log
Successfully Setup Software with warning(s).
As install user, execute the following command to complete the configuration.
	/u01/app/oracle/product/19.3.0/db_1/runInstaller -executeConfigTools -responseFile /home/oracle/db.rsp [-silent]


Moved the install session logs to:
 /u01/app/oraInventory/logs/InstallActions2020-08-24_04-29-47PM

按照提示执行
 

[oracle@ghlhost ~]$ /u01/app/oracle/product/19.3.0/db_1/runInstaller -executeConfigTools -responseFile /home/oracle/db.rsp -silent
Launching Oracle Database Setup Wizard...

You can find the logs of this session at:
/u01/app/oraInventory/logs/InstallActions2020-08-24_04-37-37PM

Successfully Configured Software.
[oracle@ghlhost ~]$

测试连接数据库

[oracle@ghlhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 24 17:05:10 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select sysdate from dual;

SYSDATE
---------
24-AUG-20

SQL>

监听配置

[oracle@ghlhost admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ghlhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = HPCDW)
      (ORACLE_HOME = /u01/app/oracle/product/19.3.0/db_1)
      (SID_NAME = HPCDW)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = HPCDW)
      (SID_NAME = HPCDW)
    )
  )

配置数据库随系统启动
请参考 https://blog.csdn.net/ghl0451/article/details/108197788