To study the linux After this course , It's time to practice , That's a good way to remember , Put this to use .

With the basic command , You can try to install the database .

  1. Business environment

Need to install VMWare ESXi virtual Simulacrum , And then create a new virtual machine in it .

Mirror image vmware-viclient-all-5.1.0-1064113-5.1.exe

You can use the client VMware vSphere Client 6.0 Remote connection ESXi virtual machine , Then install the operating system .

  1. Connect the host and create a new virtual machine

stay ESXi After the virtual machine has installed the operating system ,Linux Can't paste solution

Name       Value

isolation.tools.copy.disable    false

isolation.tools.paste.disable    false

3.Linux After the completion of the operating system database configuration . How can I learn to install the database ? Only you learn the basics , skilled Linux command , That's how it works . For you without foundation , You need to learn the basics first , First, learn the basics , Then you'll know every step of installing the database .

4. Practice needs a theoretical basis . Turn off firewall ,selinux, Set static network and startup items , Check if there is a problem with the network configuration . This is a centoes or Linux7 Version of command , But it's all universal ,Linux6 Or the following version is service iptables stop

Turn off firewall :

[root@khapp15 ~]# systemctl stop firewalld    # Stop firewall service

[root@khapp15 ~]# systemctl disable firewalld  # Do not start

close SELINUX

[root@khapp15 ~]# vim /etc/sysconfig/selinux

SELINUX=disabled

#SELINUXTYPE=targeted   # Comment out

[root@khapp15 ~]# setenforce 0    # close selinux

setenforce 0 # Give Way SELinux Get into Permissive Pattern ( Tolerance mode )

SELiunx There are three modes :

enforcing( Forced mode ): Start limiting domain/type

permissive( Tolerance mode ) : There will only be warning messages

disabled( close ): close SELinux

[root@khapp15 ~]#/usr/sbin/sestatus -v     # see SELinux state

And then network configuration , This is the most critical , The network configuration is not good , There will be problems .

[root@khapp15 ~]# vim /etc/sysconfig/network-scripts/ifcfg-ens33

# The red part needs attention

TYPE=Ethernet

PROXY_METHOD=none

BROWSER_ONLY=no

BOOTPROTO=static  # static state IP

DEFROUTE=yes

IPV4_FAILURE_FATAL=no

IPV6INIT=yes

IPV6_AUTOCONF=yes

IPV6_DEFROUTE=yes

IPV6_FAILURE_FATAL=no

IPV6_ADDR_GEN_MODE=stable-privacy

NAME=ens33

UUID=59efd265-266c-4355-9a50-11961f1523bc

DEVICE=ens33

ONBOOT=yes  # Boot up

IPADDR=172.22.0.203   # It needs to be in the same environment as the company

PREFIX=255.255.252.0     # It needs to be in the same environment as the company

GATEWAY=172.22.0.1  # It needs to be in the same environment as the company

DNS1=8.8.8.8

IPV6_PRIVACY=no

Restart NIC

[root@khdata16 ~]# systemctl restart network or service restart network

5. Create user , And set the password , This is 《Linux It's time to learn 》 It can be found in , The first one is about these basic commands .

[root@khapp15 ~]# useradd oracle

[root@khapp15 ~]# passwd oracle

123456

6. mount this database yum, To configure yum, This is a must learn, must know , If you forget , You can check it out 《Linux It's time to learn 》 This book , Step by step .

Install dependency packages

Common installation packages

[root@khdata16 khtool]# yum -y install autoconf automake binutils-devel bison cpp dos2unix ftp gcc gcc-c++ lrzsz python-devel

oracle Must depend on the package

[root@khdata16 khtool]# yum -y install compat-db compat-gcc-34 compat-gcc-34-c++ compat-libstdc++-33 glibc-* glibc-*.i686 libXpm-*.i686 libXp.so.6 libXt.so.6 libXtst.so.6 libgcc_s.so.1 ksh libXp libaio-devel numactl numactl-devel unixODBC unixODBC-devel

# Second version , It is suggested that we implement it again

[root@khdata16 khtool]# yum -y install binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 glibc-headers ksh libaio libaio.i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel make sysstat

install libXp This Library, This must be installed , Otherwise install Oracle When it comes to java Exception.

[root@khdata16 khtool]# yum install libXp

7. Configure system kernel parameters , Where are these configuration files , It's something you have to remember , This is a Linux The organizational structure of the file system , It needs to be understood , You can see 《Linux It's time to learn 》.

edit /etc/sysctl.conf

# vim /etc/sysctl.conf

Add the following

kernel.shmall= 2097152

kernel.shmmax= 2147483648

kernel.shmmni= 4096

kernel.sem= 250 32000 100 128

net.ipv4.ip_local_port_range= 1024 65000

net.core.rmem_default=4194304

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=262144

[root@oracle204 jxsoft]# /sbin/sysctl -p

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 262144

edit /etc/security/limits.conf

[root@khdata16 khtool]# vi /etc/security/limits.conf

# Add the following four lines at the end of the line

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

edit /etc/pam.d/login

[root@khdata16 khtool]# vi /etc/pam.d/login

# Add the following two lines at the end of the line

session required /lib64/security/pam_limits.so

session required pam_limits.so

modify /etc/profile

[root@khdata16 khtool]#vi /etc/profile

Add the following code to profile , pathmunge () below . When adding code , Pay attention to , In the grammar here ,if and [] Between , also = Both sides , They all need spaces , If there is no space , After that, an error will be reported when executing the code here .

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

establish oinstall And dba Groups and settings Oracle password

[root@oracle204 jxsoft]# groupadd oinstall

[root@oracle204 jxsoft]# groupadd dba

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

[root@oracle204 jxsoft]# passwd oracle

Change user oracle Password .

new password :

Reenter the new password :

passwd: All authentication tokens have been successfully updated .

[root@oracle204 jxsoft]#

modify Linux Release information

# vim /etc/redhat-release

#CentOS Linux release 7.4.1708 (Core)

redhat 4

Configure kernel parameters :

# vim /etc/sysctl.conf

-- Add the following :

--- here 1002 yes oracle User group dba Of gid ( Use one's life : id oracle  check gid)

vm.hugetlb_shm_group=1002

#/sbin/sysctl -p

establish oracle Installation folder and data storage directory

[root@oracle204 jxsoft]# mkdir -p /u01/app/oracle/product/10.2.0/db_1

[root@oracle204 jxsoft]# chown -R oracle:oinstall /u01/app/oracle/product/10.2.0/db_1

[root@oracle204 jxsoft]# chmod -R 775 /u01/app/oracle/product/10.2.0/db_1

[root@oracle204 jxsoft]#

To configure oracle The user's environment variables

#cd /home/oracle

# vim .bash_profile  --- Add the following

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export ORACLE_SID=jdjcdb

export ORACLE_TERM=xterm

export PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

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

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

After saving, use the following command , Make settings effective :

# source /home/oracle/.bash_profile

To configure Linux host

Check /etc/hosts Is there... In the document localhost The record of ( Point to 127.0.0.1 that will do ), If not , Configure... At the back Oracle There will be some problems when monitoring , Causes the monitor to fail to start , You can manually add this record here .

[root@khdata16 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

----------------------------- The first stage configuration is complete -----------------------------------

Decompress and give Oracle jurisdiction

[root@oracle204 oracle]# cd /opt/jxsoft/

[root@oracle204 jxsoft]# ls

10201_database_linux_x86_64.cpio.gz  rcjgcp_tj.rar

apache-tomcat-7.0.90.tar.gz          readline-6.2.tar.gz

exp_tjypjg.dmp                       rlwrap-0.37.tar.gz

jdk-6u45-linux-x64.bin               tjqxjg.dmp

p8202632_10205_Linux-x86-64.zip      ypltjg.zip

pdksh-5.2.14-37.el5_8.1.x86_64.rpm

[root@oracle204 jxsoft]# gunzip 10201_database_linux_x86_64.cpio.gz

[root@oracle204 jxsoft]# cpio -idmv < 10201_database_linux_x86_64.cpio

[root@oracle204 jxsoft]# chown -R oracle:oinstall /opt/jxsoft/database/

Log out and log back in . Write off root user , Use Oracle The user login ( important !!! You have to restart to enter )

[oracle@oracle204 ~]$ cd /opt/jxsoft/database/

[oracle@oracle204 database]$ ls

doc  install  response  runInstaller  stage  welcome.html

Solve the problem of Chinese garbled code during installation :

[root@khdata16 database]# export LANG=en_US

Solve the problem of graphical installation :

# Switch to root user , perform xhost +

[root@khdata16 ~]# xhost +

access control disabled, clients can connect from any host

Cut back oracle User execution ,192.168.188.1: For the client ip

[oracle@khdata16 database]$ export DISPLAY=192.168.188.1:0.0

Execution and installation

QUI -10035

chown -R oracle:oinstall /u01/app

$ chmod -R 755 /u01/app

QUI-25031

modify /etc/hosts file , increase IP The mapping between address and host name is as follows :

Ip  hostname

ora 27125

#id oracle

You can see oracle Group dba id by 501

Modify kernel parameters

# echo "501" >/proc/sys/vm/hugetlb_shm_group

There are two options above that don't show tick , It means that the inspection failed .

### the reason being that warning So it can't be solved . The first solution ( New switch partition ):

[root@oracle204 oracle]# cd /

[root@oracle204 /]# mkdir swapimage

[root@oracle204 /]# cd swapimage/

[root@oracle204 swapimage]# dd if=/dev/zero of=/swapimage/swap bs=1024 count=2500000

Recorded 2500000+0 Read in of

Recorded 2500000+0 Write

2560000000 byte (2.6 GB) Copied ,47.8377 second ,53.5 MB/ second

[root@oracle204 swapimage]# mkswap /swapimage/swap

Setting swap space version 1, size = 2499996 KiB

No label ,UUID=9c2d05f0-f965-4e26-abe6-4e5fad52228c

[root@oracle204 swapimage]# vim /etc/fstab

/swapimage/swap        swap                    swap    defaults        0 0

[root@oracle204 swapimage]# swapon  /swapimage/swap

swapon: /swapimage/swap: Unsafe permissions 0644, It is recommended to use 0600.

[root@oracle204 swapimage]#

The second solution :

1 see /etc/hosts, Check if it's in this form :

vi /etc/hosts

127.0.0.1    localhost

172.22.22.242    jcyoracle

Be careful : The first line should be written in this form , instead of 127.0.0.1 Your host name localhost.

The second line represents the machine IP And the host name

2 see /etc/sysconfig/network, Check hostname

vi /etc/sysconfig/network

NETWORKING=yes

HOSTNAME=jcyoracle

DNS1=8.8.8.8

3 Check if the host name is the current host name

[root@localhost swapimage]# hostname

jcyoracle

# If it is not , Make the running host name temporarily effective as

[root@localhost swapimage]# hostname jiacuiyun

[root@localhost swapimage]# hostname

4. Restart network service .

[root@localhost swapimage]#systemctl restart network

Come here , The database is installed . It's not hard , As long as you've learned 《Linux It's time to learn 》, Can be installed , Because the basic commands are used , So , The foundation is still very important .

Explain Linux More articles on database installation

  1. Explain in detail Linux Lower installation python3(Python3.5.4)

    https://jingyan.baidu.com/article/6b97984dd6dbb01ca2b0bf0a.html

  2. Linux Next DB2 Database installation tutorial

    Recently, I have been studying because of my work DB2 database , This tutorial explains DB2 The database is inux Next installation steps . Please check before installing  DB2 Version and license   Explain to increase understanding , Find out what version to install first , Here I use the latest Express-C edition , ...

  3. Linux Under the installation configuration and use MySQL database

    Linux Under the installation configuration and use MySQL database stay Linux When doing development under the installation, it is often necessary to use MySQL database , Next is Linux System as an example to explain , How to install MySQL database , How to enable / stop . stop MySQL service , Such as ...

  4. Linux Lower installation configuration MongoDB 3.0.x Version database

    explain : operating system :CentOS 5.X 64 position IP Address :192.168.21.128 Achieve the goal : Installation configuration MongoDB database Specific operation : One . close SElinux. Configure firewall 1.vi /etc/s ...

  5. 【MySql】 stay Linux Lower installation MySql database

    [ Parameter environment ] 1.Host OS:Win7 64bit 2.VM: VMware 11.1.0 3.Client OS:CentOS 6 4. Installed in the system openssl edition : openssl-1.0 ...

  6. mysql for linux Database installation process

    mysql for linux Database installation process l  Installed version :mysql-advanced-5.6.12-linux-glibc2.5-x86_64.tar.gz , This is the green version , Just solve it ...

  7. Linux Lower installation oracle database

    The source of the original text is       http://www.linuxidc.com/Linux/2015-02/113222.html Need to install Oracle DataGuard, So we need to install a single one first Oracle11g, ...

  8. ( 3、 ... and )—Linux File transfer and mysql Database installation

    The file transfer tool uses     In order to speed up , About linux Systematic learning should be given priority , Check which knowledge point is used , I want to be here linux I'm going to do some service at the bottom , The first thing I thought of was to pretend to be mysql Try the database . Because I use the virtual machine li ...

  9. Chapter four :Oracle12c The database is linux Environmental installation

    One : build yum Warehouse For beginners, please refer to this article :<Vmware Workstation _linux yum Warehouse building >.<CentOS7.2 To create local YUM Source and lan YUM Source > ...

Random recommendation

  1. npm Use the summary

    The content of this paper is based on npm 4.0.5 summary npm (node package manager), namely node Package manager . there node A bag is all kinds of javascript library . npm It's with Nod ...

  2. WPF Not UI Thread access to modify the control property value method

    public class InvokeHelper { #region delegates private delegate object MethodInvoker(Control control, ...

  3. web The road of front-end engineer learning opens ( Preface )

    web All the skills that front end engineers need to master The illustration 1: The illustration 2:

  4. ContentProvider Class parsing

    One .ContentProvider class 1. effect : It is specially used for data sharing between different applications . Two . Implementation method 1. establish ContenteProvider class Step one : Inherit ContentProvider Interface , rewrite ...

  5. HDU 3452 Bonsai

    It can be transformed into the solution of minimum cut , The problem is to divide the points into two sets , Add a super sink , Some of the points are in the collection of the root node , Some nodes are in the collection where the super sink is located , The two are separated , And the minimum cost , So that's the minimal cut . #inclu ...

  6. boot And mybatis

    Particular attention , This method and starter Are not compatible , I did it in two ways, asshole , I found that I couldn't run ! spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driv ...

  7. python Function returns the assignment method of multiple parameters

    # Defined function def Get_Counter_AllMeasureValue(self, inst_dg_address): """ get all measure val ...

  8. oracle dmp Data import

    11.245.2.55  root:root su  - pams -- Be careful pams The space in front of it /cnaps2/pams/backup   exp_pams_20141219.dmp drop tab ...

  9. bootstrap3 stay IE8 Down navigation doesn't show , Automatic recognition into mobile phone mode

    Want to make bootstrap3 compatible ie8, Need to put html5shiv.js.respond.js also bootstrap All of the css.js All the files are in the local server space , Out-of-service CDN. bootstrap all css. ...

  10. > Raiders Project configuration

    VS2010 Build a new project , hold Source directory \Source\T3DIICHAP01 Medium *.h and *.cpp The files are copied to the new project and added double-click   Source directory \DirectX \  dx9sdkcp.exe It will automatically solve ...