Configuration

1. Create a new schema alfresco and tablespace alfresco in your database

Example:

 CREATE TABLESPACE alfresco DATAFILE 'ALFRESCO-TS.DAT' SIZE 512M REUSE AUTOEXTEND ON NEXT 256M;
 CREATE USER alfresco DEFAULT TABLESPACE alfresco TEMPORARY TABLESPACE temp IDENTIFIED BY strongpassword;
 ALTER USER alfresco QUOTA unlimited ON alfresco;
 GRANT connect TO alfresco;
 GRANT resource TO alfresco;

2. Ensure that the alfresco user has the required privileges to create and modify tables. This can be removed once the server has started, but may be required during upgrades.

3. Override following properties in your alfresco-global.properties:

 db.driver=oracle.jdbc.OracleDriver
 db.name=alfresco
 db.url=jdbc:oracle:thin:@server.domain:1521:DBTNSNAME
 db.username=alfresco
 db.password=strongpassword
 db.pool.validate.query=SELECT 1 FROM DUAL

If you get ORA errors then set hibernate.show_sql=true for debugging.

4. If you have multiple Alfresco instances installed on an Oracle server, you will need to force the database metadata queries to target the schema that each database user is using. Put the following in alfresco-global.properties:

 hibernate.default_schema=ALFRESCO

5. Copy the Oracle JDBC driver JAR into \tomcat\lib (on Tomcat 6) or \jboss\server\default\lib (JBoss). Example:

 cp oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar \tomcat\lib

6. You can now startup the Tomcat or Jboss server

Notes

• If you get JDBC errors ensure the location for the Oracle JDBC drivers are on the system path, or add them to the relevant lib directory of the app server.
• For performance reasons it is recommended that you use the 10g JDBC drivers, even if your Oracle server is 9i.