Oracle database configuration

[lmartinez]

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 you

Oracle DBA

[steve]

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

[lmartinez]

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

[steve]

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