vagrant-oracle12.2

Vagrant + Oracle Linux 7 + Oracle Database 12c Release 2 (12.2.0.1) | Simple setup of a single instance database.

Download

Download Oracle Database 12c Release 2 (12.2.0.1) software from Oracle Software Delivery Cloud. Then place downloaded file in the same directory as the Vagrantfile.

• V839960-01.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/12.2.0.1/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

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

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

Author

Shinichi Akiyama

License

MIT License