Use oracle in alfresco

cancel
Showing results for 
Search instead for 
Did you mean: 
Tchogang01
Member II

Use oracle in alfresco

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.

1 Reply
abhinavmishra14
Advanced

Re: Use oracle in alfresco

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}

 

~Abhinav
(ACSCE, AWS SAA, Azure Admin)