CENTOS7 installation oracle-12c

CENTOS7-ORACLE12C installation One, Oracle Introduction

1, large-scale relational database (E-r map)
2. Oracle (Java)
3. UNIX, Linux, Windows support
4. Oracle Release version
5. Database (software + database) MySQL
6, the default only one database

II. installation of Oracle installation conditions

1, 1G or more memory, swap for memory twice times or more
1G-1000M (actual use)
1G-1024M (standard size)
2. Package
3. Kernel parameter adjustment
4, user new, directory permissions settings
5. User Resource Limit
6. Installation
Note: Installing CentOS 6 (x64) or "Red Hat Enterprise 5.8 (x64) is the official recommended version of the most stable Oracle server system and supports the Chinese boot interface" to disable the firewall, SELinux, and install software development, Here I will install using ORACLE12C.

Lab Environment:
System: centos7-3.10.0-514.el7.x86_64 ip:192.168.152.156
Memory: 6GB Swap swap partition: 12GB
Oracle Software: Linuxamd64_12102_database_1of2 LINUXAMD64_12102_DATABASE_2OF2

Installing the Desktop GNOME environment (real-World recommendations using command installation)
Command:
1) yum-y Install gnome-classic-session gnome-terminal
Nautilus-open-terminal Control-center liberation-mono-fonts

2) yum-y groupinstall "X window System"

Third, install the dependency package

1, modify the domain name Vi/etc/sysconfig/network

2. Modify the hostname vi/etc/hosts

Note: The modification completes restarting the machine

3. Install dependent packages
Yum-y install binutils compat-libcap1 gcc gcc-c++ glibc
Glibc-devel ksh Libaio libaio-devel libgcc libstdc++
Libstdc++-devel libxi libxtst make Sysstat elfutils-libelf-devel
compat-libstdc++-33*

4. Turn off firewall and SELinux

1) Turn off firewall systemctl stop Firewalld.service
2) prohibit firewall from starting systemctl disable Firewalld.service

3) Turn off SELINUX sed-i ' s/selinux=enforcing/selinux=disabled/g '
/etc/sysconfig/selinux

Iv. Modifying kernel parameters

1. Edit Kernel parameter vi/etc/sysctl.conf
FS.AIO-MAX-NR = 1048576
Fs.file-max = 6815744
Kernel.shmall = 2097152
Kernel.shmmax = 4098955264
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Net.core.wmem_default = 262144
Net.core.rmem_default = 262144
Net.ipv4.ip_local_port_range = 9000 65500
Net.core.rmem_max = 4194304
Net.core.wmem_max = 1048576

2. Verification parameter Sysctl–p

V. Create users and Groups

1. Create basic groups and additional groups
Groupadd-g Oinstall
GROUPADD-G 501 DBA

2. Create user useradd-g oinstall-g dba Oracle

3. Set the password for the user
echo "123" | passwd--stdin Oracle

4. Create Oracle home directory and create orainventory directory
Mkdir-p/home/oracle/app/oracle
Mkdir/home/oracle/app/orainventory

5. Change of owner and owner Group
Chown oracle:oinstall/home/oracle/app/oracle
Chown Oracle:oinstall/home/oracle/app/orainventory

6. Change the Oracle directory permissions chmod 775/home/oracle/app/oracle

7. Edit the Oracle environment variable Vi/home/oracle/.bash_profile
Umask 022
Export Oracle_base=/home/oracle/app/oracle
Export Oracle_home= $ORACLE _base/product/11.2/db_1
Export ORACLE_SID=ORCL
Export Lang=en_us. UTF-8
Export nls_lang= "American_america". Zhs16gbk
Export path= $PATH: $ORACLE _home/bin
Export display=192.168.152.158:0.0

Note: If the remote test must have a real machine NIC IP and export display this line is the same, but I am testing in the local virtual machine so do not need to add this line, save exit after the source executes the file.

8. Edit the Oracle Security Authentication Module Vi/etc/pam.d/login
Session required/lib64/security/pam_limits.so
Session Required Pam_limits.so

9. Edit Oracle Resource Limit vi/etc/security/limits.conf
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536
Oracle Soft Stack 10240

10. Edit Global environment variable Vi/etc/profile
if [$USER = "Oracle"];then
if [$SHELL = "/bin/ksh"];then
Ulimit-p 16384
Ulimit-p 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi

VI. Installation of Oracle database

1. Upload Oracle software package

2. Copy the package to the Oracle home directory
CP linuxamd64_12102Database*/home/oracle

3. Change the Oracle home directory package owner and owner group to Oracle and Oinstall
Chown oracle:oinstall/home/oracle/linuxamd64_12102Database*

4. Switch to Oracle user su Oracle

5. Unpack the Package
Unzip Linuxamd64_12102_database_1of2.zip
Unzip Linuxamd64_12102_database_2of2.zip

6. There are two ways to test errors
Mode one: Remote execution, first open Xshell in the passive and then execute xhost+
Mode two: Local desktop root login, switch Oracle User (as normal)

7. Execute the installation script./database/runinstaller

8, uncheck, do not receive security updates, and then click "Next", pop up the prompt window, select Yes

9, according to their own needs to choose, I here choose the first new database, and then click Next
(1) Create and configure a database (2) Install only database software (3) upgrade an existing database

10, because we are based on the server so select the second, and then click Next
(1) Desktop class: If you want to install in a notebook or desktop class system, select this option, which includes starting the database and allowing the lowest configuration
(2) Server class: Select this option if you want to install in a server class system (such as what is used when deploying Oracle in a production datacenter), this option allows more advanced configuration options to be used

11, because we are testing the database, the second is a cluster, so select the first and then click Next
(1) Single Instance database installation
(2) Real application clusters database Installation
(3) Oracle RAC Node Database installation

12, we select the second, Advanced configuration installation, and then click Next
(1) Typical installation: Perform a complete Oracle database installation using basic configuration
(2) Advanced installation: You can choose advanced options, for example: use different passwords for SYS, Sysman, System and DBSNMP accounts, select database character set, product language, automatic backup, custom installation and alternative storage options (e.g. automatic storage management)

13, the default has been added English in the left language list to find the simplified SimplifiedChinese,
and add to the right, then click Next

14, because we are doing enterprise server so choose the first one, then click Next
(1) Enterprise Edition: A self-managed database with scalability, high performance, high availability, and security features to
Meet the needs of most high-standard mission-critical applications.
(2) Standard Edition: Standard Edition is ideal for working groups, departments, and small and medium-sized businesses looking for low-cost solutions.
(3) Standard Edition 1: Standard Edition 1 is the ideal choice for working groups, departments, and SMEs looking for low-cost solutions.

15. Use the path to the default installation directory, or change it as appropriate, then click Next

16. Use the path to the default installation directory, or change it as appropriate, then click Next

17, choose the configuration type, according to the needs of the choice, here I choose the first, and then click Next
(1) General purpose/Transaction processing: A startup database designed for general purpose or high transaction throughput applications.
(2) Data Warehouse: A startup database optimized for Data warehouse applications

18. Specify the Oracel global database name and service identifier as: ORCL, then click Next

19. Tick Enable automatic memory management in the memory page, select Use Unicode in the character set page, and
Then click Next

20. Use the default selected file system database, then click Next

21, do not use centralized cloud control management, directly click Next

22. Select Open Recovery area storage, default path, then click Next

23 Here I choose to use the same password for all accounts Wangfeiyu123, can also be for different users
Set a different password, then click Next

24. Set DBA, Database Operations Group Oinstall, then click Next

25, if the error is prompted, because the version of the installation package is different or the kernel parameters have a problem or less dependent
Software, you need to resolve the error, and then click Next (if it does not match the next two figures, and for error)

26, check the installation summary, if there is no problem, you can click Finish to finish the configuration, to start the installation


Note:
Mode one: When appearing as above, you need to execute both scripts in the Shell interface with the root user.
Mode two: Direct Click OK if it will error, then open a shell, with the root user to execute the command then, in return to this interface click OK (two ways to choose one, the first recommended)




Note: The installation of oracle12c on CENTOS7 is complete!

Web test: https://(host name or IP): 5500/em

CENTOS7 installation oracle-12c