shakiyam/vagrant-oracle-database-21c

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

vagrant-oracle-database-21c

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

Download

Download Oracle Database 21c (21.3) software from Oracle Database Software Downloads. Then place downloaded file in the same directory as the Vagrantfile.

• LINUX.X64_213000_db_home.zip

Configuration

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/21.3.0/dbhome_1
ORACLE_PASSWORD=oracle
ORACLE_PDB=pdb1
ORACLE_SAMPLESCHEMA=TRUE
ORACLE_SID=orcl

Provision

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
• Install sample schemas

vagrant up

Example of use

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 schemas installed, browse to the sample table.

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

Author

Shinichi Akiyama

License

MIT License