Installing Oracle Database 19c involves several steps, and the process can vary based on your operating system and specific requirements. Here’s a general outline of the steps you would follow for installing Oracle Database 19c:
- Prerequisites and Preparation:
- Review the Oracle Database 19c documentation and installation guides for your specific operating system.
- Ensure your system meets the hardware and software prerequisites, including memory, disk space, and compatible operating system versions.
- Download the Oracle Database 19c installation files from Oracle’s official website.
- Create a dedicated user (often named oracle) to perform the installation and manage the Oracle software.
Update hosts parameter to point the DNS and IP to your server
vi /etc/hosts
After, updating changes in the Hosts file, we will proceed further.
We have two options Manual Configuration and RPM based configuration. We are going to see RPM based installation first.
RPM based Configuration
yum install -y oracle-database-preinstall-19c
Now, after rpm installation, we need to set ORACLE user password.
passwd oracle
Note: In case of Active Directory server configuration, you need to disable the nsswitch.conf first by editing and removing sss
vi /etc/nsswitch.conf
After setting the password for the oracle user, we need to create the directory for ORACLE_HOME
mkdir -p /u01/app/oracle/product/19.3/db_home chown -R oracle:oinstall /u01 chmod -R 775 /u01
We need to change the user to Oracle user and set the bash profile.
su - oracle vi .bash_profile
Add below entries
# Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs ## Adding for Oracle Database 19c## export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/19.3/db_home export ORACLE_SID=ORCL export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib export NLS_LANG=american_america.al32utf8 export NLS_DATE_FORMAT="yyyy-mm-dd:hh24:mi:ss" PATH=$PATH:$HOME/.local/bin:$ORACLE_HOME/bin export PATH
Now execute the bash profile to take the effects.
. .bash_profile
Manual Configuration
Install required RPM mentioned below for OEL 7.9
yum install -y bc binutils compat-libcap1 compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libXrender-devel libX11 libXau libXi libXtst libgcc libstdc++ libstdc++-devel libxcb make policycoreutils policycoreutils-python smartmontools sysstat
For SUSE Linux 15 install below mentioned RPMs
bc binutils glibc glibc-devel insserv-compat libaio-devel libaio1 libX11-6 libXau6 libXext-devel libXext6 libXi-devel libXi6 libXrender-devel libXrender1 libXtst6 libcap-ng-utils libcap-ng0 libcap-progs libcap1 libcap2 libelf1 libgcc_s1 libjpeg8 libpcap1 libpcre1 libpcre16-0 libpng16-16 libstdc++6 libtiff5 libgfortran4 mksh make pixz rdma-core rdma-core-devel smartmontools sysstat xorg-x11-libs xz
On SUSE Linux Enterprise Server, to install the latest bc package using YaST, run the following command:
yast --install bc
Add the following lines to the “/etc/sysctl.conf” file, or in a file called “/etc/sysctl.d/98-oracle.conf”.
# oracle-database-preinstall-19c setting for fs.file-max is 6815744 fs.file-max = 6815744 # oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128' kernel.sem = 250 32000 100 128 # oracle-database-preinstall-19c setting for kernel.shmmni is 4096 kernel.shmmni = 4096 # oracle-database-preinstall-19c setting for kernel.shmall is 1073741824 on x86_64 kernel.shmall = 1073741824 # oracle-database-preinstall-19c setting for kernel.shmmax is 4398046511104 on x86_64 kernel.shmmax = 4398046511104 # oracle-database-preinstall-19c setting for kernel.panic_on_oops is 1 per Orabug 19212317 kernel.panic_on_oops = 1 # oracle-database-preinstall-19c setting for net.core.rmem_default is 262144 net.core.rmem_default = 262144 # oracle-database-preinstall-19c setting for net.core.rmem_max is 4194304 net.core.rmem_max = 4194304 # oracle-database-preinstall-19c setting for net.core.wmem_default is 262144 net.core.wmem_default = 262144 # oracle-database-preinstall-19c setting for net.core.wmem_max is 1048576 net.core.wmem_max = 1048576 # oracle-database-preinstall-19c setting for net.ipv4.conf.all.rp_filter is 2 net.ipv4.conf.all.rp_filter = 2 # oracle-database-preinstall-19c setting for net.ipv4.conf.default.rp_filter is 2 net.ipv4.conf.default.rp_filter = 2 # oracle-database-preinstall-19c setting for fs.aio-max-nr is 1048576 fs.aio-max-nr = 1048576 # oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500 net.ipv4.ip_local_port_range = 9000 65500
Run one of the following commands to change the current kernel parameters, depending on which file you edited.
/sbin/sysctl -p # Or /sbin/sysctl -p /etc/sysctl.d/98-oracle.conf
Add following parameter in this file /etc/security/limits.d/oracle-database-preinstall-19c.conf
# oracle-database-preinstall-19c setting for nofile soft limit is 1024 oracle soft nofile 1024 # oracle-database-preinstall-19c setting for nofile hard limit is 65536 oracle hard nofile 65536 # oracle-database-preinstall-19c setting for nproc soft limit is 16384 # refer orabug15971421 for more info. oracle soft nproc 16384 # oracle-database-preinstall-19c setting for nproc hard limit is 16384 oracle hard nproc 16384 # oracle-database-preinstall-19c setting for stack soft limit is 10240KB oracle soft stack 10240 # oracle-database-preinstall-19c setting for stack hard limit is 32768KB oracle hard stack 32768 # oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM oracle hard memlock 134217728 # oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM oracle soft memlock 134217728 # oracle-database-preinstall-19c setting for data soft limit is 'unlimited' oracle soft data unlimited # oracle-database-preinstall-19c setting for data hard limit is 'unlimited' oracle hard data unlimited
Create the Oracle groups and users.
groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper useradd -u 54321 -g oinstall -G dba,oper oracle
Set the password for the “oracle” user.
passwd oracle
Set secure Linux to permissive by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows.
SELINUX=permissive
To make the changes effective, run the below command
setenforce Permissive
Create the directories in which the Oracle software will be installed.
mkdir -p /u01/app/oracle/product/19.3/db_home chown -R oracle:oinstall /u01 chmod -R 775 /u01
We need to change the user to Oracle user and set the bash profile.su – oracle vi .bash_profile
# Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs ## Adding for Oracle Database 19c## export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/19.3/db_home export ORACLE_SID=ORCL export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib export NLS_LANG=american_america.al32utf8 export NLS_DATE_FORMAT="yyyy-mm-dd:hh24:mi:ss" PATH=$PATH:$HOME/.local/bin:$ORACLE_HOME/bin export PAT
. .bash_profile.
Database Installation
We will going to perfor Database Insatallation using silent method.
Download the Database software from edelivery website using wget or on windows machine and later transfer it to using winscp software.
Now unzip the software to the oracle home location.
unzip oracledb19 -d /u01/app/oracle/product/19.3/db_home
Navigate to the ORACLE_HOME and execute runInstaller in silent mode.
./runInstaller -ignorePrereq -waitforcompletion -silent \ -responseFile ${ORACLE_HOME}/install/response/db_install.rsp \ oracle.install.option=INSTALL_DB_SWONLY \ ORACLE_HOSTNAME=${ORACLE_HOSTNAME} \ UNIX_GROUP_NAME=oinstall \ INVENTORY_LOCATION=${ORA_INVENTORY} \ SELECTED_LANGUAGES=en,en_GB \ ORACLE_HOME=${ORACLE_HOME} \ ORACLE_BASE=${ORACLE_BASE} \ oracle.install.db.InstallEdition=EE \ oracle.install.db.OSDBA_GROUP=dba \ oracle.install.db.OSBACKUPDBA_GROUP=dba \ oracle.install.db.OSDGDBA_GROUP=dba \ oracle.install.db.OSKMDBA_GROUP=dba \ oracle.install.db.OSRACDBA_GROUP=dba \ SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \ DECLINE_SECURITY_UPDATES=true
Run the required script, as root user
Now, navigate to the ORACLE_HOME/bin and run DBCA to create the database.
cd $ORACLE_HOME/bin ./dbca
Enjoy..!