Shulou(Shulou.com)06/01 Report--

Quickly and silently install Oracle11GR2 database and create an instance under linux CentOS7

This article is suitable for use when you are already familiar with the installation process and need to operate installation and deployment quickly.

Commands with multiple lines can be copied and executed together

Beginners suggest learning step by step: https://edu.51cto.com/course/15530.html

Linux.x64_11gR2_database_1of2.zip (download from oracle official website)

Linux.x64_11gR2_database_2of2.zip (download from oracle official website)

Rlwrap-0.42.tar.gz (searched in 51CTO download)

Three installation packages

Operating system environment: minimizing installation of centos7

Create directories, update patches, install dependency packages and create users

Mkdir-p / data/u01/software

Yum-y install lrzsz vim unzip

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba oracle

Echo "Oracle20190728" | passwd-- stdin oracle

Mkdir-p / data/u01/app/oracle/product/11.2.0/dbhome_1

Mkdir / data/u01/app/oracle/ {oradata,inventory,fast_recovery_area}

Chown-R oracle:oinstall / data/u01/app/oracle

Chmod-R 775 / data/u01/app/oracle

Yum-y install gcc gcc-c++ make binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static glibc glibc-common glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel numactl-devel sysstat unixODBC unixODBC-devel kernelheaders pdksh pcre-devel readline*

Yum-y update

Cd / data/u01/software

Ls

II. New session: upload installation package

Cd / data/u01/software

Ls

Upload three packages

III. Modify the configuration file for the new session and install sqlplus

Echo "#" $(date) "quick install oracle11GR2 add vim / etc/sysctl.conf" > > / etc/sysctl.conf

Echo "fs.aio-max-nr = 1048576" > > / etc/sysctl.conf

Echo "fs.file-max = 6815744" > > / etc/sysctl.conf

Echo "kernel.shmall = 2097152" > > / etc/sysctl.conf

Echo "kernel.shmmax = 1073741824" > > / etc/sysctl.conf

Echo "kernel.shmmni = 4096" > > / etc/sysctl.conf

Echo "kernel.sem = 32000 100128" > > / etc/sysctl.conf

Echo "net.ipv4.ip_local_port_range = 9000 65500" > > / etc/sysctl.conf

Echo "net.core.rmem_default = 262144" > > / etc/sysctl.conf

Echo "net.core.rmem_max = 4194304" > > / etc/sysctl.conf

Echo "net.core.wmem_default = 262144" > > / etc/sysctl.conf

Echo "net.core.wmem_max = 1048576" > > / etc/sysctl.conf

Sysctl-p

Echo "#" $(date) "quick install oracle11GR2 add vim / etc/security/limits.conf" > > / etc/security/limits.conf

Echo "oracle soft nproc 2047" > > / etc/security/limits.conf

Echo "oracle hard nproc 16384" > > / etc/security/limits.conf

Echo "oracle soft nofile 1024" > > / etc/security/limits.conf

Echo "oracle hard nofile 65536" > > / etc/security/limits.conf

Echo "oracle soft stack 10240" > > / etc/security/limits.conf

Echo "#" $(date) "quick install oracle11GR2 add vim / etc/pam.d/login" > > / etc/pam.d/login

Echo "session required / lib64/security/pam_limits.so" > > / etc/pam.d/login

Echo "session required pam_limits.so" > > / etc/pam.d/login

Echo "#" $(date) "quick install oracle11GR2 add vim / etc/profile" > > / etc/profile

Echo'if [$USER = "oracle"]; then' > > / etc/profile

Echo'if [$SHELL = "/ bin/ksh"]; then' > > / etc/profile

Echo "ulimit-p 16384" > > / etc/profile

Echo "ulimit-n 65536" > > / etc/profile

Echo "else" > > / etc/profile

Echo "ulimit-u 16384-n 65536" > > / etc/profile

Echo "fi" > > / etc/profile

Echo "fi" > > / etc/profile

Cd / data/u01/software

Tar-xvf rlwrap-0.42.tar.gz

Cd rlwrap-0.42

. / configure

Make

Make install

You need to wait for the upload to be completed.

Unzip linux.x64_11gR2_database_1of2.zip

Unzip linux.x64_11gR2_database_2of2.zip

Su-oracle

Echo "#" $(date) "quick install oracle11GR2 add vim .bash _ profile" > > .bash_profile

Echo "export ORACLE_BASE=/data/u01/app/oracle" > > .bash_profile

Echo "export ORACLE_HOME=/data/u01/app/oracle/product/11.2.0/dbhome_1" > > .bash_profile

Echo "export ORACLE_SID=orcl" > > .bash_profile

Echo 'export ORACLE_UNQNAME=$ORACLE_SID' > > .bash_profile

Echo 'export PATH=$ORACLE_HOME/bin:$PATH' > > .bash_profile

Echo "export NLS_LANG=american_america.AL32UTF8" > > .bash_profile

Echo "alias sqlplus='rlwrap sqlplus'" > > .bash_profile

Echo "alias rman='rlwrap rman'" > > .bash_profile

Source .bash _ profile

Ls

Modify the silent response file and perform the installation

Copy and back up a response file:

Cp-R / data/u01/software/database/response/.

Cd response/

Vim db_install.rsp

Modify the content:

Oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=localhost.localdomain

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/data/u01/app/oracle/inventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME=/data/u01/app/oracle/product/11.2.0/dbhome_1

ORACLE_BASE=/data/u01/app/oracle

Oracle.install.db.InstallEdition=EE

Oracle.install.db.DBA_GROUP=dba

Oracle.install.db.OPER_GROUP=dba

DECLINE_SECURITY_UPDATES=true

Change to the unzipped installation package directory to perform the installation:

Cd / data/u01/software/database/

. / runInstaller-silent-responseFile / home/oracle/response/db_install.rsp-ignorePrereq

Sqlplus / as sysdba

Switch a session to start configuring the instance response file

Configure the response file:

Vim / home/oracle/response/dbca.rsp

Modify the content (note that the # in front of the modification option should be deleted):

GDBNAME = "orcl"

SID = "orcl"

SYSPASSWORD = "enter password"

SYSTEMPASSWORD = "enter password"

SYSMANPASSWORD = "enter password"

DBSNMPPASSWORD = "enter password"

DATAFILEDESTINATION = / data/u01/app/oracle/oradata

RECOVERYAREADESTINATION=/data/u01/app/oracle/fast_recovery_area

CHARACTERSET = "AL32UTF8"

TOTALMEMORY = "2048"

Egrep-v "(^ # | ^ $)" / home/oracle/response/dbca.rsp

Installation creation (wait until step 6 is successful):

Cd ~

Dbca-silent-responseFile / home/oracle/response/dbca.rsp

Lsnrctl start

Start the listener

Lsnrctl stop

Stop listener command.

Lsnrctl status

Check the monitoring status.

The above operation can be completed within 30 minutes of actual measurement.

Complete the above operations in 17 minutes at the earliest

Required skills of operation, maintenance and network management: linux centos7 command line silent installation oracle11GR2 video course video course: http://edu.51cto.com/course/15530.html

Linux CentOS7 minimize installation environment silently install the Oracle11GR2 database (silently create an instance)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.