Requirements
The following list shows the requirements for using the database extension v.2.0.
- eZ Publish version 4.1 or higher.
- Oracle Database server software version 9i, 10g or 11g.
- Oracle Database client software version 9 or higher (Oracle Instant Client is ok). The SQL*Plus command line tool is recommended.
- The PHP version that is required for your specific eZ Publish version, with Oracle support. It is strongly recommended to use a recent stable version of the OCI8 extension module for PHP (version 1.2.5 or 1.3.5 at the time of writing). Refer to the OCI8 changelogs for more information about latest versions of the extension.
- Proper Oracle environment variables setup (refer to the documentation of the PHP Oracle functions and the SQL*Plus tool for more information). Note that eZ Publish 4 requires a UTF-8 database, and thus the character set component of the NLS_LANG variable can only be set to UTF-8 ("AL32UTF8"). This variable must be set if you use Oracle Database server version prior to 9.2.
A user that has the following system privileges on the Oracle database server:
Privilege
Description
CREATE SESSION
Connect to the database.
CREATE TABLE
Create tables in own schema. Also allows the creation of indexes (including those for integrity constraints) on table in own schema.
CREATE TRIGGER
Create a trigger in own schema.
CREATE SEQUENCE
Create a sequence in own schema.
CREATE PROCEDURE
Create stored procedures, functions, and packages in own schema.
It is recommended that the user also has unlimited quota on the tablespace in which the user schema has been created. This is due to the fact that eZ Publish is a content management system, and therefore it needs to be able to store large amounts of data. The size of the site is usually proportional with the storage needs.
Svitlana Shatokhina (19/12/2006 3:51 pm)
Gaetano Giunta (19/05/2009 2:14 pm)
Comments
There are no comments.