Vagrant + Oracle Linux 7 + Oracle Database 19c (19.3) | Simple setup of a single instance database.

Download Oracle Database 19c for Linux x86-64 software from Oracle Database Software Downloads. Then place downloaded file in the same directory as the Vagrantfile.

• LINUX.X64_193000_db_home.zip

Copy the file dotenv.sample to a file named .env and rewrite the contents as needed.

ORACLE_BASE=/u01/app/oracle ORACLE_CHARACTERSET=AL32UTF8 ORACLE_EDITION=EE ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 ORACLE_PASSWORD=oracle ORACLE_PDB=pdb1 ORACLE_SAMPLESCHEMA=TRUE ORACLE_SID=orcl

When you run vagrant up, the following will work internally.

• Download and boot Oracle Linux 7
• Install Oracle Preinstallation RPM
• Create directories
• Set environment variables
• Set password for oracle user
• Unzip downloaded Oracle Database software
• Install Oracle Database
• Create a listener
• Create a database

vagrant up

Connect to the guest OS.

vagrant ssh

Connect to CDB root and confirm the connection.

sudo su - oracle sqlplus system/oracle SHOW CON_NAME

Connect to PDB and confirm the connection. If you have sample schema installed, browse to the sample table.

sqlplus system/oracle@localhost/pdb1 SHOW CON_NAME -- If you have sample schema installed SELECT JSON_OBJECT(*) FROM hr.employees WHERE rownum <= 3;

Shinichi Akiyama

MIT License