Install oracle database 19c on oracle linux 8

Oracle Database 19c RPM Installation On Oracle Linux 7 (OL7) and Oracle Linux 8 (OL8)

Oracle 19c can be installed on Oracle Linux using an RPM. This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit or Oracle Linux 8 (OL8) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive. An example of this type of Linux installation can be seen here (OL7 or OL8).

Hosts File

The «/etc/hosts» file must contain a fully qualified name for the server.

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 192.168.56.107 ol7-19.localdomain ol7-19

Set the correct hostname in the «/etc/hostname» file.

Oracle Installation

If you have a ULN subscription, the documentation suggests you can just install it using the following command as the «root» user. I don’t have a ULN subscription, so I can’t confirm this.

yum -y install oracle-database-ee-19c

If you don’t have a ULN subscription, you will have to download the «oracle-database-ee-19c-1.0-1.x86_64.rpm» separately from the Oracle 19c (19.3) download page here.

With the RPM file downloaded, you can install the Oracle prerequisites and software using the following command as the «root» user. It automatically pulls down all dependencies, including the «oracle-database-preinstall-19c» package. If you do this the «oracle» user doesn’t have a home directory created, so I install the preinstall package first, so the «oracle» user is as I expect it. The additional command is included below, but commented out.

#yum install -y oracle-database-preinstall-19c yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

On RHEL you will need to manually get the prerequisites RPM from the Yum repository and run it manually before installing the database RPM.

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 yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm rm oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

The ORACLE_HOME for the software installation is «/opt/oracle/product/19c/dbhome_1».

Create Database

In addition to the software installation, the RPM creates a script that allows you to create a demo database called «ORCLCDB», with a pluggable database (PDB) called «ORCLPDB1».

# /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. #

You can of course create a database in the normal way, using the Database Configuration Assistant (DBCA). You don’t have to use this script.

Thoughts

Here are some thoughts about this method of installation.

• The mechanism is designed for a software-only installation of the Oracle database software. It is not a single command to get Oracle running. As a result it doesn’t feel particularly simpler than doing a regular silent installation of the database software, but people with less experience may disagree.
• The RPM can only be used to install the software, not update it. This is a «one-shot» solution.
• You have no control of the software installation itself. If you have a corporate standard you use for your installations, this is not the solution for you. Remember, the ORACLE_HOME for the software installation is «/opt/oracle/product/19c/dbhome_1».
• Even with a ULN subscription, it is unlikely you would want to pull this software down for each installation. You would need to create a local Yum repository to host it.
• It’s an interesting exercise, but I would not consider using this approach for anything other than demos at this time.

Vagrant Example

If you want to see it in action, you might want to try this Vagrant build here.

Hope this helps. Regards Tim.

Created: 2019-04-26 Updated: 2021-08-16

Источник

Install oracle database 19c on oracle linux 8

Database Installation Guide

Oracle Database Database Installation Guide, 19c for Linux

Copyright © 2015, 2023, Oracle and/or its affiliates.

Primary Authors: Prakash Jashnani, Subhash Chandra

Contributing Author: Douglas Williams

Contributors: Ranjit Noronha, Jean-Francois Verrier, Richard Roddy, Rajesh Dasari, Smitha Viswanathan, Neha Avasthy, Sampath Ravindhran, Prasad Bagal, Subhranshu Banerjee, Gerald Venzl, Tammy Bednar, Avi Miller, Jean-Marc Thayer, Alok Sahu, Gavin Bowe, Gia-Khanh Nguyen, Darcy Christensen, Kiran Chamala, Jonathan Creighton, Benoit Dageville, Logeshwaran Rajan, Angad Gokakkar , Anu Natarajan, Girdhari Ghantiyala, Mani Mannampalli, Bernard Clouse, Chandrasekharan Iyer, Anil Nair, Sivaram Soma, Lisa Vaz, Vasu Venkatasubramanian, Sumanta Chatterjee, Margaret Susairaj, Malai Stalin, Markus Michalewicz, Subrahmanyam Kodavaluru, Sudip Datta, Madhu Hunasigi, Jim Erickson, Marcus Fallen, Joseph Francis, Allan Graves, Barbara Glover, Asad Hasan, Thirumaleshwara Hasandka, Putta Ramesh, Sergio Leunissen, Aneesh Khandelwal, Joel Kallman, Eugene Karichkin, Jai Krishnani, Prasad K Kulkarni, Ranjith Kundapur, Balaji Pagadala, Christopher Jones, Tak Wang, Bryn Llewellyn, Saar Maoz, Chao Liang, Gopal Mulagund, Pushkar Punit, Sivaselvam Narayanasamy, Ankur Kemkar, Sue Lee, Rich Long, Ricardo Alonso Gonzalez Acuna, Barb Lundhild, Sangeeth Jose, Rudregowda Mallegowda, Prasad Kuruvadi Nagaraj, Mughees Minhas, Krishna Mohan, Matthew McKerley, John McHugh, Gurudas Pai, Satish Panchumarthy , Rajesh Prasad, Rajendra Pingte, Ramesh Chakravarthula, Srinivas Poovala, David Price, Hanlin Qian, Michael Coulter, Hema Ramamurthy, Sunil Ravindrachar, Mark Richwine, Dipak Saggi, Alan Tam, Ian Cookson, David Schreiner, Ara Shakian, Naveen Ramamurthy, Mohit Singhal, Dharma Sirnapalli, Akshay Shah, James Spiller, Roy Swonger, Binoy Sukumaran, Jagvir Yadav, Ravi Thammaiah, Shekhar Vaggu, Pablo Sainz Albanez, Hector Vieyra, Peter Wahl, John Haxby, Sergiusz Wolicki, Sivakumar Yarlagadda, Nagendra Kumar Ym

Источник

Minimal Viable Oracle Database 19c Installation on Oracle Linux 8 (OL8)

This article gives the least steps necessary to get a working Oracle 19c database on Oracle Linux 8 (OL8).

As the name suggests, this is probably the simplest way to install an Oracle 19c database and set up a test user. This is not something I would follow if I were doing a real server build. It’s meant for someone who doesn’t care about the build process, but just wants a working database to run some DDL and DML against.

Download Software

Download the Oracle software RPM (oracle-database-ee-19c-1.0-1.x86_64.rpm) from here and place it in the «/tmp» directory on your server.

Database Installation and Creation

The following commands install the prerequisites, install the database software and create a new database.

cd /tmp # Prerequisites. sudo dnf install -y oracle-database-preinstall-19c # Oracle software installation. sudo dnf localinstall -y /tmp/oracle-database-ee-19c-1.0-1.x86_64.rpm # Create a database. sudo /etc/init.d/oracledb_ORCLCDB-19c configure

Test User Setup

Use the following commands to create a test user.

# Switch to the "oracle" user. sudo su - oracle # Set up your environment. export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH export ORACLE_SID=ORCLCDB sqlplus / as sysdba 
Connecting To The Database
To connect to the database using SQL*Plus we could do the following.
sqlplus testuser1/testuser1@//localhost:1521/ORCLPDB1
 
Using SQLcl it would look like this.
 
sql testuser1/testuser1@//localhost:1521/ORCLPDB1
 
If you are connecting from another tool, or remote machine, you just need to remember the basic connection details.
 
Username: testuser1 Password: testuser1 Host : Port : 1521 Service : ORCLPDB1
 
Hope this helps. Regards Tim.
 
Created: 2021-08-26 Updated: 2021-08-26
 
Источник