vagrant-oracle11.2

Vagrant + Oracle Linux 7 + Oracle Database 11g Release 2 (11.2.0.4) | Simple setup of a single instance database.

Download

Download Oracle Database 11g Release 2 (11.2.0.4) software from My Oracle Support. Then place downloaded files in the same directory as the Vagrantfile.

p13390677_112040_Linux-x86-64_1of7.zip
p13390677_112040_Linux-x86-64_2of7.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/11.2.0.4/dbhome_1
ORACLE_PASSWORD=oracle
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 and unzip
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

Example of use

Connect to the guest OS.

vagrant ssh

Connect to the database and browse to the sample table.

sudo su - oracle
sqlplus system/oracle
SELECT * FROM scott.emp;
-- If you have sample schemas installed
SELECT * FROM hr.employees WHERE rownum <= 10;

Author

Shinichi Akiyama

License

MIT License