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

This article mainly introduces "the process of installing Oracle 18c rpm". In daily operation, I believe many people have doubts about the process of installing Oracle 18c rpm. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "the process of installing Oracle 18c rpm". Next, please follow the editor to study!

Environment:

OEL 6.8

DB:18.3

Two RPM packages are included in the installation

Oracle-database-ee-18c-1.0-1.x86_64.rpm

Oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

The installation process is divided into online installation and offline installation, which is decided by oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm.

Online installation:

# curl-o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

# yum-y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

Install offline, download oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm and install it manually.

Download address: https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

This process takes offline installation and downloading the software package:

Oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm software package checks system software packages, adjusts system parameters, and adds database user groups and users

Customize the installation conditions of Oracle through shell script to achieve the best installation environment configuration.

Start the installation:

[root@oeldb soft] # rpm-ivh oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

Warning: oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY

Error: Failed dependencies:

Compat-libcap1 is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

Compat-libstdc++-33 is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

Ksh is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

Libaio-devel is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

Libstdc++-devel is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

Xorg-x11-utils is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

Xorg-x11-xauth is needed by oracle-database-preinstall-18c-1.0-1.el7.x86_64

Prompt for the required installation package:

[root@oeldb soft] # yum-y install xorg-x11-xauth xorg-x11-utils libstdc++-devel libaio-devel ksh compat-libstdc++-33 compat-libcap1

[root@oeldb soft] # rpm-ivh oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

Preparing... # [100%]

1:oracle-database-preinst### [100%]

Check the post-installation environment:

[root@oeldb ~] # cat / etc/passwd | grep oracle

Oracle:x:54321:54321::/home/oracle:/bin/bash

[root@oeldb ~] # more / etc/group | tail-10

Stapsys:x:157:

Stapdev:x:158:

Tcpdump:x:72:

Oinstall:x:54321:oracle

Dba:x:54322:oracle

Oper:x:54323:oracle

Backupdba:x:54324:oracle

Dgdba:x:54325:oracle

Kmdba:x:54326:oracle

Racdba:x:54330:oracle

Check the contents of the RPM package:

[root@oeldb soft] # rpm-qlp oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

/ etc/rc.d/init.d/oracle-database-preinstall-18c-firstboot

/ etc/security/limits.d/oracle-database-preinstall-18c.conf

/ etc/sysconfig/oracle-database-preinstall-18c

/ etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c-verify

/ etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c.param

/ usr/bin/oracle-database-preinstall-18c-verify

/ var/log/oracle-database-preinstall-18c

/ var/log/oracle-database-preinstall-18c/results

Extract the package:

[root@oeldb soft] # rpm2cpio oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm | cpio-idmv

. / etc/rc.d/init.d/oracle-database-preinstall-18c-firstboot

. / etc/sysconfig/oracle-database-preinstall-18c

. / etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c-verify

. / etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c.param

. / usr/bin/oracle-database-preinstall-18c-verify

. / var/log/oracle-database-preinstall-18c

. / var/log/oracle-database-preinstall-18c/results

Database-related users, groups, parameters:

. / etc/sysconfig/oracle-database-preinstall-18c/oracle-database-preinstall-18c.param

Install the database software:

First, check the contents of the RPM package, including database creation, monitoring, and database software, as follows:

Root@oeldb soft] # rpm-qlp oracle-database-ee-18c-1.0-1.x86_64.rpm

/ etc/init.d/oracledb_ORCLCDB-18c

/ etc/sysconfig/oracledb_ORCLCDB-18c.conf

/ opt/oracle/product/18c

/ opt/oracle/product/18c/dbhome_1

/ opt/oracle/product/18c/dbhome_1/.opatchauto_storage

/ opt/oracle/product/18c/dbhome_1/.opatchauto_storage/system_patches

/ opt/oracle/product/18c/dbhome_1/.opatchauto_storage/system_patches/28096386

/ opt/oracle/product/18c/dbhome_1/.opatchauto_storage/system_patches/28096386/bundle.xml

/ opt/oracle/product/18c/dbhome_1/.opatchauto_storage/system_patches/systemPatchInformationStore.xml

/ opt/oracle/product/18c/dbhome_1/.patch_storage

.

/ opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxtr.msb

/ opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxus.msb

/ opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxus.msg

/ opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxzhs.msb

/ opt/oracle/product/18c/dbhome_1/xdk/mesg/lsxzht.msb

[root@oeldb soft] #

[root@oeldb soft] # rpm-ivh oracle-database-ee-18c-1.0-1.x86_64.rpm

Preparing... # [100%]

1:oracle-database-ee-18c # # [100%]

[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-18c configure

Check the contents of the file:

The content of the configure method in / etc/init.d/oracledb_ORCLCDB-18c file is as follows

.

Configure ()

{

Check_for_configuration

RETVAL=$?

If [$RETVAL-eq 0]

Then

Echo "Oracle Database instance $ORACLE_SID is already configured."

Exit 1

Fi

Read_config_file

Check_port_availability

Check_em_express_port_availability

Configure_perform

}

.

This file includes a collection of scripts related to database startup, stop, restart, and so on.

[root@oeldb ~] # more / etc/init.d/oracledb_ORCLCDB-18c | grep'()'

Start ()

Stop ()

Configure_perform ()

Unset_proxy_vars ()

Check_for_configuration ()

Read_config_file ()

Configure ()

Check_port_availability ()

Check_em_express_port_availability ()

Restart ()

Create a database and create a sid:ORCLCDB,pdb_name:ORCLPDB1 by default, and you can adjust the contents of the file as required.

[root@oeldb ~] # / etc/init.d/oracledb_ORCLCDB-18c 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.

Oracle environment variable is not configured. Configure environment variable, check and listen

Export ORACLE_BASE=/opt/oracle

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

Export ORACLE_SID=ORCLCDB

Export PATH=$PATH:$ORACLE_HOME/bin

[oracle@oeldb] $. .bash _ profile

[oracle@oeldb ~] $lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0-Production on 31-OCT-2018 14:54:11

Copyright (c) 1991, 2018, Oracle. All rights reserved.

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=oeldb) (PORT=1521)

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for Linux: Version 18.0.0.0.0-Production

Start Date 31-OCT-2018 14:07:48

Uptime 0 days 0 hr. 46 min. 25 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File / opt/oracle/product/18c/dbhome_1/network/admin/listener.ora

Listener Log File / opt/oracle/diag/tnslsnr/oeldb/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=oeldb) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521)

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcps) (HOST=oeldb) (PORT=5500)) (Security= (my_wallet_directory=/opt/oracle/admin/ORCLCDB/xdb_wallet)) (Presentation=HTTP) (Session=RAW))

Services Summary...

Service "7981b2318b511a4ce053c80fa8c07ea4" has 1 instance (s).

Instance "ORCLCDB", status READY, has 1 handler (s) for this service...

Service "ORCLCDB" has 1 instance (s).

Instance "ORCLCDB", status READY, has 1 handler (s) for this service...

Service "ORCLCDBXDB" has 1 instance (s).

Instance "ORCLCDB", status READY, has 1 handler (s) for this service...

Service "orclpdb1" has 1 instance (s).

Instance "ORCLCDB", status READY, has 1 handler (s) for this service...

The command completed successfully

Test stop, start

[root@oeldb ~] # / etc/init.d/oracledb_ORCLCDB-18c stop

Shutting down Oracle Database instance ORCLCDB.

Oracle Database instance ORCLCDB shut down.

Stopping Oracle Net Listener.

Oracle Net Listener stopped.

[root@oeldb ~] # / etc/init.d/oracledb_ORCLCDB-18c start

Starting Oracle Net Listener.

Oracle Net Listener started.

Starting Oracle Database instance ORCLCDB.

Oracle Database instance ORCLCDB started.

Overall, rpm installation simplifies the installation process, improves a lot, and creates database information that suits you according to the content of the script.

At this point, the study on "the process of installing Oracle 18c rpm" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.