Oracle Dev Box

A generic, empty Oracle XE instance for development purposes.

Install

1. Download oracle-xe-11.2.0-1.0.x86_64.rpm and place the zip file in puppet/modules/oracle/files/.
2. vagrant up

This boots up an Oracle XE instance running on port 1521. Usernames are sys and system; password is manager.

Scripts

There are a few convenience scripts for managing schemas:

• script/schema/create [schema name]: creates a user/schema. A password will be generated and printed to the console.
• script/schema/drop [schema name]: drops a schema.
• script/schema/list: lists all schemas.

Most of this was blatantly stolen from rails-dev-box-runs-oracle.