In this comprehensive guide, we walk you through the process of installing Oracle 19c on Linux 9.3. From downloading the software to creating your database, this step-by-step tutorial is perfect for beginners and experienced users alike. Check it out and let us know in the comments if you have any questions!
*****************************************************
Step By step Guide for Oracle 19c Software Installation Oracle Linux 9.3
*****************************************************
Step1: Check Current OS details:
************************
cat /etc/redhat-release
uname -a
Step2: Install oracle preinstallation package (Below command will help in oracle user creation and package installation)
******
From root user:
yum install -y oracle-database-preinstall-19c
Step3: crosscheck Kernel parameter >>>
*****
cat /etc/sysctl.conf
sysctl -p
Step4: Set Oracle password :
*****
passwd oracle
Step5: Create required directories for Oracle 19c software and datafiles and archivelog
*****
mkdir -p /u01/app/oracle/product/19c/db_1/
mkdir -p /u02/oracle/oradata
mkdir -p /u02/oracle/FRA
mkdir -p /backup/patch/
chown -R oracle:oinstall /u02
chown -R oracle:oinstall /u01/
chown -R oracle:oinstall /backup
chmod -R 775 /u01/
chmod -R 775 /u02/
chmod -R 775 /backup
Step6: From root user set limits for Oracle USER
*****
Add below entries in /etc/security/limits.conf file which will detine limits
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
Step7: Disable firewall on server from root user --- Not require for single instance
*****
systemctl stop firewalld
systemctl disable firewalld
Step8: From oracle user set user .bash_profile - default locations
*****
Set .bash_profile i.e. environment variables.
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19c/db_1
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export PATH=$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
Step9: Copy DB software and patches and unzip
*****
From root user:
df -h
cd /media/sf_19c_Soft_And_Patches
ls -lrth
ls -lrth LINUX.X64_193000_db_home.zip
cp LINUX.X64_193000_db_home.zip /u01/app/oracle/product/19c/db_1
cp p6880880_190000_Linux-x86-64.zip /u01/app/oracle/product/19c/db_1/
cp p35943157_190000_Linux-x86-64.zip /backup/patch/
cd /u01/app/oracle/product/19c/db_1
ls -lrth
chown oracle:oinstall LINUX.X64_193000_db_home.zip
chown oracle:oinstall p6880880_190000_Linux-x86-64.zip
ls -lrth
From Oracle user:
su - oracle
cd /u01/app/oracle/product/19c/db_1
unzip LINUX.X64_193000_db_home.zip
rm -rf OPatch/
unzip p6880880_190000_Linux-x86-64.zip
cd /backup/patch/
unzip p35943157_190000_Linux-x86-64.zip
Login to oracle user and set DISPLAY
export DISPLAY=<machine-name>:0.0;
Set profile and go to ORACLE_HOME location and run following command and follow the steps.
export CV_ASSUME_DISTID=OL8
cd $ORACLE_HOME
./runInstaller -applyRU /backup/patch/35943157
Step 10: Verification:
*****
sqlplus -v
cat /etc/oraInst.loc
cd /u01/app/oraInventory/ContentsXML
cat inventory.xml
Create database using dbca utility.
Done...!!!
Thanks for Reading.
For More details check our video on YouTube.
#OracleDBAOnlineTraining #oracledba #oracle #oracle19c #VirtualBox #DatabaseInstallation #SQL #PLSQL #DatabaseAdministration #DBA #OracleCommunity #DatabaseManagement #linux #RAC #tutorials
Comments