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

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.

ORACLE database system is a group of software products with distributed database as the core provided by ORACLE (Oracle). It is one of the most popular client / server (CLIENT/SERVER) or Bhand S architecture databases. ORACLE database is the most widely used database management system in the world, as a general database system, it has complete data management function; as a relational database, it is a complete relational product; as a distributed database, it realizes the distributed processing function.

The following is the oracle structure diagram:

Oracle 12C introduces new features of CDB and PDB, allowing a database container (CDB) to host multiple pluggable databases (PDB) in the multi-rent user environment (Multitenant Environment) introduced by ORACLE 12C databases. The full name of CDB is Container Database, the Chinese translation is database container, and the full name of PDB is Pluggable Database. You can plug and unplug the database. Before ORACLE 12C, the instance and database had an one-to-one or many-to-one relationship (RAC): that is, an instance could only be associated with one database, and the database could be loaded by multiple instances. It is impossible for an instance to have an one-to-many relationship with a database. When entering ORACLE 12C, the instance can have an one-to-many relationship with the database.

Installation environment requirements:

Hard disk not less than 50g

Memory not less than 4G

Swap switching partition is not less than 8G

The mounted disk type is xfs

System environment:

CentOS 7

IP:192.168.199.130

Hard disk mount directory / orc

Package link: https://pan.baidu.com/s/1L3uH4h7-xOuT3mMDd1_pIg

Extraction code: jvcx

Oracle official website: https://www.oracle.com/index.html

Next, I will demonstrate the installation:

1 turn off firewall self-startup, as well as related features and enhanced security features

Systemctl disable firewalld.servicesystemctl stop firewalld.servicesetenforce 0

2 change the hostname oracle

Vim / etc/hostnameHOSTNAME=oracle

3 add the mapping between local hostname and local IP address

Vim / etc/hosts192.168.199.130 oracle

4 install the software environment package

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

5 adjust kernel parameters

Vim / etc/sysctl.conffs.aio-max-nr = 1048576 # number of asynchronous IO requests the recommended value is: 1048576 it is actually equal to 1024024, that is, the maximum number of file handles opened by 1024K fs.file-max = 6815744 #, the problem to prevent 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 for socket receive buffer size net.core.rmem_max = 4194304 # maximum socket receive buffer size net.core.wmem_default = 262144 # default value for socket send buffer size net.core.wmem_max = 1048576 # maximum socket send buffer size

Reload the configuration file

Sysctl-p

6 create users and groups and grant permissions to files

Groupadd oinstall # create installation group groupadd dba # create administrator group useradd-g oinstall-G dba oracle # create oracle user passwd oracle/ / password 123123mkdir-p / orc/app/oracle # create oracle working directory chown-R oracle:oinstall / orc/app/chmod-R 755 / orc/app/oracle/

7 user environment configuration

Vim / home/oracle/.bash_profile # oracle user environment configures umask 022 # permissions Set the reverse mask ORACLE_BASE=/orc/app/oracle # specify the base directory ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/ # specify the data storage path ORACLE_SID=orcl # specify the instance name NLS_LANG= "SIMPLIFIED CHINESE_CHINA" .UTF8 # simplified Chinese voice characters Set PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/binLANG=zh_CN.UTF-8export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID

Source / home/oracle/.bash_profile # reload environment variables

8 oracle user resource limit

Use pam_limits authentication module

Vim / etc/pam.d/loginsession required / lib/security/pam_limits.sosession required pam_limits.so

# Editing settings for resources

Vim / etc/security/limits.conforacle soft nproc 2047 # number of processes available to a single user oracle hard nproc 16384oracle soft nofile 1024 # number of files user can open oracle hard nofile 65536oracle soft stack 10240 # stack setting

# modify the configuration file of environment variables

# add in the last line

Vim / etc/profileif [$USER = "oracle"] then if [$SHELL = "/ bin/ksh"] then ulimit-p 16384 # buffer size ulimit-n 65536 else ulimit-u 16384-n 65536 # number of processes fifi

Source / etc/profile # reload environment variables

9 install oracle and mount the extracted database package in Linux / abc

Mkdir / abcmount.cifs / / 192.168.199.1/database / abc

10 the following steps are performed in the graphical interface of linux

Xhost + # operates with root users in a graphical interface

Su-oracle # Toggle oracle user export DISPLAY=:0.0 # Settings graphical interface display cd / abc./runInstaller # execute the script in the abc directory

After executing the runInstaller script, the oracle installation interface appears

When installed to 79%, an interface pops up, which requires that the two scripts be executed by the 'root' user according to its requirements, which can be executed on the remote operation interface.

Execute the first command as the 'root' user first

Then execute the second command, select yes according to the prompt, and enter directly if there is no prompt.

/ orc/app/oracle/product/12.2.0/dbhome_1/root.sh

Performing root user operation.The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / orc/app/oracle/product/12.2.0/dbhome_1Enter the full pathname of the local bin directory: [/ usr/local/bin]: Copying dbhome to / usr/local/bin... Copying oraenv to / usr/local/bin... Copying coraenv to / usr/local/bin... Creating / etc/oratab file...Entries will be added to the / etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Do you want to setup Oracle Trace File Analyzer (TFA) now? Yes | [no]: yesInstalling Oracle Trace File Analyzer (TFA). Log File: / orc/app/oracle/product/12.2.0/dbhome_1/install/root_oracle_2018-10-10-11-41-29-314304832.logFinished installing Oracle Trace File Analyzer (TFA)

After the execution of the two commands, click OK on this interface again.

Finally, click close to complete the installation.

11 when you visit https://192.168.199.130:5500/em on the browser, you can go to the monitoring page of oracle. The login user is' sys', which is the administrator user of oracle. You can fill in the password you set before.

The interface will be displayed after logging in.

Sqlplus / as sysdba # enters the database

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.