Sunday, July 4, 2021

Oracle Database 19c -- Installation on Oracle Linux 8

Problem

You want to install Oracle Database 19c for non-prod purposes the simplest and easiest way with minimal configuration steps
 

Solution

1. Complete your database server setup. For example, check
Oracle Linux 8 -- Minimal Installation In a VirtualBox VM
 
2. Install Preinstallation RPM:
 
$ sudo dnf install oracle-database-preinstall-19c 

Verify log file:

/var/log/oracle-database-preinstall-19c/backup/<timestamp>/orakernel.log

 

 
4. Perform RPM-based software-only installation of Oracle Database 19c:
 
Note. Oracle Base and Oracle Home directories are preconfigured to /opt/oracle and cannot be changed. Ensure /opt/oracle path has sufficient space.

$ sudo dnf localinstall <path>/oracle-database-ee-19c-1.0-1.x86_64.rpm

Optionally install latest Release Update


5. Database creation and configuration can be controlled/performed by these scripts:

/etc/sysconfig/oracledb_ORCLCDB-19c.conf
/etc/init.d/oracledb_ORCLCDB-19c

It is advisable to keep the aforementioned scripts as templates and clone them to editable versions of specific deployment scripts, for example:

$ cd /etc/sysconfig/
$ sudo cp oracledb_ORCLCDB-19c.conf oracledb_MYCDB1-19c.conf
 
$ cd  /etc/init.d
$ sudo cp oracledb_ORCLCDB-19c oracledb_MYCDB1-19c
 
$ sudo sed -i 's/ORCLCDB/MYCDB1/g' oracledb_MYCDB1-19c

Optionally, edit /etc/init.d/oracledb_MYCDB1-19c to tune the parameters passed to the DBCA utility


6. Create a new container database MYCDB1:

$ sudo /etc/init.d/oracledb_MYCDB1-19c configure


7. If Oracle Home had been previously patched or Release Update had been deployed to the Oracle Home, then modified SQL files need to be loaded into the database:

$ cd $ORACLE_HOME/OPatch
$ ./datapatch -verbose
 
 
For reference:
  • Oracle Database Install FAQ(18c & higher) : Changes,New Features(RPM Based Install & Read Only Oracle Home & Other Features) (Doc ID 2438532.1)
  • 18c : Installing Oracle Database Using RPM Packages (Doc ID 2425736.1)

No comments: