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

After reading a lot of Oracle silent installation tutorials on the Internet, I felt a bit messy. After consulting the Oracle official website English manual, combined with the installation test in the virtual machine, I sorted out this RedHat 7 silent installation Oracle 12c. Redhat 6 silent installation of Oracle 11g R2 has also been basically sorted out and will be sent out when there is time.

The original origin of this article: Jiang Jianlong's technology blog http://jiangjianlong.blog.51cto.com/3735273/1792451

I. Environmental requirements and preparation

1. Hardware requirements

(1) disk space

EnterpriseEdition: 6.4GB

StandardEdition: 6.1GB

1 GB of space inthe / tmp directory on your Linux system.

(2) RAM

Minimum: 1 GB of RAM

Recommended: 2 GB ofRAM or more

(3) SWAP

RAM Swap Space

Between 1 GB and 2 GB-1.5 times the size of the RAM

Between2 GB and 16 GB-Equal to the size of the RAM

Morethan 16 GB-16 GB

2. Software requirements

(1) operating system

■ Supported OracleLinux 7 and Red Hat Enterprise Linux 7 Distributions for x86-64

■ Supported OracleLinux 6 and Red Hat Enterprise Linux 6 Distributions for x86-64

■ Supported OracleLinux 5 and Red Hat Enterprise Linux 5 Distributions for x86-64

■ Supported SUSEDistributions for x86-64

Starting with Oracle Database 12c Release 1 (12.1.0.2), Red HatEnterprise Linux 7 (3.10.0-54.0.1.el7.x86_64) are supported on Linuxx86-64 systems.

(2) RPM package requires forRH7

Binutils-2.23.52.0.1-12.el7.x86_64

Compat-libcap1-1.10-3.el7.x86_64

Compat-libstdc++-33-3.2.3-71.el7.i686 (need to download separately)

Compat-libstdc++-33-3.2.3-71.el7.x86_64 (need to download separately)

Gcc-4.8.2-3.el7.x86_64

Gcc-c++-4.8.2-3.el7.x86_64

Glibc-2.17-36.el7.i686

Glibc-2.17-36.el7.x86_64

Glibc-devel-2.17-36.el7.i686

Glibc-devel-2.17-36.el7.x86_64

Ksh

Libaio-0.3.109-9.el7.i686

Libaio-0.3.109-9.el7.x86_64

Libaio-devel-0.3.109-9.el7.i686

Libaio-devel-0.3.109-9.el7.x86_64

Libgcc-4.8.2-3.el7.i686

Libgcc-4.8.2-3.el7.x86_64

Libstdc++-4.8.2-3.el7.i686

Libstdc++-4.8.2-3.el7.x86_64

Libstdc++-devel-4.8.2-3.el7.i686

Libstdc++-devel-4.8.2-3.el7.x86_64

LibXi-1.7.2-1.el7.i686

LibXi-1.7.2-1.el7.x86_64

LibXtst-1.2.2-1.el7.i686

LibXtst-1.2.2-1.el7.x86_64

Make-3.82-19.el7.x86_64

Sysstat-10.1.5-1.el7.x86_64

UnixODBC-2.3.1 orlater

3. Set up domain name resolution

4. Close Transparent HugePages

Log in using root

View: cat / sys/kernel/mm/redhat_transparent_hugepage/enabled

Turn off method:

It is officially recommended to close, but I haven't found a way to close Redhat 7, but it doesn't affect the installation.

5. Create users and groups

Thefollowing local operating system groups and users are required if you areinstalling Oracle Database:

■ The OracleInventory group (typically, oinstall)

■ The OSDBA group (typically, dba)

■ The Oraclesoftware owner (typically, oracle)

■ The OSOPER group (optional. Typically, oper)

# grep dba/etc/group

# id oracle

If the oracle user exists:

# / usr/sbin/usermod-g oinstall-G dba oracle

If the oracle user does not exist:

# / usr/sbin/useradd-g oinstall-G dba oracle

Set the password:

# passwd oracle

6. Create the installation directory

Oracle_Base directory: / u01/app/oracle/

Oracle_Home directory: / u01/app/oracle/12c

Oracle inventory directory: / u01/app/oracle/oraInventory

7. Set resource limits

View method:

$ulimit-Sn

1024

$ulimit-Hn

65536

$ulimit-Su

2047

$ulimit-Hu

16384

$ulimit-Ss

10240

$ulimit-Hs

32768

Modify method:

Vi / etc/security/limits.conf plus the following:

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Oracle hard stack 32768

Oracle soft stack 10240

Note: if Oracle is logged in, you must log out before logging in again.

8. Configure Oracle user environment variables

Vi / home/oracle/.bash_profile, plus the following, the orange part needs to be modified according to your own reality.

Export EDITOR=vi

Export ORACLE_SID=orcl

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/12c

Export nls_date_format= "yyyy-mm-dd hh34:mi:ss"

Export PATH=/u01/app/oracle/12c/bin:$PATH

9. Configure kernel parameters

Note:If the current value for any parameter is greater than the valuelisted in this table, then the Fixupscripts do not change the value of that parameter.

View method:

Modification method: vi / etc/sysctl.conf, modify or add the following:

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 4294967295

Kernel.shmmni = 4096

Kernel.sem = 25032000 100128

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

It is best to reboot, otherwise some parameters will not take effect.

10. Edit / etc/profile

Vi / etc/profile

Add at the end

If [$USER = "oracle"]; then

If [$SHELL = "/ bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

2. Install Oracle software silently

1. Edit the answer file db_install.rsp

There is an answer file in the Oracle installation media. Make a copy to modify it. Change the following contents. The orange part needs to be modified according to your own reality. The other contents in the answer file do not need to be changed. Oracle version: 12.1.0.2

The original origin of this article: Jiang Jianlong's technology blog http://jiangjianlong.blog.51cto.com/3735273/1792451

Oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=rh7

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

SELECTED_LANGUAGES=en,zh_CN

ORACLE_HOME=/u01/app/oracle/12c

ORACLE_BASE=/u01/app/oracle

Oracle.install.db.InstallEdition=EE

Oracle.install.db.DBA_GROUP=dba

Oracle.install.db.OPER_GROUP=oinstall

Oracle.install.db.BACKUPDBA_GROUP=dba

Oracle.install.db.DGDBA_GROUP=dba

Oracle.install.db.KMDBA_GROUP=dba

DECLINE_SECURITY_UPDATES=true

2. Execute the silent installation command

[oracle@rh7 database] $. / runInstaller-silent-ignorePrereq-responseFile / oracle12czip/db_install.rsp

3. Use root login to execute the script after the installation is completed.

4. Configure monitoring

Copy an answer file netca.rsp in the installation media and execute it silently without modification.

[oracle@rh7 oracle12czip] $netca-silent-responseFile / oracle12czip/netca.rsp

Third, silently install the database

1. Edit the answer file dbca.rsp

There is an answer file dbca.rsp in the Oracle installation media. Make a copy to modify it and change the following contents. The orange part needs to be modified according to your own reality, and the other contents in the answer file do not need to be changed.

[GENERAL]

RESPONSEFILE_VERSION = "12.1.0"

OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]

GDBNAME = "orcl"

SID = "orcl"

TEMPLATENAME = "General_Purpose.dbc"

SYSPASSWORD = "p@ssw0rd"

SYSTEMPASSWORD = "p@ssw0rd"

EMCONFIGURATION = "DBEXPRESS"

EMEXPRESSPORT = "5520" # (specify that this parameter does not take effect after installation, and is still the default of 5500)

DBSNMPPASSWORD = "p@ssw0rd"

STORAGETYPE= "FS"

CHARACTERSET = "ZHS16GBK"

NATIONALCHARACTERSET= "AL16UTF16"

MEMORYPERCENTAGE = "40"

TOTALMEMORY = "1024"

2. Execute the silent installation command

$dbca-silent-responseFile / oracle12czip/dbca.rsp

4. Check after installation is completed

1. Check the listening status: $lsnrctl status

2. Check the Oracle process:] $ps-ef | grep ora_ | grep-v grep

3. Log in to Oracle database

SQL > select name from V$database

SQL > select instance_name from V$instance

SQL > select name from V$datafile

SQL > select userenv ('language') from dual

SQL > select * from product_component_version

SQL > show parameter background_dump_dest

4. Log in to EM

Oracle 12c is now silently installed on redhat 7, and you can create tablespaces and users to use.

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.