As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
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.
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}
