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

I have been very busy at the end of the year. I was busy today to install Oracle18C's RPM package installation method. The overall feeling is relatively convenient, greatly simplifying the installation of oracle, so that non-professional DBA also has a better installation experience. Here are some of the steps in my installation process to share:

Environment introduction:

OS: Redhat 7.5, Mem 4G, CPU 4C,DISK 200G

Red Hat Enterprise Linux Server release 7.5 (Maipo)

Download the rpm installation package:

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

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

Installation steps

3.1Configuring yum

# cd / etc/yum.repos.d

[rhel7.5]

Name=my_repo

Baseurl= file:///mnt

Gpgcheck=0

Install dependency package: yum-y install xorg-x11-xauth xorg-x11-utils libstdc++-devel libaio-devel ksh compat-libcap Note: there is no compat-libstdc++-33 package in redhat7.5, please download it yourself and install it manually. 3.3 install the database

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

There is a lot of information about the installation prompt, which is omitted here.

2) rpm-ivh oracle-database-ee-18c-1.0-1.x86_64.rpm

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

Preparing... # # [100%]

Updating / installing...

1:oracle-database-ee-18c-1.0-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-18c configure

3.4 configure the database

Execute under root:

Check after etc/init.d/oracledb_ORCLCDB-18c configure3.5 installation is complete

This step takes a long time and needs to wait patiently.

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.

1) Oracle configuration environment variable: [oracle@rhel75-dev-31-81 ~] $vi .bash _ profile

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

Export ORACLE_VERSION=18c

Export ORACLE_SID=ORCLCDB

PATH=$ORACLE_HOME/bin:$PATH:$HOME/.local/bin:$HOME/bin

Export PATH

2) check and monitor lsnrctl statusService "7f7a654558113bdde055025056a8c790" 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

3) Log in to the database

Sqlplus / as sysdba

[oracle@rhel75-dev-31-81] $sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0-Production on Tue Jan 15 14:50:55 2019

Version 18.3.0.0.0

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

Connected to:

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0-Production

Version 18.3.0.0.0

Thinking after installation

1) oracle 18C greatly simplifies the workload of installation. It is convenient for deployment and implementation.

2) the network configuration is completed automatically. The network part of the system will automatically configure the production listener.ora and tnsnames.ora files.

3) initialization is the container database.

Of course, there are many new features, follow-up articles will explain to you one by one, time is limited, there will inevitably be mistakes, if there are any problems, please correct them in time. Welcome to discuss.

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.