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

Introduction to complete installation of Oracle 12cOracle under CentOS7

Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. It is a leading product in the field of database. It can be said that Oracle database system is a popular relational database management system in the world at present. The system has good portability, easy to use and strong function, and is suitable for all kinds of large, medium, small and microcomputer environments. It is a database solution with high efficiency and good reliability, which adapts to high throughput.

Preparation before experiment

Oracle installation package

Flash installation package

A hard disk of at least 15g is used to install oracle experimental steps to turn off firewall self-startup, and related functions and enhanced security features systemctl stop firewalld.service setenforce 0 add a hard disk to do Oracle installation disk and format it into xfs format

Fdisk / dev/sdb

Press n to create a new partition

Mkfs-t xfs / dev/sdb1

Format to xfs format

And create a / orc folder to use as the mount point

Mount / dev/sdb1 / orc

Modify the hostname vim / etc/hostname add a HOSTNAME=oracle vim / etc/hosts add a 192.168.x.x Oracle set the native IP hostname to oracle then restart to make it effective init 6 the environment installation package that needs to be prepared before installing oracle yum-y install binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel is adjusted through the yum installation environment package The recommended value for the core parameter vim / etc/sysctl.conffs.aio-max-nr = 1048576 # number of asynchronous IO requests is: 1048576, in fact, it is equal to 1024K fs.file-max = 6815744 # the maximum number of file handles opened. Problem preventing file descriptor exhaustion kernel.shmall = 2097152 # Total shared memory pages Memory divided by 4K kernel.shmmax = 4294967295 kernel.shmmni = 4096kernel.sem = 250100128 # SEMMSL: maximum number of signals per signal set SEMMNS: maximum number of signals used to control the entire Linux system SEMOPM: kernel parameters are used to control the number of signal operations that can be performed per semop system call SEMMNI: kernel parameters are used to control the maximum number of signal sets in the entire Linux system net.ipv4.ip_local _ port_range = 9000 65500 # Port range for outgoing connections net.core.rmem_default = 262144 # default value of socket receive buffer size net.core.rmem_max = 4194304 # maximum socket receive buffer size net.core.wmem_default = 262144 # default value of socket send buffer size net.core.wmem_max = 1048576 # maximum socket send buffer size sysctl -p / / reload configuration file user environment configuration groupadd oinstall # create basic group oinstallgroupadd dba # create additional group dbauseradd-g oinstall-G dba oracle # create user passwd oracle # configuration password mkdir-p / orc/app/oracle # create oracle installation directory chown-R oracle:oinstall / orc/app/ # assign group master chmod-R 755 / orc/app/oracle/ # assign permissions vim / home / oracle/.bash_profile # oracle user environment configuration umask 022 # Anti-mask ORACLE_BASE=/orc/app/oracle # oracle basic directory ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/ # oracle home directory ORACLE_SID=orcl # instance name NLS_LANG= "SIMPLIFIED CHINESE_CHINA" .UTF8 # set the language to Chinese PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/ Bin # set up the system environment LANG=zh_CN.UTF-8export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID # to make the environment effective oracle user resource restrictions

Use pam_limits authentication module

Control oracle by modifying pam vim / etc/pam.d/login add session required / lib/security/pam_limits.sosession required pam_limits.sovim / etc/security/limits.conf to it and finally add oracle soft nproc 2047 # the number of processes available to a single user oracle hard nproc 16384oracle soft nofile 1024 # number of files that users can open oracle hard nofile 65536oracle soft stack 10240 # stack setting vim / etc/profile add if [$USER = "oracle"] then if [$SHELL = "/ bin/ksh"] then ulimit-p 16384 # buffer size ulimit-p 65536 else ulimit-u 16384-n 65536 # processes Number of files fifi installation oracle with root user operating xhost + su-oracle in the graphical interface switching to oracle user cd / database switching to oracle installation package directory export DISPLAY=:0.0./runInstaller performing oracle installation entering the graphical installation interface

Cancel the check box that accepts the update

Select a server class

Set password (password for Super Admin sys)

Finally, when performing the installation to 79%, you need to switch to the root user at the terminal to execute / orc/app/oraInventory/orainstRoot.sh/orc/app/oracle/product/12.2.0/dbhome_1/root.sh to complete the installation.

# finally complete the installation

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.