Use oracle in alfresco

Tchogang01 — Mon, 01 Nov 2021 19:48:52 GMT

Hi to you I am using alfresco 6.0 and would like it linked to an oracle database and not to the postgres one that alfresco was linked to during installation.

Please which file to modify and how to modify it to get linked to my oracle database.

Re: Use oracle in alfresco

abhinavmishra14 — Mon, 01 Nov 2021 20:08:26 GMT

You need to update the following properties.

 db.name=alfresco
 db.username=alfresco
 db.password=apassword
 db.host=localhost
 db.port=1521
 db.pool.max=275
 db.driver=oracle.jdbc.OracleDriver
 db.url= jdbc:oracle:thin:@${db.host}:${db.port}:${db.name}

If you have done manual installation, then update the above propeties in alfresco-global.properties file.

Checkout this documentation as well:

https://docs.alfresco.com/content-services/latest/config/databases/#oracle

https://docs.alfresco.com/content-services/6.0/config/databases/#oracle

If you are using docker-compose.yml -> Update the java_ops params. See example that uses postgres here , you can update to use oracle:

-Ddb.name=alfresco
 -Ddb.username=alfresco
 -Ddb.password=apassword
 -Ddb.host=localhost
-Ddb.port=1521
 -Ddb.pool.max=275
-Ddb.driver=oracle.jdbc.OracleDriver
 -Ddb.url= jdbc:oracle:thin:@${db.host}:${db.port}:${db.name}

topic Use oracle in alfresco in Alfresco Forum

Use oracle in alfresco

Re: Use oracle in alfresco