Oracle Database 19c Installation on Oracle Linux Vagrant box

Namaste!(after Corona I've started saying this in my blog posts as well!), Welcome to My Oracle Fusion Middleware Experiments fans!!

Oracle is dominant in the Relational Database Management tool. It is the strongest and core area among many Oracle products. it is flexible for on-premises development to the latest trending tech-ear  Cloud computing as well. I'm started exploring Oracle Analytics products recently and amazed by the tools and utilities which are built with greater vision. 

Pre-requisites

    To run in minimalistic operations for development purposes. 

1. Install git bash for Windows
2. Install Oracle VM VirtualBox
3. Install Vagrant

Some of Oracle community developers are doing R & D with minimalistic database creation and usage on Oracle VirtualBox and Vagrant. 

  git clone https://github.com/oracle/vagrant-projects.git

After you download or clone the github repository. As we are interested in Oracle Database 19c only so copied the vagrant-projects/OracleDatabase/19.3.0 folder to new folder as 'ora19c-lab'.

Oracle Database install configure on Vagrant

Inside the Vagrantfile updated private IPaddress under network and also increase the RAM size where memory value set to 2G default change to 4G if available on your host machine:

	config.vm.network "private_network", ip: "192.168.33.250"
  

This post is about the latest features included the most powerful Database 19c (current version is 19.3).

Assumptions

• Oracle Linux VM which can be created on VirtualBox with Vagrant or it can be available from Cloud
• Good speed of the Internet to work on Vagrant cloud or Oracle cloud

Download Options

• Oracle Database 19c available from OTN and also from Oracle Software Delivery Cloud (OSDC) or it is also called e-delivery choose Oracle Database 19c (19.3) for Linux x86-64 
• Hope you will get this file: LINUX.X64_193000_db_home.zip into the target machine.

Oracle Database 19c up & running

Install in silent mode is considered in the scripts/install.sh which covers the extraction and executing 'runinstaller' with the ORACLE_HOME and other parameters required to run with responseFile generated from the ora-response contained 'db_install.rsp.tmpl' file. 

Usually, when you run the installer in GUI mode execution, it's processing stops and shows a warning, that time you need to run the 'scripts' by 'root' user. whereas in this vagrant-boxes its execution made easy and very minimal. 

As the installer from Oracle is almost 3GB in size the shell provisioning is going to take up to 20-30minutes as per the system load and memory capacities.

You can observe the dbca responseFile transformed from the template to .rsp file and passed to dbca command.

To bring up the database in the Vagrant box you need to run `vagrant up`.

While extracting the Database bundle you could see that it includes a lot of utilities inside it.

Checking the Oracle CDB up 

 ps -ef|grep pmon
  sudo su - oracle
  
  # To know the Oracle Database installed version
  sqlplus -v
  

Let's begin the Database 19c story ...

Keep writing back your comments on your experience with this Oracle 19c YouTube video.