Oracle Database 19c, is the long term support release of the Oracle Database 12c and 18c. It offers Premier and Extended Support through to 31st March, 2023 and 31st March, 2026 respectively. It is available for all of the Operating system platforms: Linux, Windows, Solaris, HP/UX and AIX platforms. It is available for Oracle Cloud too.
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
sysctl -p /etc/sysctl.conf
Modify user limits. Add following lines to /etc/security/limits.d/oracle-limit.conf file.
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
Install all required Linux packages. Execute following yum command as user root to install all required packages and their dependencies.
yum -y install bc binutils dnf elfutils-libelf libnsl libXau \
Verify user with id oracle command
Stop Firewall and disable firewall at startup
Create Oracle Home directory and change ownership to user oracle and group oinstall.
Upload downloaded Oracle 19c software to Oracle Home directory. Once upload is completed extract oracle software.
Switch user to oracle and configure required environment variables for Oracle.
It is always better to validate the display setting before you execute the runInstaller command. Install xterm linux package and execute xterm command to verify display has been configured properly. If display has been set properly then you will be poped up with new xterm windows as below.
Select Desktop class and click on Next to continue.
Provide global dbname Password and Click on Next to continue.
Select Inventory location and click on Next to continue.
Select Automatically run configuration script. Provide root password and click on Next to continue.
All pre-requisite Check passed successfully so Installation window directly redirected to Summary window. I have clicked on Back button to view list of the pre-requisite and its status.
List of Pre-requisites that have been checked and its status as success. Click on Next to continue.
Once again summary page. Click on Install to begin installation.
Installation in progress..
Prompted to confirm execution or root.sh script with user root and password provided duration configuration windows earlier. Click on Yes to continue.
Noticed database Configuration has failed. I have checked installation log and noticed following error message.
INFO: [Apr 18, 2020 11:36:32 AM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Apr 18, 2020 11:36:32 AM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Apr 18, 2020 11:36:32 AM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Apr 18, 2020 11:36:32 AM] ... GenericInternalPlugIn: starting read loop.
INFO: [Apr 18, 2020 11:36:48 AM] [FATAL] [DBT-06103] The port (5,500) is already in use.
INFO: [Apr 18, 2020 11:36:48 AM] Skipping line: [FATAL] [DBT-06103] The port (5,500) is already in use.
INFO: [Apr 18, 2020 11:36:48 AM] ACTION: Specify a free port.
INFO: [Apr 18, 2020 11:36:48 AM] Skipping line: ACTION: Specify a free port.
INFO: [Apr 18, 2020 11:36:49 AM] Completed Plugin named: Oracle Database Configuration Assistant
INFO: [Apr 18, 2020 11:36:49 AM] Setup completed with overall status as Failed
Database configuration failed.
Checked /etc/hosts file and noticed I do not have fully qualified domain name in the hosts file. So added fully qualified domain name and clicked on Retry button in Installer window.
Click on Close to close Details window.
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
sysctl -p /etc/sysctl.conf
Kernel parameters added to /etc/sysctl.conf
Execute sysctl -p /etc/sysctl.conf to reflect kernel parameter change.
Modify user limits. Add following lines to /etc/security/limits.d/oracle-limit.conf file.
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
User limits modified in file oracle-limit.conf
Install all required Linux packages. Execute following yum command as user root to install all required packages and their dependencies.
yum -y install bc binutils dnf elfutils-libelf libnsl libXau \
elfutils-libelf-devel fontconfig-devel gcc glibc glibc-devel \
ksh libaio libaio-devel libgcc librdmacm-devel librdmacm-devel libstdc++ \
libstdc++ libstdc++-devel libX11 libxcb libXi libXrender libXrender-devel \
libXtst make net-tools nfs-utils python36 smartmontools sysstat targetcli
ksh libaio libaio-devel libgcc librdmacm-devel librdmacm-devel libstdc++ \
libstdc++ libstdc++-devel libX11 libxcb libXi libXrender libXrender-devel \
libXtst make net-tools nfs-utils python36 smartmontools sysstat targetcli
yum installation on going.
Once all required package is installed it looks something like above.
Add all required groups and users.
Add all required groups and users.
Change password for user oracle
Verify user with id oracle command
Modify selinux parameter. Set SELINUX to permissive and execute setenforce permissive
Stop Firewall and disable firewall at startup
Create Oracle Home directory and change ownership to user oracle and group oinstall.
Upload downloaded Oracle 19c software to Oracle Home directory. Once upload is completed extract oracle software.
Switch user to oracle and configure required environment variables for Oracle.
Create additional directory for SQLPATH. This directory can be used for centralized sql files path.
It is always better to validate the display setting before you execute the runInstaller command. Install xterm linux package and execute xterm command to verify display has been configured properly. If display has been set properly then you will be poped up with new xterm windows as below.
xterm windows that will be displayed if you have properly configured display settings.
Export environment variable CV_ASSUME_DISTID to 7.6. Otherwise there will be compatibility error installation will not begin at all.
export CV_ASSUME_DISTID=OEL7.6
Change directory to Oracle Home where Installer file has been extracted. Execute runInstaller to being installation.
Landing window after executing runInstaller command. Select Create and configure option. Click on Next to continue.
Select Desktop class and click on Next to continue.
Provide global dbname Password and Click on Next to continue.
Select Inventory location and click on Next to continue.
Select Automatically run configuration script. Provide root password and click on Next to continue.
All pre-requisite Check passed successfully so Installation window directly redirected to Summary window. I have clicked on Back button to view list of the pre-requisite and its status.
List of Pre-requisites that have been checked and its status as success. Click on Next to continue.
Once again summary page. Click on Install to begin installation.
Installation in progress..
Prompted to confirm execution or root.sh script with user root and password provided duration configuration windows earlier. Click on Yes to continue.
Noticed database Configuration has failed. I have checked installation log and noticed following error message.
INFO: [Apr 18, 2020 11:36:32 AM] ... GenericInternalPlugIn.handleProcess() entered.
INFO: [Apr 18, 2020 11:36:32 AM] ... GenericInternalPlugIn: getting configAssistantParmas.
INFO: [Apr 18, 2020 11:36:32 AM] ... GenericInternalPlugIn: checking secretArguments.
INFO: [Apr 18, 2020 11:36:32 AM] ... GenericInternalPlugIn: starting read loop.
INFO: [Apr 18, 2020 11:36:48 AM] [FATAL] [DBT-06103] The port (5,500) is already in use.
INFO: [Apr 18, 2020 11:36:48 AM] Skipping line: [FATAL] [DBT-06103] The port (5,500) is already in use.
INFO: [Apr 18, 2020 11:36:48 AM] ACTION: Specify a free port.
INFO: [Apr 18, 2020 11:36:48 AM] Skipping line: ACTION: Specify a free port.
INFO: [Apr 18, 2020 11:36:49 AM] Completed Plugin named: Oracle Database Configuration Assistant
INFO: [Apr 18, 2020 11:36:49 AM] Setup completed with overall status as Failed
Database configuration failed.
Checked /etc/hosts file and noticed I do not have fully qualified domain name in the hosts file. So added fully qualified domain name and clicked on Retry button in Installer window.
Noticed database configuration has started without issue. Click on Details button to view detail log of the installation.
Click on Close to close Details window.
Once installation completes Database configuration was successful message will be displayed. Click on Close to close installation window.
