Install Oracle Database 19c on linux

by SinaOnline Software Training

Hello everyone today I am going to install oracle 19c on Linux RedHat 8.6. also in this video, I will talk about x11 forwarding and its problem, and install oracle 19c on the new version of RedHat

How to install Oracle 19c On Linux , X11 Forwarding problem

This is my RedHat server, I am going to check the subscription status of this server with subscription-manager with list option. In my channel, you can find another video related to subscription-manager

Check Linux updates with the yum update command

I always use nano as a text editor, so trying to install it

Yes

Check the IP address of this server

We have to config hostname of this server to install oracle

Open the hosts file and edit IP and hostnames for this host,

Pres control x and then yes to save these changes

Going to the temp directory

We can prepare oracle prerequisites manually or by downloading one package and installing it everything will be prepared automatically to do this just paste this command to download the installer package and with yum you can install it, below you can find all commands that require during the installation

  • yum -y install nano
  • nano /etc/hosts
  • cd /tmp
  • curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
  • yum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
  • nano /etc/selinux/config
  • systemctl stop firewalld
  • systemctl disable firewalld
  • yum -y install xterm* xorg*
  • mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
  • mkdir -p /u02/oradata
  • chown -R oracle:oinstall /u01 /u02
  • chmod -R 775 /u01 /u02
  • reboot
  • xhost +
  • mkdir /home/oracle/scripts
  • nano /home/oracle/scripts/setEnv.sh
  • export TMP=/tmp
  • export TMPDIR=$TMP
  • export ORACLE_HOSTNAME=hpsa-oracle.sinaonline.net
  • export ORACLE_UNQNAME=soracle
  • export ORACLE_BASE=/u01/app/oracle
  • export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
  • export ORA_INVENTORY=/u01/app/oraInventory
  • export ORACLE_SID=soracle
  • export PDB_NAME=noracle
  • export DATA_DIR=/u02/oradata
  • export PATH=/usr/sbin:/usr/local/bin:$PATH
  • export PATH=$ORACLE_HOME/bin:$PATH
  • export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
  • export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
  • echo “. /home/oracle/scripts/setEnv.sh” >> /home/oracle/.bash_profile
  • chown -R oracle:oinstall /home/oracle/scripts
  • chmod u+x /home/oracle/scripts/*.sh
  • Login As Oracle
  • DISPLAY=10.10.10.38:0.0; export DISPLAY
  • cd /u01/app/oracle/product/19.0.0/dbhome_1
  • unzip -oq LINUX.X64_193000_db_home.zip
  • cd $ORACLE_HOME/cv/admin
  • edit cvu_config
  • CV_ASSUME_DISTID=RHEL7.9

In the prerequisites we have just set the password of the oracle user, as you know we can not install oracle DB as a root, all groups are created automatically with the previous script,

Now that is time to disable SELinux , to do that open config file

Change enforcing to disabled

Control x and y to save

Stop the firewall service and disable it

We install all the xterm and xorg packages to enable x11 forwarding and get the graphical interface throw ssh

Create DB home directory, as I told you can find upper commands

Create ora data directory

set oracle user and oinstall group owner to u01 and u02 directory

set oracle user and oinstall group permission to u01 and u02 directory

reboot server

as you can see after xterm and xorg packages installed , x11 forwarding enabled here

with xhost + you can connect to GUI throw the ssh from any host

create a script directory in the oracle user home directory

create a script and name it setenv.sh to import oracle required variables

paste these lines in it and save

whit this command make this script as user startup script, that means every time oracle user logging into the system this script automatically will be execute

also, give the permission to oracle user to run this script with these commands

now I am going to download oracle database installer file

this is the oracle database installer for the Linux , you can download it from here

click on download linux x64……

after you give the username and password, download will start, Creating an account on oracle website is free and its very easy

ok , oracle installer file downloaded, now login in as oracle user

when you are using x11 forwarding , if your client and server are on the same subnet do not require open any port in the firewall but when you are on a different subnet you have to open port 6000 in the firewall , you can see the direction of that port and ssh direction. that’s very important because if your port is not open you got an error during oracle installer

set the display variable with this command, 10.10.10.38 is my client ip address ,

check the oracle home variable

going to oracle home directory

upload downloaded file to this directory

unzip this file with o and q parameters

because I am trying to install oracle 19c on RedHat 8.6 I have to change cv_assume_disting to the latest supported version in the config file ,

to do this uncomment this line and instead of oel5 write rhel7.9 and save it, if you don’t do that you got an error during installation

Now we can run the installer

Come back to oracle home directory

Execute runinstaller

ok , you can continue this wizard based on your requirements

you can also follow my steps to install oracle database

you can ignore this warning,

this is a summary of the installation, after clicking on install, oracle database will be installed

ok , oracle database installed , if you run netstat you can see port 1521 , is oracle default port is on listening status and everything works fine,

I hope you enjoy this video , don’t forget to subscribe to my channel and watch other videos, if you have any questions you can ask them in the comments