Linux-install Oracle (CentOS-Oracle 12c) and centos7 install oracle12c

Linux-install Oracle (CentOS-Oracle 12c) and centos7 install oracle12c

Step 1: network connection, which is described in my previous blog.

Purpose of network connection: to use the yum command, download the file directly online.

Step 2: Go to the oracle official website to download 12c

Two files on the database server: (installed in Linux)

Linuxamd64_12102_database_1of2.zip

Linuxamd64_12102_databasesilicate f2.zip

Place the two files in the tmp directory of Linux and decompress them using the unzip command.

A file of the database client: (installed on Windows)

32-bit oracle 11g client for windows

Win32_11gR2_client.zip

1.

Add users, groups, and related directories
Groupadd oinstall
Groupadd dba
Useradd-g oinstall-G dba oracle

Change the owner of oracle12c Media

Chown-R oracle: oinstall/tmp

2.

--- Create and install the oracle Installation Directory

Mkdir-p/u01/app/oracle/product/12.1.0/db_1
Mkdir-p/u01/app/oraInventory
Chown-R oracle: oinstall/u01
Chmod-R 777/u01

3.
Install and verify the system dependency package

Yum-y install binutils
Yum-y install compat-libcapl
Yum-y install gcc-
Yum-y install gcc-c ++-
Yum-y install glib2-devel
Yum-y install glibc
Yum-y install ksh
Yum-y install libaio
Yum-y install libaio-devel
Yum-y install libgcc-
Yum-y install libstdc ++-
Yum-y install libstdc ++-devel
Yum-y install libX11
Yum-y install libXau
Yum-y install libxcb
Yum-y install libXext
Yum-y install libXtst
Yum-y install make
Yum-y install sysstat
Yum-y install compat-libstdc ++
Yum-y install libstdc ++
Yum-y install compat-c ++
Yum-y install compat-libcap
Yum-y install gcc-c ++
Yum-y install unixODBC
Yum-y install unixODBC-devel
Yum-y install xterm
Yum-y install elfutils-libelf
Yum-y install libaio-devel
Yum-y install libgcc
Yum-y install pdksh
Yum-y install compat-libstdc ++

Of course, when all the commands are copied and executed, some undownloaded commands are often exposed. Go to the [RPM Search] website for download. (Whether these tasks are completed will be verified during Oracle Installation)

4.

Modify the linux core configuration file

Vi/etc/sysctl. conf

Add content (the four Kernel parameters are related to your memory settings, and problems may occur here)

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

Execute the command to make the above take effect:

Su root

Sysctl-p

5.

-- Modify System Restrictions
Vi/etc/security/limits. conf

Add content:
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536

6.

Vi/etc/pam. d/login

Add content:
Session required/lib/security/pam_limits.so
Session required pam_limits.so

7.

Modify system environment variables

Vi/etc/profile

Add content:
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi

8.

Add environment variables for newly added Oracle users

Su oracle

Vi ~ /. Bash_profile

Add content:

ORACLE_BASE =/u01/app/oracle
ORACLE_HOME = $ ORACLE_BASE/product/12.1.0/Db_1(There is a pitfall here)
ORACLE_SID = test
PATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin
LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib
Export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH

-- Execute the following command as an oracle user to take effect

Source ~ /. Bash_profile

9.

Install the tool on a graphical interface.

Su root

Chown-R oracle: oinstall/tmp/database

Export DISPLAY =: 0.0

Xhost +

Su oracle

Cd/tmp/database

Sh runInstaller. sh (run the command to open the graphical installation Interface)

10.

The graphic installation interface is not mentioned much. The installation steps are as follows, and an error will be solved. There are many pitfalls.

In this step, I only installed Oracle and did not create a database.

11.

Create a database
Dbca

(There is a pitfall here, and there may be a prompt that the command does not exist because the installed directory is in dbhome_1 during Oracle Installation and is not in db_1, so change the red value of Step 8 to dbhome_1)

The command also opens a graphical interface like above to create a database.

12.
Create listener
The netca command opens a graphical interface like above to create a listener.

13.

Start the Oracle service.

Sqlplus/as sysdba

SQL-> startup (start the service)

14.

Install the client in Windows: 32-bit oracle 11g client for windows.

Net manager tool to add a new service name]

15.

At this time, we can test to see if we can connect to Linux in Windows.

Open CMD and enter tnsping [name of the service you just set]

If it fails, it may be a problem with the Linux firewall. Disable the Linux firewall.

Systemctl stop firewalld. service # stop Firewall

Systemctl disable firewalld. service # disable firewall startup

Systemctl start firewalld. service # start Firewall

Systemctl status firewalld. service # view the Firewall status

Shut down the firewall and try again.

16.

Install toad for oracle to operate Oracle.

Log on.

If everything succeeds, I wish you luck.