11-01-2021 12:48 PM
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.
11-01-2021 01:08 PM
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}
Explore our Alfresco products with the links below. Use labels to filter content by product module.