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

This article mainly explains "how to install Oracle 11G R2 database in Centos7". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's idea to study and learn "how to install Oracle 11G R2 database in Centos7".

1. Software download

Log on to the Oracle technology website to download Oracle Database 11g version 2, and choose the current system version Linux x86-64 when downloading.

Download path:

Https://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html

two。 System environment preparation

Reference document: https://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm

Hardware environment requirements:

Memory requirements:

Swap space requirements:

Disk space requirements:

Software environment requirements:

The Oracle 11G R2 system version requires:

Package version requirements:

The hardware and system versions used this time are:

Memory: 2GB

CPU:1 kernel

System version: CentOS Linux release 7.6.1810 (Core)

Linux kernel version: 3.10.0-957.21.3.el7.x86_64

Before installing the dependency package, configure the yum source:

View and back up the current yum

[root@localhost oracle_install] # cd / etc/yum.repos.d/

[root@localhost yum.repos.d] # mkdir repo_bak

[root@localhost yum.repos.d] # mv * .repo repo_bak/

Download NetEase and Ali Yun repo files

[root@localhost yum.repos.d] # wget http://mirrors.aliyun.com/repo/Centos-7.repo

[root@localhost yum.repos.d] # wget http://mirrors.163.com/.help/CentOS7-Base-163.repo

[root@localhost yum.repos.d] # ls

CentOS7-Base-163.repo Centos-7.repo repo_bak

Clear the yum cache

[root@localhost yum.repos.d] # yum clean all

Regenerate the yum cache

[root@localhost yum.repos.d] # yum makecache

Install dependency packages

Currently, the operating system is 64-bit, so select the corresponding 64-bit dependency package to install, and if prompted that there is no corresponding dependency package, you can choose to install the new version of

Yum install-y binutils-2.23.52.0.1-12.el7.x86_64

Yum install-y compat-libcap1-1.10-3.el7.x86_64

Yum install-y compat-libstdc++-33-3.2.3-71.el7.x86_64

Yum install-y gcc-4.8.2-3.el7.x86_64

Yum install-y gcc-c++-4.8.2-3.el7.x86_64

Yum install-y glibc-2.17-36.el7.x86_64

Yum install-y glibc-devel-2.17-36.el7.x86_64

Yum install-y ksh

Yum install-y libaio-0.3.109-9.el7.x86_64

Yum install-y libaio-devel-0.3.109-9.el7.x86_64

Yum install-y libgcc-4.8.2-3.el7.x86_64

Yum install-y libstdc++-4.8.2-3.el7.x86_64

Yum install-y libstdc++-devel-4.8.2-3.el7.x86_64

Yum install-y libXi-1.7.2-1.el7.x86_64

Yum install-y libXtst-1.2.2-1.el7.x86_64

Yum install-y make-3.82-19.el7.x86_64

Yum install-y sysstat-10.1.5-1.el7.x86_64

Yum install-y elfutils-libelf-devel.x86_64 00.176-2.el7

Yum install-y unixODBC-2.3.1-14.el7.x86_64

Yum install-y unixODBC-devel-2.3.1-14.el7.x86_64

Create user groups and users

[root@localhost ~] # groupadd oinstall

[root@localhost ~] # groupadd dba

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

[root@localhost ~] # id oracle

Uid=1001 (oracle) gid=1001 (oinstall) groups=1001 (oinstall), 1002 (dba)

[root@localhost ~] # passwd oracle

Create a directory

[root@localhost /] # mkdir-p / db/oracle

[root@localhost /] # mkdir-p / db/oraInventory

[root@localhost /] # mkdir-p / db/database

[root@localhost /] # cd / db

[root@localhost db] # chown-R oracle:oinstall / db/oracle

[root@localhost db] # chown-R oracle:oinstall / db/oraInventory/

[root@localhost db] # chown-R oracle:oinstall / db/database/

Modify the system identity (oracle does not recognize the centos system)

[root@localhost db] # cat / etc/redhat-release

CentOS Linux release 7.6.1810 (Core)

[root@localhost db] # vi / etc/redhat-release

[root@localhost db] # cat / etc/redhat-release

Redhat-7

Modify kernel parameters

[root@localhost db] # vi / etc/sysctl.conf

The contents are as follows:

Net.ipv4.icmp_echo_ignore_broadcasts = 1

Net,ipv4.conf.all.rp_filter = 1

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 536870912

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

Configure oracle user parameters

[root@localhost db] # vi / etc/security/limits.conf

Add:

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Close selinux

[root@localhost yum.repos.d] # vi / etc/selinux/config

Change SELINUX=enforcing to SELINUX=disabled

Restart is required to take effect after setting.

Configure user environment variables

[root@localhost db] # vi / home/oracle/.bash_profile

Additional content:

Export ORACLE_BASE=/db/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Export ORACLE_SID=orcl

Export ORACLE_TERM=xterm

Export PATH=$ORACLE_HOME/bin:$PATH

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Export LANG=C

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

[root@localhost db] # source / home/oracle/.bash_profile

Upload the oracle installation package and extract it

[root@localhost oracle_install] # unzip "* .zip"

[root@localhost oracle_install] # ls

Database linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip

[root@localhost oracle_install] # mv database/ / db/database/

[root@localhost db] # chown-R oracle:oinstall / db/database/database/

3. Database installation

Graphical configuration should be made before installation (root user)

[root@localhost database] # export DISPLAY=:0.0

[root@localhost database] # xhost +

Access control disabled, clients can connect from any host

Graphical settings (oracle users)

[root@localhost database] # su-oracle

[oracle@localhost ~] $vi .bash _ profile

[oracle@localhost ~] $export DISPLAY=:0.0

Graphical configuration is complete and installation begins (oracle user)

[oracle@localhost db] $cd / db/database/database/

[oracle@localhost database] $. / runInstaller

When the installation is complete, you need to execute two scripts under the root user

[root@localhost ~] # / db/oraInventory/orainstRoot.sh

[root@localhost db] # / db/oracle/product/11.2.0/db_1/root.sh

At this point, the database installation is complete.

Thank you for reading, the above is the content of "how to install Oracle 11G R2 database in Centos7". After the study of this article, I believe you have a deeper understanding of how to install Oracle 11G R2 database in Centos7, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.