Vagrant + Oracle Linux 7 + Oracle Database 12c Release 2 (12.2.0.1) | Simple setup of a single instance database.
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
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=orclWhen 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 upConnect to the guest OS.
vagrant sshConnect to CDB root and confirm the connection.
sudo su - oracle
sqlplus system/oracle
SHOW CON_NAMEConnect 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;