Setting Up Oracle¶
Caution
Oracle is not used in production by the RelStorage maintainers and tends to lag behind in feature development; it also does not fully support parallel commit. If possible, choose PostgreSQL. Oracle support may be deprecated and eventually removed.
Initial setup will require SYS
privileges. Using Oracle 10g XE, you
can start a SYS
session with the following shell commands:
$ su - oracle
$ sqlplus / as sysdba
You need to create a database user and grant execute privileges on the DBMS_LOCK package to that user. Here are some sample SQL statements for creating the database user and granting the required permissions:
CREATE USER zodb IDENTIFIED BY mypassword;
GRANT CONNECT, RESOURCE, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW TO zodb;
GRANT EXECUTE ON DBMS_LOCK TO zodb;