Install oracle database 19c on oracle linux 8

Database Installation Guide

Oracle Database Database Installation Guide, 19c for Linux

Primary Authors: Prakash Jashnani, Subhash Chandra

Contributing Author: Douglas Williams

Contributors: Jean-Francois Verrier, Richard Roddy, Neha Avasthy, Sampath Ravindhran, Prasad Bagal, Subhranshu Banerjee, Gerald Venzl, Tammy Bednar, Avi Miller, Gavin Bowe, Gia-Khanh Nguyen, Darcy Christensen, Kiran Chamala, Jonathan Creighton, Benoit Dageville, Logeshwaran Rajan, Rajesh Dasari, Angad Gokakkar , Anu Natarajan, Girdhari Ghantiyala, Bernard Clouse, Chandrasekharan Iyer, Anil Nair, Sivaram Soma, Lisa Vaz, Ranjit Noronha, 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

Источник

Install oracle database 19c on oracle linux 8

Database Client Installation Guide

Oracle Database Database Client Installation Guide, 19c for Linux

Primary Author: Prakash Jashnani

Contributing Authors: Douglas Williams, Subhash Chandra

Contributors: Jean-Francois Verrier, Neha Avasthy, Kalambhatti Prashanth, Prasad Bagal, Subhranshu Banerjee, Tammy Bednar, Eric Belden, Gavin Bowe, Robert Chang, Darcy Christensen, Kiran Chamala, Jonathan Creighton, Benoit Dageville, Sudip Datta, Jim Erickson, Marcus Fallen, Joseph Francis, Richard Roddy, Allan Graves, Barbara Glover, Aneesh Khandelwal, Joel Kallman, Eugene Karichkin, Jai Krishnani, Sangeeth Kumar, Kevin Jernigan, Christopher Jones, Prasad Kuruvadi Nagaraj, Bryn Llewellyn, Saar Maoz, Sunil Surabhi, Gopal Mulagund, Sue Lee, Rich Long, Barb Lundhild, Rudregowda Mallegowda, Padmanabhan Manavazhi, Mughees Minhas, Krishna Mohan, Matthew McKerley, John McHugh, Gurudas Pai, Satish Panchumarthy , Rajesh Prasad, Rajendra Pingte, Sivaselvam Narayanasamy, Srinivas Poovala, Mohammed Shahnawaz Quadri, Sangeeth Jose, Gurumurthy Ramamurthy, Hema Ramamurthy, Sunil Ravindrachar, Mark Richwine, Dipak Saggi, Trivikrama Samudrala, Pushkar Punit, David Schreiner, Ara Shakian, Mohit Singhal, Dharma Sirnapalli, Akshay Shah, James Spiller, Roy Swonger, Binoy Sukumaran, Kamal Tbeileh, Ravi Thammaiah, Shekhar Vaggu, Peter Wahl, Terri Winters, Sergiusz Wolicki

Источник

Oracle Database 19c Installation On Oracle Linux 8 (OL8)

Oracle database 19c is supported on Oracle Linux 8, but you must be running on UEK6 and database version 19.7. The installation will work without the patches, but it will not be supported without them.

This article describes the installation of Oracle Database 19c 64-bit on 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 here.

Download Software

Download the Oracle software from OTN or MOS depending on your support status.

Hosts File

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

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

Oracle Installation Prerequisites

Perform either the Automatic Setup or the Manual Setup to complete the basic prerequisites. The Additional Setup is required for all installations.

Automatic Setup

If you plan to use the «oracle-database-preinstall-19c» package to perform all your prerequisite setup, issue the following command.

It is probably worth doing a full update as well, but this is not strictly speaking necessary.

It’s worth running the all the DNF commands listed in the manual setup section. Depending on the OS package groups you have selected, some additional packages might also be needed.

If you are using RHEL8 or CentOS8, you can pick up the RPM from the OL8 repository and install it. It will pull the dependencies from your normal repositories.

Manual Setup

If you have not used the «oracle-database-preinstall-19c» package to perform all prerequisites, you will need to manually perform the following setup tasks.

Add the following lines to the «/etc/sysctl.conf» file, or in a file called «/etc/sysctl.d/98-oracle.conf».

Run one of the following commands to change the current kernel parameters, depending on which file you edited.

Add the following lines to a file called «/etc/security/limits.d/oracle-database-preinstall-19c.conf» file.

Add the following line to the «/etc/pam.d/login» file, if it does not already exist.

The following packages are listed as required. Don’t worry if some don’t install. It won’t prevent the installation.

Create the new groups and users.

Uncomment the extra groups you require.

Additional Setup

Set the password for the «oracle» user.

Set secure Linux to permissive by editing the «/etc/selinux/config» file, making sure the SELINUX flag is set as follows.

Once the change is complete, restart the server or run the following command.

If you have the Linux firewall enabled, you will need to disable or configure it, as shown here. To disable it, do the following.

If you are not using Oracle Linux and UEK, you will need to manually disable transparent huge pages.

Create the directories in which the Oracle software will be installed.

Putting mount points directly under root without mounting separate disks to them is typically a bad idea. It’s done here for simplicity, but for a real installation «/» storage should be reserved for the OS.

Unless you are working from the console, or using SSH tunnelling, login as root and issue the following command.

The scripts are created using the cat command, with all the «$» characters escaped. If you want to manually create these files, rather than using the cat command, remember to remove the «\» characters before the «$» characters.

Create a «scripts» directory.

Create an environment file called «setEnv.sh». The «$» characters are escaped using «\». If you are not creating the file with the cat command, you will need to remove the escape characters.

Add a reference to the «setEnv.sh» file at the end of the «/home/oracle/.bash_profile» file.

Create a «start_all.sh» and «stop_all.sh» script that can be called from a startup/shutdown service. Make sure the ownership and permissions are correct.

Once the installation is complete and you’ve edited the «/etc/oratab», you should be able to start/stop the database with the following scripts run from the «oracle» user.

You can see how to create a Linux service to automatically start/stop the database here.

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

Switch to the ORACLE_HOME directory, unzip the software directly into this path and start the Oracle Universal Installer (OUI) by issuing one of the following commands in the ORACLE_HOME directory. The interactive mode will display GUI installer screens to allow user input, while the silent mode will install the software without displaying any screens, as all required options are already specified on the command line.

Run the root scripts when prompted.

You can read more about silent installations here.

You are now ready to create a database, but it’s better to patch the installation first if you have access to Oracle Support.

Patch Installation (Optional)

The installation of 19.3 will work without applying the patches. If you don’t have access to the patches and are just doing the installation for a test system, you can proceed without this step.

For the installation to be supported you need to be on patch level 19.7 (April 2020) or later. To get the patches you need to have a valid Oracle Support CSI so you can download them from Oracle Support. This is an example of applying the 19.7 patch to a clean standalone installation without ASM and before a database is created.

For patches on real systems, always read the patch notes.

Database Creation

You create a database using the Database Configuration Assistant (DBCA). The interactive mode will display GUI screens to allow user input, while the silent mode will create the database without displaying any screens, as all required options are already specified on the command line.

You can read more about silent database creation here.

Post Installation

Edit the «/etc/oratab» file setting the restart flag for each instance to ‘Y’.

Enable Oracle Managed Files (OMF) and make sure the PDB starts when the instance starts.

Источник

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.

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.

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.

On RHEL you will need to manually get the prerequisites RPM from the Yum repository and run it manually before installing the database 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».

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.

Источник

DBAORA

oracle expert presents

Install Oracle Database 19C in silent mode on OEL8

This article presents how to install Oracle 19C on Oracle Enterprise Linux 8 (OEL8) in silent mode.

Read following article how to install Oracle Enterprise Linux 8: Install Oracle Linux 8 (OEL8) (for comfort set 8G memory for your virtual machine before proceeding with Oracle software installation).

NOTE – officially 19C is not yet supported on OEL8

Software for 19C is available on OTN or edelivery

Original Oracle documentation for installation 19C for Linux

OS configuration and preparation

OS configuration is executed as root. To login as root just execute following command in terminal.

The “/etc/hosts” file must contain a fully qualified name for the server.

It’s recommended to update OS with latest packages

Extra configuration steps:

add new OS groups
add new OS user
install required OS packages
set specific kernel parameters
disable transparent hugepages and defrag

Above steps can be done automatic or manually

Automatic

Execute following command

Details about steps executed by above statement can be found in file

Manual

Manual installation can give you more control on installation

Add user Oracle for database software

Change password for user Oracle

Install required packages

Add kernel parameters to /etc/sysctl.conf

Apply kernel parameters

Add following lines to set shell limits for user oracle in file /etc/security/limits.conf

Disabling Transparent Hugepages and defrag

This step is recommended by Oracle to avoid later performance problems – Doc ID 1557478.1 . It can be done by adding transparent_hugepage=never to /etc/default/grub

After applying and rebooting host can be checked with following command

Create directory structure for binaries as user root

ORACLE_BASE – /ora01/app/oracle
ORACLE_HOME – /ora01/app/oracle/product/19.3.0.0/db_1

Add following lines in /home/oracle/.bash_profile for user oracle

Install database software

Connect as user oracle

Let’s start with database software installation as oracle user. Copy zip to ORACLE_HOME directory and then uznip it. It’s ready binaries !

after unzip you should see following

check environment settings

Once Oracle 19C binaries are unzipped. In following directories you can find response files that stores parameters necessary to install Oracle components:

directory	response file
$ORACLE_HOME/install/response	db_install.rsp
$ORACLE_HOME/assistants/dbca	dbca.rsp
$ORACLE_HOME/assistants/netca	netca.rsp

db_install.rsp – used to install oracle binaries, install/upgrade a database in silent mode
dbca.rsp – used to install/configure/delete a database in silent mode
netca.rsp – used to configure simple network for oracle database in silent mode

Install Oracle binaries

It’s the best to preserve original response file db_install.rsp before editing it

Edit file db_install.rsp to set parameters required to install binaries. This is just example and in next releases parameters can be different. Each of presented parameter is very well described in db_install.rsp. I just give here brief explanations.

once edition is completed. Start binaries installation.

output is following

Successfully Setup Software with warning(s).
Moved the install session logs to:
/ora01/app/oraInventory/logs/InstallActions2019-08-17_01-18-38PM

I got warnings about memory Oracle requires 8GB ram but VirtualBox consumed 128MB for VideoMemory.

you are asked to run two scripts as user root. Once it’s done binaries are installed. I’m not sure if it’s necessary from previous logs it looks it’s already done

quick binary verification

Configure Oracle Net

Again based on response file Oracle Net will be configured

You can edit netca.rsp to set own parameters. I didn’t changed anything here. So just start standard configuration. It will configure LISTENER with standard settings.

Check LISTENER status

The last setup is to create new container database ORA19C.dbaora.com with one pluggable database PORA1891 and configure and enable oracle db express

Prepare directories for database datafiles and flash recovery area

backup original response file for dbca

set own parameters

run database installation

Check port status of db express in root database

Источник