Skip to main content

How to Install Oracle 19c Database on OEL 7.9

How to Install Oracle 19c Database on OEL 7.9

In this post, I am going to share the steps to install a 19c database on OEL 7.9
I have already created a VM for this setup.

OS version: OEL 7.9

























Add the hostname and IP in /etc/hosts if not using DNS as per your server setup


[root@fundb ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.21 fundb.training fundb


Download the latest oel 7 public repositories on the server to do the setup. I will use the same to install all the prereqs for the 19c database.

[root@fundb yum.repos.d]# cd /etc/yum.repos.d

[root@fundb yum.repos.d]# wget http://yum.oracle.com/public-yum-ol7.repo

--2021-02-09 17:15:53--  http://yum.oracle.com/public-yum-ol7.repo

Resolving yum.oracle.com (yum.oracle.com)... 23.54.89.140

Connecting to yum.oracle.com (yum.oracle.com)|23.54.89.140|:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 16402 (16K) [text/plain]

Saving to: ‘public-yum-ol7.repo’


100%[======================================>] 16,402      --.-K/s   in 0.005s  


2021-02-09 17:15:54 (3.16 MB/s) - ‘public-yum-ol7.repo’ saved [16402/16402]


[root@fundb yum.repos.d]# ls -ltr

total 20

-rw-r--r--. 1 root root 16402 Aug 26  2019 public-yum-ol7.repo


Enable(update from 0 to 1) the addons in repo file.

[ol7_addons]

name=Oracle Linux $releasever Add ons ($basearch)

baseurl=https://yum.oracle.com/repo/OracleLinux/OL7/addons/$basearch/

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

gpgcheck=1

enabled=1


Install prereqs for 19c now.

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


ol7_UEKR5                                                | 2.5 kB     00:00     

ol7_addons                                               | 2.5 kB     00:00     

ol7_latest                                               | 2.7 kB     00:00     

(1/4): ol7_UEKR5/x86_64/updateinfo                         |  53 kB   00:01     

(2/4): ol7_addons/x86_64/primary_db                        | 169 kB   00:01     

(3/4): ol7_addons/x86_64/updateinfo                        |  95 kB   00:02     

(4/4): ol7_UEKR5/x86_64/primary_db                         |  11 MB   00:12     

Resolving Dependencies

--> Running transaction check

---> Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed

If we are using RHEL7 or CentOS7, we can pick up the RPM from the OL7 repository and install it. It will pull the dependencies from your normal repositories.

# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

 

yum update -y 

Verify file /etc/sysctl.conf to see all kernel-level parameters are updated by the previous commands.

Oracle user would be created. Please change the password.

[root@fundb yum.repos.d]# passwd oracle
Changing password for user oracle.
New password: 
BAD PASSWORD: The password contains the user name in some form
Retype new password: 
passwd: all authentication tokens updated successfully.


Verify file "/etc/security/limits.d/oracle-database-preinstall-19c.conf" to see all required changes are updated.


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

SELINUX=permissive

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

# setenforce Permissive

If you have the Linux firewall enabled, you will need to disable or configure it.

To disable it, do the following.

# systemctl stop firewalld
# systemctl disable firewalld

Create directory from oracle user


[oracle@fundb ~]$ mkdir -p /u01/19cDB

Download the 19c(19.3) software from Oracle. Please note there are 2 types of files available to be downloaded. One is RPM-based and the other is a zip file.

I have downloaded the 19c zip file.

Unzip the 19c software at the home location and execute runInstaller.

Go to the directory where the zip file is placed and unzip

[oracle@fundb ~]$ cd /media/sf_Downloads/
[oracle@fundb sf_Downloads]$ unzip -d /u01/19cDB  LINUX.X64_193000_db_home.zip


[oracle@fundb 19cDB]$ pwd
/u01/19cDB
[oracle@fundb 19cDB]$ ls
addnode     css     deinstall    env.ora        javavm  md       OPatch   oui      R            root.sh.old.1  sqlj      usm
apex        ctx     demo         has            jdbc    mgw      opmn     owm      racg         runInstaller   sqlpatch  utl
assistants  cv      diagnostics  hs             jdk     network  oracore  perl     rdbms        schagent.conf  sqlplus   wwg
bin         data    dmu          install        jlib    nls      ord      plsql    relnotes     sdk            srvm      xdk
clone       dbjava  drdaas       instantclient  ldap    odbc     ords     precomp  root.sh      slax           suptools
crs         dbs     dv           inventory      lib     olap     oss      QOpatch  root.sh.old  sqldeveloper   ucp

Open GUI and run the installer from oracle user
[oracle@fundb 19cDB]$ export DISPLAY=:0
./runInstaller
if using linux 8 then need to export below before installation
# Fake Oracle Linux 7.
export CV_ASSUME_DISTID=OEL7.6
Follow the screenshot below and start the installation.

Select the installer and create a database option



Select server class


Select Enterprise edition




Select base location





I am creating a non-container database in this post.






I know the root password so have given, else after installation it will ask to run a script via root.




I have ignored the swap space error but please increase the swap are to a minimum of 4 Gb.






























Once completed you might need to run root.sh if earlier root password was not given via root user. 

Let's verify the database now

[oracle@fundb ~]$ . oraenv
ORACLE_SID = [oracle] ? GOLD19
The Oracle base has been set to /u01/app/oracle
[oracle@fundb ~]$ echo $ORACLE_HOME
/u01/19cDB
[oracle@fundb ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 10 15:37:12 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE
--------- --------------------
GOLD19	  READ WRITE



If you like please follow and comment
Labels:

Comments

Post a Comment

Popular posts from this blog

WebLogic migration to OCI using WDT tool

WebLogic migration to OCI using WDT tool Oracle WebLogic Deploy Tool (WDT) is an open-source project designed to simplify and streamline the management of Oracle WebLogic Server domains. With WDT, you can export configuration and application files from one WebLogic Server domain and import them into another, making it a highly effective tool for tasks like migrating on-premises WebLogic configurations to Oracle Cloud. This blog outlines a detailed step-by-step process for using WDT to migrate WebLogic resources and configurations. Supported WLS versions Why Use WDT for Migration? When moving Oracle WebLogic resources from an on-premises environment to Oracle Cloud (or another WebLogic Server), WDT provides an efficient and reliable approach to: Discover and export domain configurations and application binaries. Create reusable models and archives for deployment in a target domain. Key Pre-Requisites Source System: An Oracle WebLogic Server with pre-configured resources such as: Applica...
Post a Comment
Read more

How to Validate TDE Wallet Password in Oracle Database

How to Validate TDE Wallet Password in Oracle Database Validating the Transparent Data Encryption (TDE) wallet password is crucial, especially when ensuring that the password is correct without using the OPEN or CLOSE commands in the database. This blog post explains a straightforward method to validate the TDE password using the mkstore utility. Steps to Validate TDE Wallet Password Follow these steps to validate the TDE wallet password: Step 1: Copy the Keystore/Wallet File Navigate to your existing TDE wallet directory. Copy only the ewallet.p12 file to a new directory. If a cwallet.sso file exists, do not copy it . The absence of cwallet.sso ensures that the wallet does not use auto-login, forcing the utility to prompt for the password. Step 2: Validate Using mkstore Use the mkstore utility to check the contents of the wallet file. The mkstore utility will prompt you for the TDE wallet password, allowing you to validate its correctness. Command Syntax To display the conten...
Post a Comment
Read more

Rename a PDB in Oracle Database Multitenant Architecture in TDE and Non TDE Environment

Rename a PDB in Oracle Database Multitenant Architecture I am sharing a step-by-step guide to help you rename a PDB. This approach uses SQL commands. Without TDE or encryption Wallet Initial Check Check the Current Database Name and Open Mode: SQL > SELECT NAME, OPEN_MODE FROM V$DATABASE; NAME OPEN_MODE --------- -------------------- BEECDB READ WRITE List Current PDBs: SQL > SHOW PDBS; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FUAT READ WRITE NO We need to RENAME FUAT to BEE  Steps to Rename the PDB Step 1: Export ORACLE_SID Set the Oracle SID to the Container Database (CDB): export ORACLE_SID=BEECDB Step 2: Verify Target PDB Name Availability If the target PDB name is different from the current PDB name, ensure no service exists with the target PDB name. Run SQL to Check Exi...
Post a Comment
Read more