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

Brief introduction:

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.

The latest version of the Oracle database is Oracle Database 12c. Oracle Database 12c introduces a new multi-tenant architecture that makes it easy to deploy and manage database clouds. In addition, some innovative features maximize resource utilization and flexibility, such as Oracle Multitenant can quickly consolidate multiple databases, while Automatic Data Optimization and Heat Map can compress and layer data at higher density. These unique technological advances, coupled with major enhancements in availability, security, and big data support, make Oracle Database 12c an ideal platform for private and public cloud deployments.

Characteristics

1. Complete data management functions:

1) the large amount of data

2) persistence of data preservation

3) data sharing

4) Reliability of data

2. Products with complete relationships:

1) Information criteria-all information in a relational DBMS should be logically expressed in a way that the values in the table are explicitly represented

2) guidelines for guaranteed access

3) View update criteria-as long as the data in the table that forms the view changes, the data in the corresponding view changes at the same time

4) the independent criterion of data physics and logic.

3. Distributed processing function:

ORACLE database has provided distributed processing capabilities since version 5, and has relatively perfect distributed database functions by version 7. An ORACLE distributed database is composed of oraclerdbms, sqlNet, SQLCONNECT and other non-ORACLE relational products.

4. The operation of data warehouse can be easily realized with ORACLE.

This is a trend of technological development and will not be discussed here.

Advantages

■ is highly available

■ is scalable.

■ data has strong security.

■ has strong stability.

Experimental environment:

Build Oracle12C database on CentOs7

Virtual machine IP:192.168.120.129

The installation package is too large to be shared and can be downloaded from the official website. Https://www.oracle.com/index.html

Specific experimental steps:

-create a new hard drive and format-

[root@localhost ~] # systemctl stop firewalld.service

[root@localhost ~] # systemctl disable firewalld.service

Removed symlink / etc/systemd/system/multi-user.target.wants/firewalld.service.

Removed symlink / etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

[root@localhost ~] # setenforce 0

[root@localhost ~] # cd / dev

[root@localhost dev] # fdisk / dev/sdb

N

P

Enter

Enter

Enter

W

[root@localhost dev] # mkfs-t xfs / dev/sdb1

[root@localhost dev] # mkdir / orc

[root@localhost dev] # vim / etc/hostname

HOSTNAME=oracle

[root@localhost dev] # vim / etc/hosts

192.168.120.129 oracle

Restart the virtual machine

[root@oracle ~] # mount / dev/sdb1 / orc

[root@oracle] # df-h

File system capacity used available used% mount point

/ dev/sda3 20G 4.4G 16G 22% /

Devtmpfs 1.9G 0 1.9G 0% / dev

Tmpfs 1.9G 0 1.9G 0% / dev/shm

Tmpfs 1.9G 9.0M 1.9G 1% / run

Tmpfs 1.9G 0 1.9G 0% / sys/fs/cgroup

/ dev/sda2 40G 33m 40G 1% / opt

/ dev/sda5 20G 36m 20G 1% / home

/ dev/sda1 10G 174m 9.9G 2% / boot

Tmpfs 378m 24K 378m 1% / run/user/0

/ dev/sdb1 40G 33m 40G 1% / orc

-- install Oracle

[root@oracle ~] # yum-y install binutils compat-libcapl compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel

[root@oracle ~] # vim / etc/sysctl.conf

End insert

# the recommended value for the number of asynchronous IO requests is: 1048576, in fact, it equals 1024,1024, that is, 1024k.

Fs.aio-max-nr = 1048576

# the maximum number of open file handles to prevent file descriptors from running out

Fs.file-max = 6815744

# Total shared memory in pages, which is obtained by dividing the memory by 4k

Kernel.shmall = 2097152

# 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 available for each semop system call SEMMNI: kernel parameters are used to control the maximum number of signal sets in the entire Linux system

Kernel.shmmax = 4294967295

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

# Port range for outbound connections

Net.ipv4.ip_local_port_range = 9000 65500

# default value of socket receive buffer size

Net.core.rmem_default = 262144

# maximum size of socket receive buffer

Net.core.rmem_max = 4194304

# default value of socket send buffer size

Net.core.wmem_default = 262144

# maximum size of socket send buffer

Net.core.wmem_max = 1048576

[root@oracle] # sysctl-p # effective

-user environment configuration-

[root@oracle ~] # groupadd oinstall

[root@oracle ~] # groupadd dba

[root@oracle] # useradd-g oinstall-G dba oracle

[root@oracle ~] # passwd oracle

Change the password of user oracle.

New password:

[root@oracle] # mkdir-p / orc/app/oracle

[root@oracle] # chown-R oracle.oinstall / orc/app/

[root@oracle] # chmod-R 755 / orc/app/oracle/

[root@oracle ~] # vim / home/oracle/.bash_profile

Delete the last two rows of data insertion

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

-Oracle user resource limit-

Use pam_limits authentication module

[root@oracle ~] # vim / etc/pam.d/login

Insert under line 7

Session required / lib/security/pam_limits.so

Session required pam_limits.so

[root@oracle ~] # vim / etc/security/limits.conf

Insert at the end

Oracle soft nproc 2047 # but the number of processes available to the user

Oracle hard nproc 16384

Oracle soft nofile 1024 # number of files that users can open

Oracle hard nofile 65536

Oracle soft stack 10240 # Stack Settings

[root@oracle ~] # vim / etc/profile

End insert

If [$USER = "oracle"]

Then

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

Then

Ulimit-p 16384 # buffer size

Ulimit-n 65536 # number of files

Else

Ulimit-u 16384-n 65536 # number of processes and files

Fi

Fi

-- install the Oracle installation package--

[root@oracle ~] # mount.cifs / / 192.168.100.10/database / abc

Password for root@//192.168.100.10/database:

[root@oracle ~] # cd / abc

[root@oracle abc] # ls

Install response rpm runInstaller sshsetup stage welcome.html

Log in with the root user before entering the virtual machine

# switching users

[root@oracle ~] # su-oracle

[oracle@oracle root] $export DISPLAY=:0.0

[oracle@oracle root] $cd / abc

[oracle@oracle abc] $ls

Install response rpm runInstaller sshsetup stage welcome.html

[oracle@oracle abc] $. / runInstaller

Starting Oracle Universal Installer... (just wait, the installation configuration window will pop up automatically)

After the operation is installed, a small window pops up at 79% of the installation, requiring two scripts to be run, which is performed by the root user.

[root@oracle abc] # / orc/app/oraInventory/orainstRoot.sh

Change permissions / orc/app/oraInventory.

Add read and write permissions for the group.

Removes global read, write, and execute permissions.

Change the group name / orc/app/oraInventory to oinstall.

The execution of the script is complete.

[root@oracle abc] # / orc/app/oracle/product/12.2.0/dbhome_1/root.sh

Enter

Yes

Wait for the completion before returning to the graphical interface point to determine and continue with the installation.

It will take a long time to wait. When it is installed, you can visit it with a browser.

Https://192.168.120.129:5500/em # IP is the server IP

Login user name is sys

The password is set by your own graphical interface just now.

-- Log into Oracle--

[root@localhost ~] # su-oracle

[oracle@localhost ~] $sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Saturday September 29 17:16:03 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connect to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit Production

SQL >

The installation of Oracle on linux is complete.

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.