Oracle Silent Installation detailed tutorial, oracle silent tutorial

Oracle Silent Installation detailed tutorial, oracle silent tutorial

Environment Centos7 mini: 2 GB memory, oracle 12.2.0.1, under vmvm

Networking

# vi /etc/sysconfig/network-scripts/ifcfg-ens33

TYPE=EthernetPROXY_METHOD=noneBROWSER_ONLY=noBOOTPROTO=staticDEFROUTE=yesIPV4_FAILURE_FATAL=noIPV6INIT=yesIPV6_AUTOCONF=yesIPV6_DEFROUTE=yesIPV6_FAILURE_FATAL=noIPV6_ADDR_GEN_MODE=stable-privacyNAME=ens33UUID=5452944f-bc02-4ffd-aaae-8f6025c52643DEVICE=ens33ONBOOT=yesDNS1=114.114.114.114IPADDR=192.168.2.50PREFIX=24GATEWAY=192.168.2.1PEERDNS=no 

Restart network connection

# service network restart

Test

# ping baidu.com

Edit the hosts file

# vi /etc/hosts

Add a row

192.168.2.50 centos7

Test

ping centos7

Preparation

Update System Software

# yum -y update

Configure/etc/sysctl. conf

# vi /etc/sysctl.conf

The content is as follows:

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  

Make the configuration take effect

# /sbin/sysctl -p

Configure/etc/security/limits. d/20-nproc.conf

The Append content is as follows:

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  

Install zip and unzip

# yum install zip unzip

Install dependency

yum install -y binutils \compat-libcap1 \compat-libstdc++-33 \compat-libstdc++-33.i686 \glibc \glibc.i686 \glibc-devel \glibc-devel.i686 \ksh \libaio \libaio.i686 \libaio-devel \libaio-devel.i686 \libX11 \libX11.i686 \libXau \libXau.i686 \libXi \libXi.i686 \libXtst \libXtst.i686 \libgcc \libgcc.i686 \libstdc++ \libstdc++.i686 \libstdc++-devel \libstdc++-devel.i686 \libxcb \libxcb.i686 \make \nfs-utils \net-tools \smartmontools \sysstat \unixODBC \unixODBC-devel   gcc \ gcc-c++ \ libXext \ libXext.i686 \ zlib-devel \ zlib-devel.i686

Create users and user groups

# groupadd -g 1001  oinstall# groupadd -g 1002 dba # groupadd -g 1003 oper# useradd -u 1001 -g oinstall -G dba,oper oracle# passwd oracle

Disable firewall and selinux

# vi /etc/selinux/config

SELINUX=disabled

# systemctl stop firewalld# systemctl disable firewalld

Create directory modification permission

# mkdir -p /u01/app/oracle/product/12.2.0.1/db_1# chown -R oracle:oinstall /u01# chmod 775 /u01

# Configuring oracle environment variables

#  vi /home/oracle/.bash_profile

The content is as follows:

        . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/.local/bin:$HOME/binexport PATH# Oracle Settingsexport TMP=/tmp  export TMPDIR=$TMP    export ORACLE_HOSTNAME=centos7  export ORACLE_UNQNAME=orclexport ORACLE_BASE=/u01/app/oracle  export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1  export ORACLE_SID=orcl  export PATH=/usr/sbin:$PATH  export PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib 

Restart and switch oracle users

# reboot

Extract

 unzip linuxx64_12201_database.zip

Install

Edit response File

vi database/response/db_install.rsp

The modification content is as follows:

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0  oracle.install.option=INSTALL_DB_SWONLY  UNIX_GROUP_NAME=oinstall  INVENTORY_LOCATION=/u01/app/oracle/oraInventory  ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1  ORACLE_BASE=/u01/app/oracle  oracle.install.db.InstallEdition=EEoracle.install.db.OSDBA_GROUP=dbaoracle.install.db.OSOPER_GROUP=oper 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.config.starterdb.type=GENERAL_PURPOSE  oracle.install.db.config.starterdb.globalDBName=orcloracle.install.db.config.starterdb.SID=orcloracle.install.db.config.starterdb.characterSet=AL32UTF8  SECURITY_UPDATES_VIA_MYORACLESUPPORT=false  DECLINE_SECURITY_UPDATES=true 

Install [Note that the absolute path is required for the response file]

$ ./runInstaller -force -silent -noconfig -responseFile /home/oracle/database/response/db_install.rsp

Use the root user group to execute the script

# /u01/app/oracle/oraInventory/orainstRoot.sh

# /u01/app/oracle/product/12.2.0.1/db_1/root.sh

Add listener

 cat netca.rsp | grep -Ev "^#|^$"

netca -silent -responsefile /home/oracle/database/response/netca.rsp

View listener status

$ lsnrctl status

Create a database

Modify the file/home/oracle/database/response/dbca. rsp

The content is as follows:

responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0  gdbName=orcl sid=orcldatabaseConfigType=SI  RACOneNodeServiceName=  policyManaged=false  createServerPool=false  serverPoolName=  cardinality=  force=false  pqPoolName=  pqCardinality=  createAsContainerDatabase=true  numberOfPDBs=1  pdbName=cdb1pdb  useLocalUndoForPDBs=true  pdbAdminPassword=  nodelist=  templateName=/u01/app/oracle/product/12.2.0.1/db_1/assistants/dbca/templates/General_Purpose.dbc  sysPassword=  systemPassword=  serviceUserPassword=  emConfiguration=  emExpressPort=5500  runCVUChecks=false  dbsnmpPassword=  omsHost=  omsPort=0  emUser=  emPassword=  dvConfiguration=false  dvUserName=  dvUserPassword=  dvAccountManagerName=  dvAccountManagerPassword=  olsConfiguration=false  datafileJarLocation={ORACLE_HOME}/assistants/dbca/templates/  datafileDestination={ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/  recoveryAreaDestination={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}  storageType=FS  diskGroupName=  asmsnmpPassword=  recoveryGroupName=  characterSet=AL32UTF8  nationalCharacterSet=AL16UTF16  registerWithDirService=false  dirServiceUserName=  dirServicePassword=  walletPassword=  listeners=LISTENER  variablesFile=  variables=DB_UNIQUE_NAME=orcl,ORACLE_BASE=/u01/app/oracle,PDB_NAME=,DB_NAME=orcl,ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/db_1,SID=orcl  initParams=undo_tablespace=UNDOTBS1,memory_target=796MB,processes=300,db_recovery_file_dest_size=2780MB,nls_language=AMERICAN,dispatchers=(PROTOCOL=TCP) (SERVICE=orclXDB),db_recovery_file_dest={ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME},db_block_size=8192BYTES,diagnostic_dest={ORACLE_BASE},audit_file_dest={ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump,nls_territory=AMERICA,local_listener=LISTENER_ORCL,compatible=12.2.0,control_files=("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/fast_recovery_area/{DB_UNIQUE_NAME}/control02.ctl"),db_name=orcl,audit_trail=db,remote_login_passwordfile=EXCLUSIVE,open_cursors=300  sampleSchema=false  memoryPercentage=40  databaseType=MULTIPURPOSE  automaticMemoryManagement=true  totalMemory=0  

Enter Password

$ dbca -silent -createDatabase  -responseFile  /home/oracle/database/response/dbca.rsp

Login

sqlplus / as sysdba

View database status

select open_mode from v$database;

Installation Complete