Skip to content

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

License

Notifications You must be signed in to change notification settings

shakiyam/vagrant-oracle12.2

Repository files navigation

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

About

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

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published