Hello Friends, in this article we are going to learn how to install oracle 19c on OEL 7) step by step. In this installation, we use the oracle-database-preinstall-19c package.
Creating Non-CDB database in silent mode – ORACLE 19C
OS Version
OS version which we are going to use in this article.
#cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.8 (Maipo)Prerequisite for Oracle 19c installation
The hardware requirement for Oracle 19c Installation is listed below.
- Minimum 12 GB hard disk space required.
- Minimum 2 GB RAM free.
- SWAP 2GB (If RAM is between 2 GB and 16 GB, then 1 time the size of the RAM).
Download Oracle Database 19c software
You can download oracle database 19c software from OTN or Edelivery using the below link.
Note: Unzip the oracle software but remember where you unzip the oracle software that will be the default oracle home location. After unzipping the software it will not keep all the files in a single folder like 10g, 11g & 12c.
Oracle 19c Installation
Let's start the Oracle 19c database software installation step by step.
Create Oracle Home directory location.
Step 1. Login as root user and make directory oracle home directory.
#mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1UNZIP the software
Step 2. Using unzip command unzip the database software inside the Oracle home location.
#cd /u02
#ls -l
LINUX.X64_193000_db_home
#unzip LINUX.X64_193000_db_home.zip -d/u01/app/oracle/product/19.3.0/dbhome_1/Setup Prerequisites Automatically
Step 3. If you want to setup prerequisites automatically then run the below command which is automatically setup all prerequisites.
[root@digital ~]# yum -y install oracle-database-preinstall-19c
Loaded plugins: langpacks, ulninfo
ol7_UEKR5 | 2.5 kB 00:00:00
ol7_latest | 2.7 kB 00:00:00
(1/4): ol7_UEKR5/x86_64/updateinfo | 78 kB 00:00:01
(2/4): ol7_latest/x86_64/updateinfo | 3.2 MB 00:00:02
(3/4): ol7_UEKR5/x86_64/primary_db | 18 MB 00:00:11
(4/4): ol7_latest/x86_64/primary_db | 35 MB 00:00:12
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-3.el7 will be installed
--> Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-3.el7.x86_64
--> Running transaction check
---> Package ksh.x86_64 0:20120801-142.0.1.el7 will be installed
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
============================================================================================
Package Arch Version Repository Size
============================================================================================
Installing:
oracle-database-preinstall-19c x86_64 1.0-3.el7 ol7_latest 27 k
Installing for dependencies:
ksh x86_64 20120801-142.0.1.el7 ol7_latest 882 k
libaio-devel x86_64 0.3.109-13.el7 ol7_latest 12 k
Transaction Summary
============================================================================================
Install 1 Package (+2 Dependent packages)
Total download size: 921 k
Installed size: 3.2 M
Downloading packages:
No Presto metadata available for ol7_latest
warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/ksh-20120801-142.0.1.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID
ec551f03: NOKEY
Public key for ksh-20120801-142.0.1.el7.x86_64.rpm is not installed
(1/3): ksh-20120801-142.0.1.el7.x86_64.rpm | 882 kB 00:00:01
(2/3): oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm | 27 kB 00:00:00
(3/3): libaio-devel-0.3.109-13.el7.x86_64.rpm | 12 kB 00:00:01
--------------------------------------------------------------------------------------------
Total 472 kB/s | 921 kB 00:00:01
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Importing GPG key 0xEC551F03:
Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03
Package : 7:oraclelinux-release-7.8-1.0.7.el7.x86_64 (@anaconda/7.8)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : ksh-20120801-142.0.1.el7.x86_64 1/3
Installing : libaio-devel-0.3.109-13.el7.x86_64 2/3
Installing : oracle-database-preinstall-19c-1.0-3.el7.x86_64 3/3
Verifying : libaio-devel-0.3.109-13.el7.x86_64 1/3
Verifying : oracle-database-preinstall-19c-1.0-3.el7.x86_64 2/3
Verifying : ksh-20120801-142.0.1.el7.x86_64 3/3
Installed:
oracle-database-preinstall-19c.x86_64 0:1.0-3.el7
Dependency Installed:
ksh.x86_64 0:20120801-142.0.1.el7 libaio-devel.x86_64 0:0.3.109-13.el7
Complete!
[root@digital ~]#Change the password for Oracle user
Step 4. The above command will create the oracle user also, so we need to change the password for oracle as per our convenience.
# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.Grant privileges to ORACLE user
Step 5. We need to grant privileges on the Oracle home directory and oinstall group to oracle user.
#chmod -R 775 /u01
#chown -R oracle:oinstall /u01Invoke runinstaller
Step 6. Login as an oracle user and execute the runinstaller.
[oracle@digital ~]$ cd /u01/app/oracle/product/19.3.0/dbhome_1/
[oracle@digital dbhome_1]$ ls -l
total 124
drwxrwxr-x. 2 oracle oinstall 102 May 2 09:26 addnode
drwxrwxr-x. 6 oracle oinstall 4096 Apr 17 2019 apex
drwxrwxr-x. 9 oracle oinstall 93 Apr 17 2019 assistants
drwxr-xr-x. 2 oracle oinstall 8192 May 2 09:29 bin
drwxr-xr-x. 4 oracle oinstall 30 May 2 09:26 cfgtoollogs
drwxrwxr-x. 4 oracle oinstall 87 May 2 09:26 clone
drwxrwxr-x. 6 oracle oinstall 55 Apr 17 2019 crs
drwxrwxr-x. 3 oracle oinstall 18 Apr 17 2019 css
drwxrwxr-x. 11 oracle oinstall 4096 Apr 17 2019 ctx
drwxrwxr-x. 7 oracle oinstall 71 Apr 17 2019 cv
drwxrwxr-x. 3 oracle oinstall 20 Apr 17 2019 data
drwxrwxr-x. 3 oracle oinstall 19 Apr 17 2019 dbjava
drwxrwxr-x. 2 oracle oinstall 22 Apr 17 2019 dbs
drwxrwxr-x. 5 oracle oinstall 4096 May 2 09:26 deinstall
drwxrwxr-x. 3 oracle oinstall 20 Apr 17 2019 demo
drwxrwxr-x. 3 oracle oinstall 20 Apr 17 2019 diagnostics
drwxrwxr-x. 13 oracle oinstall 4096 Apr 17 2019 dmu
drwxrwxr-x. 4 oracle oinstall 30 Apr 17 2019 drdaas
drwxrwxr-x. 3 oracle oinstall 19 Apr 17 2019 dv
-rwxrwxr-x. 1 oracle oinstall 852 Aug 18 2015 env.ora
drwxrwxr-x. 3 oracle oinstall 18 Apr 17 2019 has
drwxrwxr-x. 5 oracle oinstall 41 Apr 17 2019 hs
drwxrwx---. 10 oracle oinstall 4096 May 2 09:29 install
drwxrwxr-x. 2 oracle oinstall 29 Apr 17 2019 instantclient
drwxr-x---. 14 oracle oinstall 4096 May 2 09:26 inventory
drwxrwxr-x. 8 oracle oinstall 82 Apr 18 2019 javavm
drwxrwxr-x. 3 oracle oinstall 35 Apr 17 2019 jdbc
drwxrwxr-x. 6 oracle oinstall 4096 Apr 18 2019 jdk
drwxrwxr-x. 2 oracle oinstall 4096 Apr 17 2019 jlib
drwxrwxr-x. 10 oracle oinstall 4096 Apr 17 2019 ldap
drwxrwxr-x. 4 oracle oinstall 12288 May 2 09:26 lib
drwxrwxr-x. 9 oracle oinstall 98 Apr 17 2019 md
drwxrwxr-x. 4 oracle oinstall 31 Apr 17 2019 mgw
drwxrwxr-x. 10 oracle oinstall 4096 Apr 17 2019 network
drwxrwxr-x. 5 oracle oinstall 46 Apr 17 2019 nls
drwxrwxr-x. 8 oracle oinstall 101 Apr 17 2019 odbc
drwxrwxr-x. 5 oracle oinstall 42 Apr 17 2019 olap
drwxrwxr-x. 14 oracle oinstall 4096 May 2 09:26 OPatch
drwxrwxr-x. 7 oracle oinstall 65 Apr 17 2019 opmn
drwxrwxr-x. 4 oracle oinstall 34 Apr 17 2019 oracore
-rw-r-----. 1 oracle oinstall 56 May 2 09:24 oraInst.loc
drwxrwxr-x. 6 oracle oinstall 52 Apr 17 2019 ord
drwxrwxr-x. 4 oracle oinstall 66 Apr 17 2019 ords
drwxrwxr-x. 3 oracle oinstall 19 Apr 17 2019 oss
drwxrwxr-x. 8 oracle oinstall 4096 May 2 09:26 oui
drwxrwxr-x. 4 oracle oinstall 33 Apr 17 2019 owm
drwxrwxr-x. 5 oracle oinstall 39 Apr 17 2019 perl
drwxrwxr-x. 6 oracle oinstall 78 Apr 17 2019 plsql
drwxrwxr-x. 6 oracle oinstall 56 Apr 18 2019 precomp
drwxrwxr-x. 2 oracle oinstall 26 Apr 17 2019 QOpatch
drwxrwxr-x. 5 oracle oinstall 52 Apr 17 2019 R
drwxrwxr-x. 4 oracle oinstall 29 Apr 17 2019 racg
drwxrwxr-x. 13 oracle oinstall 4096 Apr 18 2019 rdbms
drwxrwxr-x. 3 oracle oinstall 21 Apr 17 2019 relnotes
-rwx------. 1 oracle oinstall 638 May 2 09:26 root.sh
-rwxrwxr-x. 1 oracle oinstall 786 Apr 17 2019 root.sh.old
-rwxrwxr-x. 1 oracle oinstall 10 Apr 17 2019 root.sh.old.1
-rwxrwxr-x. 1 oracle oinstall 638 Apr 18 2019 root.sh.old.2
-rwxrwxr-x. 1 oracle oinstall 10 Apr 17 2019 root.sh.old.3
-rwxr-x---. 1 oracle oinstall 1783 Mar 8 2017 runInstaller
-rwxrwxr-x. 1 oracle oinstall 2927 Oct 14 2016 schagent.conf
drwxrwxr-x. 5 oracle oinstall 4096 Apr 17 2019 sdk
drwxrwxr-x. 3 oracle oinstall 18 Apr 17 2019 slax
drwxrwxr-x. 4 oracle oinstall 41 Apr 17 2019 sqldeveloper
drwxrwxr-x. 3 oracle oinstall 17 Apr 17 2019 sqlj
drwxrwxr-x. 4 oracle oinstall 4096 Apr 18 2019 sqlpatch
drwxrwxr-x. 6 oracle oinstall 53 May 2 09:26 sqlplus
drwxrwxr-x. 6 oracle oinstall 54 Apr 17 2019 srvm
drwxrwxr-x. 5 oracle oinstall 45 Apr 17 2019 suptools
drwxrwxr-x. 3 oracle oinstall 35 Apr 17 2019 ucp
drwxrwxr-x. 4 oracle oinstall 31 Apr 17 2019 usm
drwxrwxr-x. 2 oracle oinstall 33 Apr 17 2019 utl
drwxrwxr-x. 3 oracle oinstall 19 Apr 17 2019 wwg
drwxr-x---. 7 oracle oinstall 69 Apr 17 2019 xdk$./runInstaller
Step 7. Select the setup software-only option, but if you want to create a database as well as then you can select the first option.
Step 8. Here we are going to install a single instance database.
Step 9. Chose Enterprise Edition option
Step 10. Browse oracle base location.
Step 11. Inventory Directory
Step 12. OS system groups privileged
Step 13. Root script execution - leave empty
Step 14. Oracle 19c installation prerequisite check
Step 15. If everything is running well in oracle 19c setup it is shown in below screen.
Step 16. After clicking on install the ORACLE 19c database software installation started.
Step 17. Execute the below scripts as the root user.
Execute orainstRoot.sh and root.sh as the root user.
[root@digital ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@digital ~]#
[root@digital ~]#
[root@digital ~]#
[root@digital ~]# /u01/app/oracle/product/19.3.0/dbhome_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19.3.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :
/u01/app/oracle/product/19.3.0/dbhome_1/bin/tfactl
Note :
1. tfactl will use TFA Service if that service is running and user has been granted access
2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed
[root@digital ~]#
Step 18. Finally, your 19c software installation was completed.
Test the Installation
Step 19. Check database installation is working.
[oracle@digital bin]$cd /u01/app/oracle/product/19.3.0/dbhome_1/bin
[oracle@digital bin]$export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1/
[oracle@digital bin]$
[oracle@digital bin]$ ./sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 2 22:18:55 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Enter user-name:I hope you found this article very useful, if yes please write your fillings in the comment box.
Great article 🙂