Oracle Database 19c Installation On Oracle Linux 7.1

I will describe the installation process of Oracle 19c (19.3) Database on Oracle Linux 7.1 on VM.

1. Create VM:

2. Software Download:

3. Install Oracle Linux 7.1 on VM:

How to Install Oracle Linux 7.1 on VM: Instillation Steps

4. Oracle Database Installation Prerequisites:

There are two ways can configure prerequisties –

  • Auto Setup: Using Oracle provided package.
  • Manual Setup: Install recommended packages and create user and groups manually.

4.1 Auto Setup:

4.1.1 Using Oracle provided package:

If You have Internet connection on your VM, You may install this package – oracle-database-preinstall-19c which will install all required prerequisites of Oracle Database 19c.

[root@ol71orcl193 ~]# yum install -y oracle-database-preinstall-19c
Loaded plugins: langpacks
ol7_UEKR3                                                                             | 2.5 kB  00:00:00
ol7_latest                                                                            | 2.7 kB  00:00:00
(1/5): ol7_UEKR3/x86_64/updateinfo                                                    | 116 kB  00:00:00
(2/5): ol7_latest/x86_64/group                                                        | 660 kB  00:00:01
(3/5): ol7_latest/x86_64/updateinfo                                                   | 2.9 MB  00:00:03
(4/5): ol7_UEKR3/x86_64/primary_db                                                                                   |  66 MB  00:00:28
(5/5): ol7_latest/x86_64/primary_db                                                                                  |  36 MB  00:00:29
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed
--> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> 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
--> Processing Dependency: libaio(x86-64) = 0.3.109-13.el7 for package: libaio-devel-0.3.109-13.el7.x86_64
---> Package libstdc++-devel.x86_64 0:4.8.5-39.0.5.el7 will be installed
--> Processing Dependency: libstdc++(x86-64) = 4.8.5-39.0.5.el7 for package: libstdc++-devel-4.8.5-39.0.5.el7.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.109-12.el7 will be updated
---> Package libaio.x86_64 0:0.3.109-13.el7 will be an update
---> Package libstdc++.x86_64 0:4.8.3-9.el7 will be updated
---> Package libstdc++.x86_64 0:4.8.5-39.0.5.el7 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================
 Package                                       Arch                  Version                                Repository                 Size
============================================================================================================================================
Installing:
 oracle-database-preinstall-19c                x86_64                1.0-2.el7                              ol7_latest                 19 k
Installing for dependencies:
 compat-libcap1                                x86_64                1.10-7.el7                             ol7_latest                 17 k
 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
 libstdc++-devel                               x86_64                4.8.5-39.0.5.el7                       ol7_latest                1.5 M
Updating for dependencies:
 libaio                                        x86_64                0.3.109-13.el7                         ol7_latest                 24 k
 libstdc++                                     x86_64                4.8.5-39.0.5.el7                       ol7_latest                306 k

Transaction Summary
============================================================================================================================================
Install  1 Package  (+4 Dependent packages)
Upgrade             ( 2 Dependent packages)

Total download size: 2.7 M
Downloading packages:
No Presto metadata available for ol7_latest
warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/compat-libcap1-1.10-7.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Public key for compat-libcap1-1.10-7.el7.x86_64.rpm is not installed
(1/7): compat-libcap1-1.10-7.el7.x86_64.rpm                                                                          |  17 kB  00:00:00
(2/7): libaio-0.3.109-13.el7.x86_64.rpm                                                                              |  24 kB  00:00:01
(3/7): libaio-devel-0.3.109-13.el7.x86_64.rpm                                                                        |  12 kB  00:00:00
(4/7): libstdc++-4.8.5-39.0.5.el7.x86_64.rpm                                                                         | 306 kB  00:00:00
(5/7): libstdc++-devel-4.8.5-39.0.5.el7.x86_64.rpm                                                                   | 1.5 MB  00:00:00
(6/7): ksh-20120801-142.0.1.el7.x86_64.rpm                                                                           | 882 kB  00:00:03
(7/7): oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm                                                           |  19 kB  00:00:01
--------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                       672 kB/s | 2.7 MB  00:00:04
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.1-1.0.5.el7.x86_64 (@anaconda/7.1)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : libstdc++-4.8.5-39.0.5.el7.x86_64                                                                                        1/9
  Updating   : libaio-0.3.109-13.el7.x86_64                                                                                             2/9
  Installing : libaio-devel-0.3.109-13.el7.x86_64                                                                                       3/9
  Installing : libstdc++-devel-4.8.5-39.0.5.el7.x86_64                                                                                  4/9
  Installing : compat-libcap1-1.10-7.el7.x86_64                                                                                         5/9
  Installing : ksh-20120801-142.0.1.el7.x86_64                                                                                          6/9
  Installing : oracle-database-preinstall-19c-1.0-2.el7.x86_64                                                                          7/9
  Cleanup    : libstdc++-4.8.3-9.el7.x86_64                                                                                             8/9
  Cleanup    : libaio-0.3.109-12.el7.x86_64                                                                                             9/9
  Verifying  : libaio-0.3.109-13.el7.x86_64                                                                                             1/9
  Verifying  : libstdc++-devel-4.8.5-39.0.5.el7.x86_64                                                                                  2/9
  Verifying  : ksh-20120801-142.0.1.el7.x86_64                                                                                          3/9
  Verifying  : compat-libcap1-1.10-7.el7.x86_64                                                                                         4/9
  Verifying  : libaio-devel-0.3.109-13.el7.x86_64                                                                                       5/9
  Verifying  : libstdc++-4.8.5-39.0.5.el7.x86_64                                                                                        6/9
  Verifying  : oracle-database-preinstall-19c-1.0-2.el7.x86_64                                                                          7/9
  Verifying  : libaio-0.3.109-12.el7.x86_64                                                                                             8/9
  Verifying  : libstdc++-4.8.3-9.el7.x86_64                                                                                             9/9

Installed:
  oracle-database-preinstall-19c.x86_64 0:1.0-2.el7

Dependency Installed:
  compat-libcap1.x86_64 0:1.10-7.el7                ksh.x86_64 0:20120801-142.0.1.el7         libaio-devel.x86_64 0:0.3.109-13.el7
  libstdc++-devel.x86_64 0:4.8.5-39.0.5.el7

Dependency Updated:
  libaio.x86_64 0:0.3.109-13.el7                                     libstdc++.x86_64 0:4.8.5-39.0.5.el7

Complete!

Note::: If installed this package – “oracle-database-preinstall-19c” then you don’t need to perform any other activity including User and Groups. Good to install Oracle Software now.

4.1.2. User Validation:

Created below groups and oracle user by above package.

[root@ol71ora193 ~]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
e
[root@ol71ora193 ~]# 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.
[root@ol71ora193 ~]# su - oracle

4.1.3 Verify the Kernel parameters

[root@ol71ora193 ~]# /sbin/sysctl -p /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
[root@ol71ora193 ~]# /sbin/sysctl -p /etc/sysctl.d/99-sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
[root@ol71ora193 ~]# cat /etc/security/limits.d/oracle-database-preinstall-19c.conf | grep oracle
oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
or 3GB on x86 OR 90 % of RAM
oracle   hard   memlock    134217728
3GB on x86 OR 90% of RAM
oracle   soft   memlock    134217728
oracle   soft   data    unlimited
oracle   hard   data    unlimited
[root@ol71ora193 ~]# /sbin/sysctl -p /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
[root@ol71ora193 ~]# /sbin/sysctl -p /etc/sysctl.d/99-sysctl.conf
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576

4.2 Manual Setup:

4.2.1 Add following parameters on /etc/sysctl.conf

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

4.2.2 Validate all parameters on /etc/sysctl.conf.

[root@ol71orcl193 ~]# /sbin/sysctl -p
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

4.2.3 Add following lines to /etc/security/limits.conf.

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
oracle   hard   memlock    134217728
oracle   soft   memlock    134217728

4.2.4 Create Users and Groups: For separation of duties, Oracle recommend to create necessary groups. But most of the cases, below highlighted group will be fine.

groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper

groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
groupadd -g 54330 racdba

useradd -u 54321 -g oinstall -G dba,oper oracle

For details of these groups, you may visit oracle site : Groups

4.2.5. The following packages are recommended to install as prerequisites.

yum install bc
yum install binutils
yum install compat-libcap1
yum install compat-libstdc++33
yum install elfutils-libelf
yum install elfutils-libelf-devel
yum install fontconfig-devel
yum install glibc
yum install glibc-devel
yum install ksh
yum install libaio
yum install libaio-devel
yum install libXrender
yum install libXrender-devel
yum install libX11
yum install libXau
yum install libXi
yum install libXtst
yum install libgcc
yum install libstdc++
yum install libstdc++-devel
yum install libxcb
yum install make
yum install smartmontools
yum install sysstat

Optional Packages for Oracle Linux 7:

Based on your requirement, install the latest released versions of the following packages:

For Intelligent Platform Management Interface:
yum install ipmiutil

For Oracl RAC and Oracle Clusterware:
yum install net-tools

For Oracle ACFS:
yum install nfs-utils

For Oracle ACFS Remote:
yum install python 
yum install python-configshell
yum install python-rtslib
yum install python-six
yum install targetcli

For details about required Packages check Oracle Site: Packages

4.3 Create required directories for Oracle Software Installation:

[root@ol71orcl193 ~]# mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
[root@ol71orcl193 ~]# mkdir -p /u01/oradata
[root@ol71orcl193 ~]# chown -R oracle:oinstall /u01
[root@ol71orcl193 ~]# chmod -R 775 /u01

4.4 Move software (downloaded binary) to Oracle Home Location.

[oracle@ol71orcl193 dbhome_1]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1
[oracle@ol71orcl193 dbhome_1]$ ls
V982063-01.zip
[oracle@ol71orcl193 dbhome_1]$ unzip V982063-01.zip

[oracle@ol71orcl193 dbhome_1]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1
[oracle@ol71orcl193 dbhome_1]$ 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   V982063-01.zip
bin         data    dmu          install        jlib    nls      ord      plsql    relnotes     sdk            srvm      wwg
clone       dbjava  drdaas       instantclient  ldap    odbc     ords     precomp  root.sh      slax           suptools  xdk
crs         dbs     dv           inventory      lib     olap     oss      QOpatch  root.sh.old  sqldeveloper   ucp

4.5 Add hostname with IP to /etc/hosts file:

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

5. Oracle Database Software Installation:

Trigger runInstaller using GUI.

[oracle@ol71ora193 ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1

[oracle@ol71ora193 ~]$ cd /u01/app/oracle/product/19.3.0/dbhome_1

[oracle@ol71ora193 dbhome_1]$ ls -l runInstaller
-rwxr-x---. 1 oracle oinstall 1783 Mar  8  2017 runInstaller

Select ‘Set Up Software Only‘ option as I will use DBCA for Database Configuration and Click Next.

Choose ‘Single Instance Database Installation‘ Option and click Next.

Choose Database Edition and Click Next…

Provide Oracle Base Location and Click Next…

Leave Default and Click Next…

Select groups for each option. If you have only dba group then select dba group for all. Click Next…

You can provide root password now to run scripts by root user without user Intervation. Don’t Select ‘Automatically run configuration scripts‘ if you want to run manually or need to run by Unix Admin team. Click Next..

Prerequisite Summary. Install below mentioned packages.

Installation recommended packages – kmod-20-21 and kmod-libs-20-21 .

[root@ol71ora193 ~]# yum install kmod-20-21
Loaded plugins: langpacks
No package kmod-20-21 available.
Error: Nothing to do
[root@ol71ora193 ~]# yum install kmod-20-21*
Loaded plugins: langpacks
Resolving Dependencies
--> Running transaction check
---> Package kmod.x86_64 0:14-10.el7 will be updated
---> Package kmod.x86_64 0:20-21.0.1.el7 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
 Package                 Arch                      Version                            Repository                     Size
==========================================================================================================================
Updating:
 kmod                    x86_64                    20-21.0.1.el7                      ol7_latest                    120 k

Transaction Summary
==========================================================================================================================
Upgrade  1 Package

Total download size: 120 k
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for ol7_latest
kmod-20-21.0.1.el7.x86_64.rpm                                                                      | 120 kB  00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : kmod-20-21.0.1.el7.x86_64                                                                              1/2
  Cleanup    : kmod-14-10.el7.x86_64                                                                                  2/2
  Verifying  : kmod-20-21.0.1.el7.x86_64                                                                              1/2
  Verifying  : kmod-14-10.el7.x86_64                                                                                  2/2

Updated:
  kmod.x86_64 0:20-21.0.1.el7

Complete!
[root@ol71ora193 ~]# yum install kmod-libs-20-21*
Loaded plugins: langpacks
Resolving Dependencies
--> Running transaction check
---> Package kmod-libs.x86_64 0:14-10.el7 will be updated
---> Package kmod-libs.x86_64 0:20-21.0.1.el7 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================================
 Package                     Arch                     Version                          Repository                    Size
==========================================================================================================================
Updating:
 kmod-libs                   x86_64                   20-21.0.1.el7                    ol7_latest                    50 k

Transaction Summary
==========================================================================================================================
Upgrade  1 Package

Total download size: 50 k
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for ol7_latest
kmod-libs-20-21.0.1.el7.x86_64.rpm                                                                 |  50 kB  00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : kmod-libs-20-21.0.1.el7.x86_64                                                                         1/2
  Cleanup    : kmod-libs-14-10.el7.x86_64                                                                             2/2
  Verifying  : kmod-libs-20-21.0.1.el7.x86_64                                                                         1/2
  Verifying  : kmod-libs-14-10.el7.x86_64                                                                             2/2

Updated:
  kmod-libs.x86_64 0:20-21.0.1.el7

Complete!

Checked on ‘Ignore All’ Option and click Next…

Click Yes to confirm for prerequisites ignorance.

Summary of selected options. Click Install…

Installation is progressing…

Run below scripts from root user. After Execution of scripts, Click OK.

Scripts Execution from root user and Click OK on above window.

[root@ol71ora193 ~]# /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@ol71ora193 ~]# /u01/app/ora
oracle/       oraInventory/
[root@ol71ora193 ~]# /u01/app/oracle/
checkpoints/ diag/        product/
[root@ol71ora193 ~]# /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 

Installation Completed Successfully… Click Close.

6. Create Database Using DBCA:

Create a container and pluggable database using DBCA.

[oracle@ol71ora193 dbhome_1]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1
[oracle@ol71ora193 dbhome_1]$ dbca

Choose ‘Create a Database‘ option. Click Next…

Choose ‘Advanced configuration‘ option and Click Next..

Select Database Type -> Oracle Single Instance Database
Select template -> General Purpose or Transaction Processing.

Click Next…

Provide Global Database Name and SID.
Select ‘Create as Container Database‘ and provide PDB Name.
Click Next..

For Storage Option -> you can select either -> template or OMF. Click Next…

Choose Fast Recovery Option. Re commanded to use default Size but you may use smaller size and can change the size later. Click Next…

If set less values then default then need to confirm. Click Yes..

As this is first database and using DBCA, so Click on Create a new listener option and provide the

Listener Name and Port. Click Next…

Click Next…

Choose the option -> ‘Use Automatic Memory Management’ and Click on ‘Character Sets’ Tab

Choose the ‘Character Sets‘ (if database for migrate from existing then this should be same) option. Click Next…

If you have OEM then better to install OEM agent later. Don’t select any option for Management Options and click Next.

Provide Database User’s (sys, system and pdbadmin) password and Click Next…

Select ‘Create Database‘ and Click Next…

Summary of all selected options. If selected options are OK then Click Finish. Otherwise Click Back and change the option.

Database Creation is progressing.

Database Created Successfully… Click Close.

Post Installation:

[oracle@ol71ora193 dbhome_1]$ . oraenv
ORACLE_SID = [oracle] ? mycdb19
The Oracle base has been set to /u01/app/oracle
[oracle@ol71ora193 dbhome_1]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 30 19:20:38 2020
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> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 MYPDB                          READ WRITE NO

Create a Non-container Database Using DBCA:

Set environment variable for ORACLE_HOME & Run dbca command.

Select “Create a Database” Option and Click on Next..

If you choose Creation Mode – “Typical configuration” (then you will get limited option to select) and Click on Next.

Note::: For Advanced Configuration – Check below.

Summary of Select and If you have happy then Click on Finish. It will start installation.

Select “Advanced configuration” and Click Next…

Select Data type and template. Click Next…

Provide the Global database name & SID. Unselect the check box if you want to create Non-Container Database. Click Next…

Select Storage Option and Checked if you want to user OMF. Click Next…

Provide FRA Path and Size. You may enable archive option by Selecting Enable Archiving. Click on Next…

If you have already listener for this Oracle Home, then make sure listener is up. You may create different Lister for this database. Click Next…

Click on Next…

Configuration Options – Memory -> Choose “Use AMM” and Select “Character sets”

Choose Character Sets for you database which is more appropriate based on your application requirement. Click Next..

Click Next…

Provide password for sys and system. Click Next…

You have an option to generate database creation scripts if want to create multiple database with same options. Click Next..

Selected parameters summary for Database Creation. Click Finish if don’t want to change anything.

Database creation is progressing. Click Next…

Database Created Successfully. Click Close.

Oracle 19c Installation Details: Oracle 19c Installation

Create Database using SQL Command:

Post Installation:

1 ping

  1. […] Please follow this article to install Oracle 19c software only: Oracle 19c s/w only installation […]

Leave a Reply