A tutorial of installing Oracle 19C in RPM mode on ol7.6

Time:2019-11-12

Set host name


[[email protected] ~]# cat /etc/hosts
127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4
::1     localhost localhost.localdomain localhost6 localhost6.localdomain6
10.0.0.11 study1.localdomain study1
[[email protected] ~]# cat /etc/hostname
study1.localdomain

Installation environment preparation tool

In fact, it can be installed directly by rpm. It will automatically solve the dependency problems, including environment preparation tools. However, Oracle users do not have a home directory, so they need to install environment preparation tools first


[[email protected] /]# yum -y install oracle-database-preinstall-19c
Loaded plugins: langpacks, ulninfo
ol7_UEKR5                                                                                            | 2.5 kB 00:00:00  
ol7_latest                                                                                            | 2.7 kB 00:00:00  
(1/4): ol7_UEKR5/x86_64/updateinfo                                                                                | 49 kB 00:00:01  
(2/4): ol7_latest/x86_64/updateinfo                                                                               | 1.1 MB 00:00:05  
(3/4): ol7_UEKR5/x86_64/primary_db                                                                                | 5.7 MB 00:00:27  
(4/4): ol7_latest/x86_64/primary_db                                                                               | 19 MB 00:01:21  
Resolving Dependencies
(many more lines supressed)
Installed:
 oracle-database-preinstall-19c.x86_64 0:1.0-1.el7                                                                                  
Dependency Installed:
 compat-libcap1.x86_64 0:1.10-7.el7  compat-libstdc++-33.x86_64 0:3.2.3-72.el7  glibc-devel.x86_64 0:2.17-292.0.1.el7    glibc-headers.x86_64 0:2.17-292.0.1.el7  kernel-headers.x86_64 0:3.10.0-1062.el7 
 ksh.x86_64 0:20120801-139.0.1.el7   libaio-devel.x86_64 0:0.3.109-13.el7     libstdc++-devel.x86_64 0:4.8.5-39.0.1.el7 
Dependency Updated:
 glibc.x86_64 0:2.17-292.0.1.el7                   glibc-common.x86_64 0:2.17-292.0.1.el7                   libstdc++.x86_64 0:4.8.5-39.0.1.el7                  
Complete!
[[email protected] /]#

If it’s RHEL or CentOS, you need to manually download preinstall’s RMP package, and then install it locally (or add the yum source of Oracle Linux to install it)


[[email protected] /]# curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
 % Total  % Received % Xferd Average Speed  Time  Time   Time Current
                 Dload Upload  Total  Spent  Left Speed
100 18204 100 18204  0   0 18037   0 0:00:01 0:00:01 --:--:-- 18059
[[email protected] /]# yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

Install Oracle Software

[[email protected] db]# yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm
Loaded plugins: langpacks, ulninfo
Examining oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64
Marking oracle-database-ee-19c-1.0-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
========================================================================================================================================================================================================================
 Package                         Arch                   Version                 Repository                               Size
========================================================================================================================================================================================================================
Installing:
 oracle-database-ee-19c                  x86_64                  1.0-1                  /oracle-database-ee-19c-1.0-1.x86_64                  6.9 G
Transaction Summary
========================================================================================================================================================================================================================
Install 1 Package
Total size: 6.9 G
Installed size: 6.9 G
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing : oracle-database-ee-19c-1.0-1.x86_64                                                                                 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
 Verifying : oracle-database-ee-19c-1.0-1.x86_64                                                        1/1
Installed:
 oracle-database-ee-19c.x86_64 0:1.0-1                                                            
Complete!
[[email protected] db]#
The Oracle home directory is / opt / Oracle / product / 19C / dbhome

Create database


[[email protected] dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.
 
Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
[[email protected] dbhome_1]#

By default, a database named orccdb and PDCB named orclpdb1 is created. Of course, it can be created in a traditional DBCA way instead of this way

Advantages and disadvantages

In fact, this method is useless. It’s not easier than silent installation. You can only install database software, not upgrade the database, and it can’t be used for RAC. It can only be used to install single instance database. The whole deployment doesn’t give you customized space, such as Oracle home directory. If it’s not consistent with your company’s disk planning, the novice may think that It’s more simple. This way is just a try. It’s almost useless in actual production

summary

The above is a tutorial for Xiaobian to introduce the RPM installation of Oracle 19C on ol7.6. I hope it can help you. If you have any questions, please leave a message and Xiaobian will reply to you in time. Thank you very much for your support of the developepaer website!
If you think this article is helpful to you, welcome to reprint, please indicate the source, thank you!

Recommended Today

Detailed explanation of sshd service and service management command under Linux

sshd SSH is the abbreviation of secure shell, which is the security protocol of application layer. SSH is a reliable protocol which provides security for remote login session and other network services. SSH protocol can effectively prevent information leakage in the process of remote management. openssh-server Function: enable remote hosts to access the sshd service […]