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

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

First of all, although Oracle18c supports RPM installation, there are still some restrictions in many aspects. The current restrictions mainly include:

1. Only single instance database or client installation is supported, but cluster is not supported.

2. Currently, RPM deployment of Standard Edition 2 version is not supported. RPM deployment of Standard Edition 2 is planned to be released in 19c version.

3. Using rpm-Uvh to upgrade database is not supported.

The installation package for RPM can be downloaded from OTN. You need to download 2 packages:

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

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

After downloading, this experience is installed offline. The test environment is configured as follows:

System version: CentOS release 6.6 (Final)

Memory: 4G

Directory space: 36G

Of course, if your environment is Oracle Linux and you have registered a ULN account, you only need to execute it under the root user.

Yum-y install oracle-database-ee-18c is fine, which only installs the software and does not configure and create the database.

Also under the root user, after configuring the yum source, enter the package storage directory and execute yum-y localinstall. / oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

Install the oracle-database-preinstall-18c-1.0-1.el7.x8664.rpm package:

[root@localhost yum.repos.d] # cd / soft/ [root@localhost soft] # lsAutoInstallOracle.sh oracle-database-ee-18c-1.0-1.x86_64.rpm pdksh- 5.2.14-37.el5_8.1.x86_64.rpmCentOS-6.6-x86_64-bin-DVD1.iso oracle-database-preinstall-18c-1.0-1.el7.x8664.rpm [root @ localhost soft] # yum- Y localinstall. / oracle-database-preinstall-18c-1.0- 1.el7.x86_64.rpm loaded plug-in: fastestmirror Refresh-packagekit Security setup local installation process diagnostics. / oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-18c-1.0-1.el7.x86_64./oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm will be installed by Loading mirror speeds from cached hostfile to resolve dependencies-> perform transaction checks-- > Package oracle-database-preinstall-18c.x86_64 0 : 1. 0-1.el7 will be installation-- > handling dependency compat-libcap1 It is required by package oracle-database-preinstall-18c-1.0- 1.el7.x86_64-- > handle dependency compat-libstdc++-33, it is needed by package oracle-database-preinstall-18c-1.0- 1.el7.x86_64-- > handle dependency ksh It is required by the software package oracle-database-preinstall-18c-1.0-1.el7.x86_64-- > perform transaction check-- > Package compat-libcap1.x86_64 0Package compat-libcap1.x86_64 1.10-1 will be installation-- > Package compat-libstdc++-33.x86_64 0Package compat-libcap1.x86_64 3.2.3-69.el6 will be installation-- > Package ksh.x86_64 0will be 20120801-21.el6 will be installation-- > complete dependency calculation Dependency resolution = package architecture version repository size = installing: oracle-database-preinstall-18c x86room64 1.0-1.el7 / oracle-database-preinstall-18c-1.0-1.el7.x86_64 55k is installed for dependencies: compat-libcap1 x86, base 64 1.10-1 C6.0-base 17 k compat-libstdc++-33 X86'64 3.2.3-69.el6 C6.0-base 183k ksh x86'64 20120801-21.el6 C6.0-base 758k transaction summary = Install 4 Package (s) Total file size: 1.0m Total downloads: 959m kInstalled size: 2.5m download package: -Total 1.4 MB/s | 959 kB 00:00 run rpm_check_debug to perform transaction test transaction test successfully executed transaction Warning: RPMDB altered outside of yum.** Found 2 pre-existing rpmdb problem (s) 'yum check' output follows:mysql-community-server-5.7.19-1.el6.x86_64 has missing requires of mysql-community-client (x86-64) > = (' 0mm, '5.7.9mm, None) mysql-community-server-5.7.19-1.el6.x86_64 has missing requires of mysql-community-common (x86-64) = (' 0mm, '5.7.19' '1.el6') is being installed: ksh-20120801-21.el6.x86_64 1 Universe 4 is being installed: compat-libstdc++-33-3.2.3-69.el6.x86_64 2ax 4 is being installed: compat-libcap1-1.10-1.x86_64 3 amp 4 positive After installation: oracle-database-preinstall-18c-1.0-1.el7.x86_64 4amp 4 Verifying: compat-libcap1-1.10-1.x86_64 1 Verifying 4 Verifying: compat-libstdc++-33-3.2.3-69.el6.x86_64 2 Verifying: oracle-database-preinstall-18c-1.0-1.el7.x86 _ 64 3ax 4 Verifying: ksh-20120801-21.el6.x86_64 4 / 4 installed: oracle-database-preinstall-18c.x86_64 0 compat-libstdc++-33.x86_64 1.0-1.el7 installed as a dependency: compat-libcap1.x86_64 0vl 1.10-1 compat-libstdc++-33.x86_64 0 : 3.2.3-69.el6 ksh.x86_64 0 20120801-21.el6 over! [root@localhost soft] #

Continue to install the oracle-database-ee-18c-1.0-1.x8664.rpm package:

[root@localhost soft] # yum-y localinstall. / oracle-database-ee-18c-1.0-1.x86_64.rpm loaded plug-ins: fastestmirror, refresh-packagekit Security setup local installation process diagnostics. / oracle-database-ee-18c-1.0-1.x86_64.rpm: oracle-database-ee-18c-1.0-1.x86_64./oracle-database-ee-18c-1.0-1.x86_64.rpm will be installed by Loading mirror speeds from cached hostfile to resolve dependencies-- > perform transaction checks-- > Package oracle-database-ee-18c.x86_64 0Rol 1.0-1 Will be installation-- > complete dependency calculation dependency resolution = package architecture version repository size = installing: oracle-database-ee-18c X86 GInstalled size 64 1.0-1 / oracle-database-ee-18c-1.0-1.x86_64 7.8G transaction summary = Install 1 Package (s) Total file size: 7.8Gdownload package: run rpm_check_debug to run transaction test transaction test succeeded Executing transaction is being installed: oracle-database-ee-18c-1.0-1.x86_64 1 Acer 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 Verifying: oracle-database-ee-18c-1.0-1.x86_64 1Acer 1 has been installed: oracle-database-ee-18c.x86_64 0pur1.0-1 Over! [root@localhost soft] #

The software installation is completed, but the database is not created, still under the root user, use / etc/init.d/oracledb_ORCLCDB-18c configure for the default database configuration. Note that instead of using the rpm package to configure the database here, Oracle calls dbca to install the database silently, that is, you can create the database by default without this command, and you can use dbca for database creation configuration as before.

The database creation process is as follows:

[root@localhost /] # / etc/init.d/oracledb_ORCLCDB-18c configureConfiguring Oracle Database ORCLCDB. [WARNING] [DBT-11209] the current available memory is less than the available memory (1532MB) needed to create the database. Reason: the following nodes do not have the necessary available memory: node: localhost available memory: 636.5078MB (651784.0KB) ready to perform database operation 8% replication database file 31% created and started Oracle instance 32% completed 36% completed 40% database creation in progress 46% database creation 51% completed 54% The creation of the plug-in database is 58% complete and 77% complete. After the configuration operation is completed, the database creation is 100% complete. For more information, check the log file at / opt/oracle/cfgtoollogs/dbca/ORCLCDB. Database information: global database name: ORCLCDB system identifier (SID): ORCLCDB see the log file "/ opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for more information. 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. [root@localhost /] #

At this point, the entire database software and database installation are complete, and then we need to manually configure the environment variables to log in to the Oracle18c database deployed by our rpm package, as shown below, the ORCLPDB1 PDB database has been created by default.

[oracle@localhost] $sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0-Production on Thu Dec 6 16:22:43 2018Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Oracle Database 18c Enterprise Edition Release 18.0.0.0.0-ProductionVersion 18.3.0.0.0 SQL > show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 ORCLPDB1 READ WRITE NO

The following is the statement that invokes the dbca silent installation when configuring the database for this test.

/ bin/su-s / bin/bash oracle-c / opt/oracle/product/18c/dbhome_1/bin/dbca-silent-createDatabase-gdbName ORCLCDB-templateName General_Purpose.dbc-characterSet AL32UTF8-createAsContainerDatabase true-numberOfPDBs 1-pdbName ORCLPDB1-createListener LISTENER:1521-datafileDestination / opt/oracle/oradata-sid ORCLCDB-autoGeneratePasswords-emConfiguration DBEXPRESS-emExpressPort 5500, the study on "the process of Oracle18cRPM installation and deployment of database" is over. I hope you can 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.