Oracle Database 18c Express Edition Installation on Oracle Linux 7.6 using Vagrant
7In this video we are going to see how to install and configure Oracle Database 18c Express Edition on Oracle Linux 7.6 using Vagrant 2.2 which will be
configured as Virtual Machine running in VirtualBox 6.0.
Requirements: Oracle VirtualBox 6.0, Vagrant 2.2, Git and SQL Develeoper already installed and oracle-database-xe-18c-1.0-1.x86_64.rpm which
contains Oracle database 18c XE Software already downloaded from the Oracle Website.
Installation Method: Online, This requires internet connection to download the vagrant configuration files from github and Oracle Linux 7.6 OS
will be downloaded and installed as Virtual Machine using Vagrant.
So, The main goal of this Vagrant Provisioned Oracle Database Virtual Machine is to reduce the install and configuration time and increase
the productivity for development. At the end of this tutorial we can learn following things.
1. How to install and configure vagrant in Windows and add vagrant bin directory to environment variable.
2. Checkout the vagrant boxes configuration files and copy the oracle database 18c software oracle-database-xe-18c-1.0-1.x86_64.rpm to the directory.
3. Understand the vagrant configuration file and modify the memory to 4 GB.
4. Start the Vagrant Provisioning of Oracle Linux 7.6 VM and installation of Oracle database 18c Express Edition.
5. After Database 18c Creation, we try to login in SQL Plus with auto generated password and next change the SYS,SYSTEM and PDBADMIN passwords.
6. how to login into Oracle Enterprise Manager.
7. Create Common user called c##scott and assign some privileges to that user. Create table and insert records.
8. How to change the user vagrant's password and login to the Virtual Machine directly.
9. How to connect to Oracle Database 18c XE from SQL Developer 19.1 with Common user c##scott.
10. How to connect to Oracle Database 18c XE from SQL Developer 19.1 with Pluggable database user PDBADMIN.
Important Note: Ports 1521 and 5500 is forwared automatically to the host machine (Windows) so we can access the database direclty from Windows.
Do not change any configuration files unless you are an expert in vagrant and Oracle since this is automated install and configuration.
This video will be really useful for the Beginners and Developers who try to learn SQL and PL/SQL in 18c Database.
Use the command "git clone https://github.com/oracle/vagrant-boxes" to download the vagrant boxes.
Links:
Oracle vagrant Configuration files can be downloaded from https://github.com/oracle/vagrant-boxes
Oracle Database 18c Express Edition can be downloaded from https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index-083047.html
Vagrant can be downloaded from https://www.vagrantup.com/downloads.html
Other Videos By java frm
Other Statistics
The Vagrant Statistics For java frm
At present, java frm has 9,131 views spread across 4 videos for The Vagrant, with his channel uploading an hours worth of The Vagrant videos. This makes up less than 0.54% of the total overall content on java frm's YouTube channel.