[Building Sakai] Best wat for a Mac Guy to get Oracle Test Instance to Test LTI 2.1

[Matthew Buckett]

I've been using a vagrant setup which is very similar to the Oracle
vistualbox image except that it runs in 512MB of ram and only runs the
database server without all the management stuff. Instructions are in
my github account:

https://github.com/buckett/vagrant-ubuntu-oracle-xe/

Most of the work is other people's.

Once you've started up the VM, create DB for sakai, login to the VM:

vagrant ssh

then run sqlplus as the vagrant user:

sqlplus '/ as sysdba'

and run:

CREATE USER sakai IDENTIFIED BY sakai DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users;

CREATE ROLE connection;
GRANT CREATE session, CREATE table, CREATE view, CREATE procedure,
CREATE synonym, CREATE sequence, CREATE trigger TO connection;
GRANT connection TO sakai;

 drop the Oracle JDBC JAR into shared/lib, configure the connection in
sakai.properties and go.

-- 
  Matthew Buckett, VLE Developer, IT Services, University of Oxford