ORACLE12C Database Installation

2.1 Oracle 12c of the Download

first, to the Oracle official website, Register a business user, download oracle12c: http://www.oracle.com/technetwork/database/ Enterprise-edition/downloads/index.html

2.2 Database Installation Configuration2.2.1, shutting down the firewall

Command: sudo systemctl stop firewalld.service && sudo systemctl disable Firewalld.service

2.2.2, checkhostsfile, add host name andIPCorrespondence Record

command:vim/etc/hosts

Press The i key, enter 192.168.2.102 localhost.localdomain (IP and hostname corresponds )

Press ESC exit, enter ": Wq" to save

2.2.3, modifyLinuxKernel

Modify The/etc/sysctl.conf file, enter the command : vim/etc/sysctl.conf, press the i key to enter the editing mode, Modify or add the following, press ESC when editing is complete , enter ": Wq" To save the exit, and then use the command:sysctl-p Make it effective immediately

Kernel.shmmax = 68719476736

Kernel.shmall = 6029312

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Net.ipv4.ip_local_port_range = 9000 65500

fs.file-max=6815744

fs.aio-max-nr=1048576

2.2.3,Modify UserSHELLLimit

input command:vim/etc/security/limits.conf, press the i key to enter edit mode , add the following, edit complete and press Esc Key, enter ": Wq" to Save exit

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

Oracle Soft Stack 10240

Oracle Hard Stack 10240

2.2.4,Modify/etc/pam.d/loginfile

input command:vim/etc/pam.d/login, press the i key to enter the edit , Add the following, after editing, press Esc , enter ": Wq" Save exit

Session required/lib/security/pam_limits.so

2.2.5,CreateOracleUsers and Groups

A: Create a group, using the following command

Groupadd Oinstall

Groupadd dba

B: Create a Orcale user and set a password, such as the following command

Useradd-m-G oinstall-g dba Oracle (-G sets the user's primary user group , which is recorded in /etc/passwd; g Sets the user-attached group, which records In /etc/group )

passwd Oracle

2.2.6,CreateOracleinstallation folder and data storage folder

Mkdir-p/opt/app/oracle

Chown-r oracle:oinstall/opt/app/oracle

chmod 755/opt/app/oracle

Mkdir/opt/app/orainventory

Chown-r oracle:oinstall/opt/app/orainventory

Chmod-r 755/opt/app/orainventory

2.2.7,SetOracleenvironment variables when a user logs on

( switch user from root to oracle user when setting environment variables , command:su Oracle)

Use the command: Vim. Bash_profile(or vim/home/oracle/.bash_profile), press the I key to edit, add the following at the end, press ESC Key, and enter ": Wq", save it, then use the following command to make the setting take effect:source/home/oracle/.bash_profile (or source ~ /.bash_profile)

tmp=/tmp; Export TMP

Tmpdir= $TMP; Export TMPDIR

Oracle_base=/opt/app/oracle; Export Oracle_base

Oracle_home= $ORACLE _base/product/12.1.0/db_1; Export Oracle_home

Oracle_sid=epps; Export Oracle_sid

Oracle_term=xterm; Export Oracle_term

Path=/usr/sbin: $PATH; Export PATH

Path= $ORACLE _home/bin: $PATH; Export PATH

Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib; Export Ld_library_path

Classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib; Export CLASSPATH

if [$USER = "Oracle"]; Then

if [$SHELL = "/bin/ksh"]; Then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

2.3 Installing Oracle Services 2.3.1, where the database installation package is placed

will be U- disk mount to Linux operation: Create a folder to do u -Disk mount, command:mkdir/mnt/usb

Mount the USB drive, command: Mount/dev/sdb4/mnt/usb-t vfat, through the command:fdisk-l, view the u - disk name (can be identified by the format of the USB flash drive: FAT /NTFS/EXFAT)

use command:CP linuxamd64_12102_database_1of2.zip/u01/app/oracle

CP linuxamd64_12102_database_2of2.zip/u01/app/oracle Place compressed files in this directory

2.3.2, decompressionoracle12cDatabase Compression Package

Use the command cd/u01/app/oracle to enter the Oracle folder

Use the command unzip Linuxamd64_12102_database_1of2.zip and unzip Linuxamd64_12102_database_2of2.zip to unzip the compressed package to generate the database folder

Use the command CD to enter database folder

2.3.3, enter the installation interface

input command:"./ Runinstaller", the installation interface can be seen in the LIUNX system

(1, If you cannot see the installation interface, please use the root account to execute the following command before running the Setup program:

# Export display=:0.0

# Xhost +

$./runinstaller

2, if you see the installation interface is garbled, input command:export Lang=en_us, in the Run "./runinstaller")

1, ready to enter the installation interface

2 . Click "Next" button to remove the "I wish to receive security Updatas via My Oracle support" checkbox

3.Select "Install database software only"and click "Next" button

4, the default selection, click on the "Next" button

5. Select "Chinese" and click"Next" button

6, the default selection, click on the "Next" button

7.Default Path, click "Next" button

8, the default path, click on the "Next" button, enter your installation path

9 . do not change the interface, click "Next" button

Check that the rpm package is not installed, do the following:

Checks is a problem with shell configuration, the above configuration has been corrected

Then import the missing packages:

A) under root user, create a yum folder, command:Mkdir/yum,and execute the command:

wget http://mirrors.163.com/centos/7.3.1611/os/x86_64/Packages/yum-3.4.3-150.el7.centos.noarch.rpm

wget http://mirrors.163.com/centos/7.3.1611/os/x86_64/Packages/python-iniparse-0.4-9.el7.noarch.rpm

wget http://mirrors.163.com/centos/7.3.1611/os/x86_64/Packages/yum-metadata-parser-1.1.4-10.el7.x86_64.rpm

wget http://mirrors.163.com/centos/7.3.1611/os/x86_64/Packages/yum-plugin-fastestmirror-1.1.31-40.el7.noarch.rpm

After the download is complete, execute the command: RPM-IVH *.rpm, install

b) execute command:Vim/etc/yum.repos.d/rhel-debuginfo.repo, add the following:

[Base]

name=centos-$releasever-base

baseurl=http://mirrors.163.com/centos/7.3.1611/os/$basearch/

Gpgcheck=1

Gpgkey=http://mirrors.163.com/centos/7.3.1611/os/x86_64/rpm-gpg-key-centos-7

#released Updates

[Updates]

name=centos-$releasever-updates

baseurl=http://mirrors.163.com/centos/7.3.1611/updates/$basearch/

Gpgcheck=1

Gpgkey=http://mirrors.163.com/centos/7.3.1611/os/x86_64/rpm-gpg-key-centos-7

[Extras]

name=centos-$releasever-extras

baseurl=http://mirrors.163.com/centos/7.3.1611/extras//$basearch/

Gpgcheck=1

Gpgkey=http://mirrors.163.com/centos/7.3.1611/os/x86_64/rpm-gpg-key-centos-7

[Centosplus]

name=centos-$releasever-plus

baseurl=http://mirrors.163.com/centos/7.3.1611/centosplus//$basearch/

Gpgcheck=1

Enabled=0

Press "Esc" to enter ":Wq" to save

c) Enter the command in turn: Yum clean all
Yum Update Test (Verify that the installation is successful)

d) install epel source command:yum install Epel-release

e) to see which packages are missing from the installation interface, add by command:Yum install–y package name

Clickon the "check Agin" button to detect the pass, click the "Install" button

to install

Under root user, execute both scripts with the following command:

A)/home/oracle/app/orainventory/orainstroot.sh

b)/home/oracle/app/oracle/product/12.1.0/db_1/root.sh

(cd/home/oracle/app/orainventory./orainstroot.sh

Cd/home/oracle/app/oracle/product/12.1.0/db_1./root.sh)

install successfully, click the "Close" button

ORACLE12C Database Installation