Use oracle in alfresco

[Tchogang01]

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.

[abhinavmishra14]

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}