Requirements

The following list shows the requirements for using the database extension v.5.0.

1. Exponential version 5.0
2. Oracle Database server software version 9i, 10g or 11g.
3. Oracle Database client software version 9 or higher (Oracle Instant Client is ok). The SQL*Plus command line tool is recommended.
4. The PHP version that is required for your specific Exponential 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 the latest versions of the extension.
5. Proper Oracle environment variables setup (refer to the documentation of the PHP Oracle functions and the SQL*Plus tool for more information). Note that Exponential 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.

6. 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 Exponential 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.