...
Open a terminal and log on to the database as a superuser (password: oracle):
Code Block sqlplus logon AS SYSDBA # NOTE: If you get at "invalid username/password; logon denied" error, try THIS COMMAND INSTEAD: sqlplus 'sys as sysdba'
Then create the database user and database (which is referred to as a "schema" in oracle terms): (Thanks to user-6062e for the SQL statements.)
Code Block language sql CREATE USER dspace IDENTIFIED BY dspace; GRANT CONNECT TO dspace; GRANT CREATE TABLE TO dspace; GRANT CREATE SEQUENCE TO dspace; GRANT CREATE VIEW TO dspace; GRANT CREATE PROCEDURE TO dspace; GRANT UNLIMITED TABLESPACE TO dspace;
...