Step By Step Tutorial - Install Oracle 19c and Create a Test Database on Oracle Linux VM (Part-1)

Link to my other series on Oracle VirtualBox VMs:

I assume you already have an account with Oracle to download software from Oracle's software delivery cloud. If you don't have an account with Oracle, then please create one. It's Free!!!

Steps followed (as root user) in the tutorial and the explanation:

1. need to configure the yum repository to download packages required for oracle software installation and creating the environment. Check the exiting repos:

2. Configure a public repository using wget command

Check the new repos created:

3. Install the package that checks and create our environment for oracle software installation which is called oracle-database-preinstall-19c so,

# yum install oracle-database-preinstall-19c -y

This will create our environment along with the users and groups required which is nothing but the oracle user and various dba groups.

4. Verification of the "oracle" user created with the command

Change the oracle users password to something that we can remember using "passwd" as root user:

# passwd oracle

5. Check the kernel parameter

check the security limits

#user limits for 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
oracle soft memlock 134217728
oracle hard memlock 134217728

Disable the firewall

systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld

6. Copy it to the installer zip file downloaded to the host from oracle's software delivery cloud to a local file system such as the "/tmp" file system in the VM as root user. In this example we mount the host file system to the VM as /vboxsf. If you want to know how to do that, please watch my series on VMs as stated before.

Change permission to 777:

Change ownership of the file system named /u001 to "oracle" user where we will keep our Oracle Home/Oracle Base etc:

chown -r oracle:oinstall /u001

7. As root in issue the command below to allow GUI access so users can access the GUI from other terminals

xhost +

9. Switch user to "oracle" and create directories for Oracle Base and Oracle Home etc and unzip the installer:

sudo su - oracle
cd /u001/
mkdir -p app/oracle/product/19.3/dbhome_1/

10. As oracle set the display variable so we can access the GUI
export display={IP Address of the pc from where you are doing ssh to the Linux VM}:0.0
cd /u001/app/oracle/product/19.3/dbhome_1/
./runinstaller

This will install Oracle 9c and create a test database as described in the video with steps.
Please let me know in case you face any issues in the steps.

[tezerademissie]

Thanks a lot, It is a great tutorial and if you can please upload the next video that uses best practices of database installation

[tomdoughty]

Manash - thank you for these videos they have been great so far! In which tutorial do you set up the storage for Oracle Ie u001/2/3 etc. the only one ive seen has set up u001 but not to a large enough capacity, Or do you have the details of what the drives should be so i can set them up? Currently I get a warning on the database install saying U001 doesn't have enough space

[sharmilas]

Hello, have created a test database in 19c .now need to install EE Components could you suggest how to do it

[shabana-tqli]

can you please let me know how other file systems were created like /u001

[shayansarkar]

Hello,
For OEL 9, what would be the public repo?

[prasadkawli]

Mine is stuck at launching oracle database 19c installer

[gopalkrishnachodisetti]

its fail in oracle database configuration AND
its fail in oracle database configuration assistant