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

Oracle12c installation

Recommended installation conditions: 4G memory, swap partition 8G, installation directory not less than 20g.

Download the software package from the official website: https://www.oracle.com/downloads/index.html

First, turn off the firewall

Systemctl stop firewalld.service

Systemctl disable firewalld.service

Setenforce 0

2. Mount the disk

Fdisk / dev/sdb

Mkfs-t xfs / dev/sdb1

Mkdir / orc

Mount / dev/sdb1 / orc

Vim / etc/fstab # add auto mount on the last line

/ dev/sdb2 orc xfs defaults 0 0

Third, install the environment package

Yum install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++

Glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel

LibXi libXtst make sysstatunixODBC unixODBC-devel-y

Fourth, enlarge the kernel parameters

Vim / etc/sysctl.conf

Fs.aio-max-nr = 1048576 # number of asynchronous IO requests. Recommended value: 1048576 equals 1024,1024

Fs.file-max = 6815744 # maximum number of open file handles to prevent file descriptor exhaustion

Kernel.shmall = 2097152 # total shared memory, in pages, divided by 4K

Kernel.shmmax = 4294967295 # maximum total shared amount

Kernel.shmmni = 4096 # minimum total shared amount

Kernel.sem = 250 32000 100 128

# SEMMSL: maximum number of signals per signal set

# SEMMNS: used to control the maximum number of signals in the entire Linux system

# SEMOPM: kernel parameters are used to control the number of signal operations that can be performed by each semop system call

# SEMMNI: kernel parameters are used to control the maximum number of signal sets in a Linux system

Net.ipv4.ip_local_port_range = 9000 65500 # Port range for outbound connections

Net.core.rmem_default = 262144 # default value of socket send buffer size

Net.core.rmem_max = 4194304 # maximum size of socket send buffer size

Net.core.wmem_default = 262144 # default value of socket send buffer size

Net.core.wmem_max = 1048576 # maximum size of socket send buffer size

Sysctl-p # refresh takes effect immediately

Create installation groups, administrative groups, and oracle users

Groupadd oinstall # installation group

Groupadd dba # Administrative Group

Useradd-g oinstall-G dba oracle # create oracle user-g specify private group-G specify additional group

Echo "123123" | passwd-- stdin oracle # add a password for oracle users

Create the installation directory, change the main group, and add permissions

Mkdir-p / orc/app/oracle # Recursive create oracle installation directory

Chown-R oracle:oinstall / orc/app # parent group change

Chmod-R 755 / orc/app/oracle/ # add 755 permissions

VII. Configuration of oracle user environment

Vim / home/oracle/.bash_profile # oracle user environment profile

Umask 022

ORACLE_BASE=/orc/app/oracle

ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/

ORACLE_SID=orcl

NLS_LANG= "SIMPLIFIED CHINESE_CHINA" .UTF8

PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin

LANG=zh_CN.UTF-8

Export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID

8. Use pam.limits authentication module

Vim / etc/pam.d/login

Session required / lib/security/pam_limits.so

Session required pam_limits.so

# pam_selinux.so close should be the first session rule # add the above to the line

Vim / etc/security/limits.conf

Oracle soft nproc 2047 # number of processes available to a single user

Oracle hard nproc 16384

Oracle soft nofile 1024 # number of files that can be opened by a single user

Oracle hard nofile 65536

Oracle soft stack 10240 # Stack Settings

The last line of vim / etc/profile # adds the following

If [$USER = "oracle"] # determines whether the login user is oracle

Then

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

Then

Ulimit-p 16384 # buffer size

Ulimit-n 65536 # number of files

Else

Ulimit-u 16384-n 65536 # processes, files

Fi

Fi

9. Mounting

Mkdir / test # create a mount directory

Mount.cifs / / 192.168.88.1/linuxbage / test/ # mount

Cd database/

[root@localhost database] # ls # has the following files

Install response rpm runInstaller sshsetup stage welcome.html

10. Use oracle user installation

Log in with the root user and enter the following command

[root@localhost oracle] # xhost +

Access control disabled, clients can connect from any host

[root@localhost oracle] # su oracle

[oracle@localhost ~] $export DISPLAY=:0.0

Cd / test/database/

[root@localhost database] # ls

Install response rpm runInstaller sshsetup stage welcome.html

. / runinstaller # to install and wait for it to jump to the graphical interface

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.