Shulou(Shulou.com)06/01 Report--

RPM package installation Oracle19c

A description

1.1 Oracle operating system requirements under Linux:

Oracle Linux 8.1 with the Unbreakable Enterprise Kernel 6: 5.4.17-2011.0.7.el8uek.x86_64 or later

Oracle Linux 8 with the Red Hat Compatible kernel: 4.18.0-80.el8.x86_64 or later

Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4: 4.1.12-124.19.2.el7uek.x86_64 or later

Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 5: 4.14.35-1818.1.6.el7uek.x86_64 or later

Oracle Linux 7.5 with the Red Hat Compatible kernel: 3.10.0-862.11.6.el7.x86_64 or later

Red Hat Enterprise Linux 8: 4.18.0-80.el8.x86_64 or later

Red Hat Enterprise Linux 7.5: 3.10.0-862.11.6.el7.x86_64 or later

SUSE Linux Enterprise Server 12 SP3: 4.4.162-94.72-default or later

SUSE Linux Enterprise Server 15: 4.12.14-23-default or later

The installation environment is: Red Hat Enterprise Linux 7.5

1.2 Media requirements

(1) oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm / / pre-check before installation

Download address:

Https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

(2) oracle-database-ee-19c-1.0-1.x86_64.rpm / / oracle19c database package

Https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

Basic configuration of operating system

2.1 check server hardware and memory configuration

Use the following command to determine that the physical RAM size on the server is at least 1G

Grep MemTotal / proc/meminfo

Determine the size of the configured swap space

Grep SwapTotal / proc/meminfo

Make sure the tmp directory space is 1G.

Df-h / tmp

(if / tmp space is insufficient, clean the / tmp directory to meet disk space requirements.

Or when setting up the Oracle user environment, set the TMP and TMPDIR environment variables to the directory you want to use instead of / tmp)

Confirm that the system version can support 19c database uname-m

2.2 turn off the firewall

Shut down running services

Systemctl stop firewalld

Turn off the operating system self-startup

Systemctl disable firewalld

Check the shutdown

Systemctl status firewalld

As follows, dead indicates that boot is not enabled; inactive indicates that the current status is closed

2.3 close selinux:

Edit / etc/selinux/config file

[root @ byh ~] # vi / etc/selinux/config

SELINUX=disabled

2.4 configure system parameters

Edit / etc/pam.d/login add the following: vi / etc/pam.d/login session required pam_limits.so edit vi / etc/profile add the following: # system environment variable if [/ $USER = "oracle"]; then if [/ $SHELL = "/ bin/ksh"] Then ulimit-p 16384 ulimit-n 65536else ulimit-u 16384-n 65536fi umask 022fi Editor / etc/security/limits.conf add the following: vi / etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536

2.5 configure Yum Feed

Method 1:

Local Yum source:

Mount the CD-ROM drive

Mount / dev/cdrom / mnt

Configure yum:

Vi / etc/yum.repos.d/dvd.repo is added as follows:

[dvd]

Name=dvd

Baseurl= file:///mnt

Gpgcheck=0

Method 2: / / in the case of allowing communication with the external network

Network Yum source:

Wget-O / etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

Sed-I's Universe release evergreen 7-pound g'/ etc/yum.repos.d/CentOS-Base.repo

Yum clean all

2.6 install the preinstalled package

Yum-y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

Installing oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm with yum automatically resolves all packages that 19c depends on, and automatically configures kernel parameters.

If the local mirror source package is incomplete, many dependent packages may not be installed.

At this point, we need to use the network source to download these packages.

2.7. install the 19c database software rpm package

Transfer the media to / tmp for installation

Cd / tmp

Yum-y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

After installation, oracle users and oinstall groups are automatically created, the software is installed under / opt/oracle/product/19c/dbhome_1, and the installation location of the software cannot be modified

2.8Configuring environment variables for Oracle users

Su-oracle

Vi / .bash_profile

Export ORACLE_BASE=/opt/oracle

Export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1

Export PATH=$ORACLE_HOME/bin:$PATH

Export ORACLE_SID=ORCLCDB

Source .bash _ profile / / reload environment variables

Create a database instance

Method 1:

After successfully installing the database software, a database instance configuration script is generated, and the location of the script is prompted, and the script is configured according to your actual needs, and then executed.

Method 2:

Create a database instance using regular DBCA

3.1 configuration script

Edit / etc/init.d/oracledb_ORCLCDB-19c to configure the installed database

[root @ byh ~] # su-root

[root @ byh ~] # cd / etc/init.d/

[root @ byh ~] # vi oracledb_ORCLCDB-19c

Modify according to actual needs:

3.2 execute script installation

Then run the following script to install

[root @ byh ~] # / etc/init.d/oracledb_ORCLCDB-19c configure

Ending

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.