topic Migrate from Postgresql to Oracle post installation of Alfresco Enterprise Edition in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293448#M246578 <HTML><HEAD></HEAD><BODY><SPAN>I have installed the Alfresco Enterprise Edition using the the Easy Setup Wizard which installed it with PostgreSQL. I would like to use Oracle as we have client requirement to use Oracle as DB. I have installed oracle server on the other machine, created the database, user for alfresco.</SPAN><BR /><BR /><SPAN>I need to change the Database configurations and should launch the Alfresco with new database Oracle. Please let me know the steps or any related documents , wikis, forums to follow the steps for configuarting Oracle DB post installation.</SPAN><BR /><BR /><SPAN>Much appreciated.</SPAN></BODY></HTML> Wed, 22 Jan 2014 09:13:16 GMT gbarala 2014-01-22T09:13:16Z Migrate from Postgresql to Oracle post installation of Alfresco Enterprise Edition https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293448#M246578 I have installed the Alfresco Enterprise Edition using the the Easy Setup Wizard which installed it with PostgreSQL. I would like to use Oracle as we have client requirement to use Oracle as DB. I have installed oracle server on the other machine, created the database, user for alfresco.I need to ch Wed, 22 Jan 2014 09:13:16 GMT https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293448#M246578 gbarala 2014-01-22T09:13:16Z Re: Migrate from Postgresql to Oracle post installation of Alfresco Enterprise Edition https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293449#M246579 <HTML><HEAD></HEAD><BODY><A href="http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/tasks/oracledb-config.html" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/tasks/oracledb-config.html</A><BR /><BR /><SPAN>Assuming that you are not actually doing a migration of data you should just be able to change the database property in alfresco-global.properties.&nbsp; Add the oracle driver. Drop any alfresco full text indexes.&nbsp;&nbsp; And restart.&nbsp;&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>You may also like to remove the stopping and starting of postgressql with alfresco which probably requires some code to be commented out of the startup script, but that can wait until later.</SPAN></BODY></HTML> Wed, 22 Jan 2014 11:08:41 GMT https://connect.hyland.com/t5/alfresco-archive/migrate-from-postgresql-to-oracle-post-installation-of-alfresco/m-p/293449#M246579 mrogers 2014-01-22T11:08:41Z