Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to install Oracle on CentOS7". In daily operation, I believe many people have doubts about how to install Oracle on CentOS7. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to install Oracle on CentOS7". Next, please follow the editor to study!

Overview of Oracle

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.

Brief introduction of Oracle 12C

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. 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.

Oracle 12c architecture diagram

New features in Oracle 12C

1.oracle12c adds the concepts of CDB and PDB.

CDB full name is Container Database, database container

The full name of PDB is Pluggable Database, and you can plug in and unplug the database.

two。 Realize the support of cloud database and provide cloud platform management, which 11g does not have.

Summary of 3.Oracle12c advantages

Installation environment

Installation system: CentOS 7

IP address: 192.168.65.178

Hard disk size: 40g or remount a 40G hard disk

Memory: 4G

SWAP (virtual memory): 8G

Package link: https://pan.baidu.com/s/1XA6WUchSzhxH3qYevF0gxA

Extraction code: v3u6

You can also download https://www.oracle.com/cn directly from the official website.

Installation process 1. Deploy the centos 7 installation environment

1. Download the environment kit

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

two。 Turn off the firewall, security

Systemctl stop firewalld.service

Setenforce 0

3. Change the host name

Vim / etc/hostname # add hostname

Vim / etc/hosts # resolves hostname

4. Modify and adjust kernel parameters

Vim / etc/sysctl.conf

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 4294967295

Kernel.shmmni= 4096

Kernel.sem= 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Fs.aio-max-nr = 1048576 # number of asynchronous IO requests recommended: 1048576 is actually equal to 1024024, that is, 1024K fs.file-max = 6815744 # the maximum number of file handles opened, preventing file descriptor depletion problem kernel.shmall = 2097152 # total shared memory page Memory divided by 4K gives kernel.shmmax = 4294967295 # maximum memory kernel.shmmni = 4096 # minimum memory 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: the kernel parameter is used to control the maximum number of signal sets in the 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 of socket send buffer size net.core.wmem_max = 1048576 # maximum size of socket send buffer size

Sysctl-p # to make it effective

II. Configuration of user environment

1. Create oracle user and password

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba oracle

Passwd oracle

two。 Create an oracle working directory

Mkdir-p / orc/app/oracle

Chown-R oracle.oinstall / orc/app/

Chmod-R 755 / orc/app/oracle/

3. Set environment variabl

Vim / home/oracle/.bash_profile

Delete the last two rows of data insertion first

Umask 022 # create file permissions

ORACLE_BASE=/orc/app/oracle # installation path

ORACLE_HOME=/orc/app/oracle/product/12.2.0/dbhome_1/ # specify the installation product

ORACLE_SID=orcl # instance

NLS_LANG= "SIMPLIFIED CHINESE_CHINA". UTF8 # language is simplified Chinese

The PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin # oracle command imports to environment variables

LANG=zh_CN.UTF-8 # character set

Export PATH LANG NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID # declares the global situation, which is easy for the system to identify.

III. Restrictions on oracle user resources

1. Use pam_limits authentication module

Vim / etc/pam.d/login

Insert under line 7

Session required / lib/security/pam_limits.so

Session required pam_limits.so

two。 Configuration restriction file

Vim / etc/security/limits.conf

Insert at the end

Oracle soft nproc 2047 # number of processes available to users

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

3. Modify environment variabl

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

4. Install Oracle software package

1. Mount the software package to linux 7

Mount.cifs / / 192.168.65.1/database / abc

two。 Log in with the root user before entering the virtual machine

[root@oracle ~] # xhost +

3. Switch Oracle users to install Oracle database

[root@oracle ~] # su-oracle # switch users

[oracle@oracle root] $export DISPLAY=:0.0 # must have this step

[oracle@oracle root] $cd / abc # switch to this directory

[oracle@oracle abc] $ls

Install response rpm runInstaller sshsetup stage welcome.html

[oracle@oracle abc] $. / runInstaller # install the database

Starting Oracle Universal Installer...

4. Enter the graphical installation (the default option is for those without picture presentation)

5. After performing the installation, a dialog box will pop up after 79% of the installation, asking you to run two scripts, and then use the root user to operate, as shown below:

6. Execute configuration script

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

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

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

7. After the installation is complete, use your browser to access https://192.168.65.178:5500/em

Summary:

1. Always pay attention to the installation conditions before installation.

two。 During the graphical installation, pay attention to the switching between root users and Oracle, operating in different environments.

3. When the installation is about 95%, the progress will be very slow, not a mistake, so be patient!

4. After the installation is complete, if you are reminded to download the flash plug-in when browsing the web, you still cannot access it after downloading flash, so switch browsers. Ps: I can't open my 360browser. I just need to change to Sogou browser.

5. It is recommended to use the host browser to access the web page.

6. If you open the web page and show that: this site is not secure, you can click on the details, and then click to go to this page (not recommended) to enter the 12c login interface.

At this point, the study on "how to install Oracle on CentOS7" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.