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

This article introduces the relevant knowledge of "how to install RPM stand-alone database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

I. introduction of the environment

Operating system

Red Hat Enterprise Linux Server release 7.7 (Maipo)

Database version

Oracle database 19.3

Hostnam

Adg19c

IP address

192.168.84.99

Installation directory

/ DBSoft/oracle/product/19.3/dbhome_1

Database name

Woo

Character set

AL32UTF8

Second, environmental preparation 2.1. Close the firewall [root@adg19c ~] # systemctl stop firewalld [root@adg19c ~] # systemctl disable firewalldRemoved symlink / etc/systemd/system/multi-user.target.wants/firewalld.service.Removed symlink / etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.2.2. Disable the NetworkManager service [root@adg19c ~] # systemctl stop NetworkManager [root@adg19c ~] # systemctl disable NetworkManager2.3. Disable Selinox [root @ adg19c ~] # setenforce 0setenforce: SELinux is disabled [root@adg19c ~] # sed-I "/ ^ SELINUX=/s#enforcing#disabled#" / etc/selinux/config2.4. Configure HOSTS to resolve [root@adg19c ~] # cat > > / etc/hosts 192.168.84.99 adg19c > EOF2.5. Modify the hostname [root@adg19c ~] # sed-I's # ^ HOSTNAME=.*$#HOSTNAME=db01#' / etc/sysconfig/network [root@adg19c ~] # sed-I's # ^ NETWORKING_IPV6=.*$#NETWORKING_IPV6=no#' / etc/sysconfig/network2.6. Configure NOZEROCONFIG [root@adg19c ~] # cat > > / etc/sysconfig/network EOF2.7. Configure yum environment [root@adg19c ~] # cat > / etc/yum.repos.d/local.repo name=base > baseurl= file:///mnt> enabled=1 > gpgcheck=0 > multilib_policy=all > EOF [root@adg19c ~] # yum clean all & & yum makecacheLoaded plugins: product-id, search-disabled-repos, subscription-managerThis system is not registered with an entitlement server. You can use subscription-manager to register.Cleaning repos: base2.8. Upload and install compat-libstdc++ [root@adg19c ~] # rpm-ivh / home/oracle/compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm warning: / home/oracle/compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEYPreparing... # # [100%] Updating / installing... 1:compat-libstdc++-33-3.2.3-69.el6 # #

Note: this package is not available in the RHEL 7 environment and needs to be downloaded separately and installed manually.

Third, install database 3.1. Pre-install [root@localhost] # ls-rtltotal 2631532 Murray. 1 root root 18204 Apr 10 01:41 oracle-database-preinstall-19c-1.0-1.el7.x86 colors 64.rpmWhile RWWhi Rafael. 1 root root 2694664264 Apr 10 01:42 oracle-database-ee-19c-1.0-1.x86_64.rpm [root@localhost ~] # yum localinstall-y oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm Loaded plugins: ulninfoExamining oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-19c-1.0-1.el7.x86_64Marking oracle-database-preinstall-19c-1.0-1.el7 .x86 _ 64.rpm to be installedResolving Dependencies-- > Running transaction check--- > Package oracle-database-preinstall-19c.x86_64 0lv 1.0-1.el7 will be installed-- > Finished Dependency Resolution Dependencies Resolved = Package Arch Version Repository Size=Installing: oracle-database-preinstall-19c x86 * 64 1.0-1. El7 / oracle-database-preinstall-19c-1.0-1.el7.x86_64 55k Transaction Summary=Install 1 Package Total size: 55 kInstalled size: 55 kDownloading packages:Running transaction checkRunning transaction testTransaction test succeededRunning transactionWarning: RPMDB altered outside of yum. Installing: oracle-database-preinstall-19c-1.0-1.el7.x86_64 1 Verifying: oracle-database-preinstall-19c-1.0-1.el7.x86_64 1 Installed: oracle-database-preinstall-19c.x86_64 0: 1. 0-1.el7 complements 3.2. Install database software [root@localhost] # yum localinstall-y oracle-database-ee-19c-1.0-1.x86_64.rpmLoaded plugins: ulninfoExamining oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64Marking oracle-database-ee-19c-1.0-1.x86_64.rpm to be installedResolving Dependencies-- > Running transaction check--- > Package oracle-database-ee-19c.x86 _ 64 0 will be installed-- 1.0-1 will be installed-- > Finished Dependency Resolution Dependencies Resolved = Package Arch Version Repository Size=Installing: oracle-database-ee-19c x86 scene 64 1.0-1 / oracle-database-ee-19c-1.0-1.x86_64 6.9G Transaction Summary=Install 1 Package Total size: 6.9G GInstalled size: 6.9GDownloading packages:Running transaction checkRunning transaction testTransaction test succeededRunning transaction Installing: oracle-database-ee-19c-1.0-1.x86_64 1 Oracle home installed successfully and ready to be configured 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 Installed: oracle-database-ee-19c.x86_64 0rig 1.0-1 Complete!3.3. Create the database [root@localhost sysconfig] # / etc/init.d/oracledb_ORCLCDB-19c configureConfiguring Oracle Database ORCLCDB.Prepare for db operation8% completeCopying database files31% completeCreating and starting Oracle instance32% complete36% complete40% complete43% complete46% completeCompleting Database Creation51% complete54% completeCreating Pluggable Databases58% complete77% completeExecuting Post Configuration Actions100% completeDatabase creation complete. For details check the logfiles at: / opt/oracle/cfgtoollogs/dbca/ORCLCDB.Database Information:Global Database Name:ORCLCDBSystem Identifier (SID): ORCLCDBLook at the logfile "/ 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. Fourth, one-click automatic installation 4.1. Download and upload the installation media

Link: https://pan.baidu.com/s/1tC7eLLp3JdRksLRWOfgPRg

Extraction code: 0ajw

After copying this content, open the Baidu network disk mobile phone App, which is more convenient to operate.

4.2. Mount the operating system CD [root@localhost ~] # mount / dev/sr0 / mnt/mount: / dev/sr0 is write-protected, mounting read-only

4.3. Execute one click to install [root@localhost] # sh rhel7_oracle_1903_rpm_Install.sh-Welcome to PrudentWoo Oracle 19.3 Database RPM Install Package PrudentWoo QQ:286507175 E-mail:happy-wuweilong@hotmail.com4.4. Enter the database name Please Insert into ORACLE NAME: woo-- enter woo4.5. Create the database-Create Oracle Database; Name is woo-Configuring Oracle Database woo.Prepare for db operation8% completeCopying database files31% completeCreating and starting Oracle instance32% complete36% complete40% complete43% complete46% completeCompleting Database Creation51% complete54% completeCreating Pluggable Databases58% complete77% completeExecuting Post Configuration Actions100% completeDatabase creation complete. For details check the logfiles at: / opt/oracle/cfgtoollogs/dbca/woo.Database Information:Global Database Name:wooSystem Identifier (SID): wooLook at the logfile "/ opt/oracle/cfgtoollogs/dbca/woo/woo.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.Changing password for user oracle.passwd: all authentication tokens updated successfully.4.6. Last configure database sqlplus / as sysdba NAME STATUS LOG_MODE CREATED--WOO OPEN ARCHIVELOG 2020-06-01 11:22:31 SQL > CON_ID CON_NAME OPEN MODE RESTRICTED--2 PDB$SEED READ ONLY NO 3 ORCLPDB1 READ WRITE NO "how to install RPM stand-alone database" ends here Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.