topic Re: Oracle database configuration in Alfresco Archive

Oracle database configuration

lmartinez — Wed, 14 Mar 2007 14:42:37 GMT

Hello,I search the required parameters for an oracle database 9.2i, I want parametres for the init.ora file for use alfresco.Is this information available somewhere ?thank youOracle DBA

Re: Oracle database configuration

steve — Thu, 15 Mar 2007 15:20:38 GMT

Hello,

I am assuming that you want to run Alfresco using Oracle as the DB.

If so, you will need to configure the Oracle connection in these Alfresco files:


alfresco\tomcat\shared\classes\alfresco\extension\custom-db-connection.properties
alfresco\tomcat\shared\classes\alfresco\extension\custom-hibernate-dialect.properties
‍‍‍‍

The following file has examples of connection details for several DB's including Oracle:


alfresco\tomcat\shared\classes\alfresco\extension\custom-hibernate-dialect.properties.sample
‍‍‍

You will also need the Oracle jdbc drivers placed into the following location:


alfresco\tomcat\common\lib
‍‍‍

Obviously, you will need a user in Oracle with an associated tablespace and the correct permissions on that tablespace to match the details you enter in the above files.

Hope this helps,

Steve

Re: Oracle database configuration

lmartinez — Thu, 15 Mar 2007 15:29:26 GMT

Thanks you for theses informations, but it isn't what I need.

When you create an Oracle DB you must specifies some parameter in a file called initDBNAME.ora. In this files you can tune your database in function of the application will turn on this database.
And I want some recommendation for tune this file for alfresco 1.4.

Thanks you

Re: Oracle database configuration

steve — Thu, 15 Mar 2007 15:36:30 GMT

Hi,

Since we don't know how the users of Alfresco will be using Alfresco we don't have any recommended settings.

It will be best for you to profile your own usage of Alfresco and make the appropriate changes to tune Oracle in your environment.

Steve