Requirements
The following list shows the requirements for using version 1.8 of the database extension.
- eZ Publish version 4.0.x (but not 4.0.0).
- Oracle Database server software version 9, 10 or 11.
- Oracle Database client software version 9 or higher with the SQL*Plus command line tool. (Note that the easy connect naming method is currently not supported by the database extension. Therefore, you will most likely need a "tnsnames.ora" file.)
- 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.4 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 (20/05/2009 1:46 pm)
Comments
There are no comments.