Migrate from Postgresql to Oracle post installation of Alfresco Enterprise Edition

[gbarala]

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 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.

Much appreciated.

[mrogers]

http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/tasks/oracledb-config.html

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.  Add the oracle driver. Drop any alfresco full text indexes.   And restart.   

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.