Combination View Flat View Tree View
Threads [ Previous | Next ]
Hervé Ménage
Migration from LEP 5.1 to 5.2.1 - Oracle 10g Express
February 9, 2009 12:55 AM
Answer

Hervé Ménage

Rank: Junior Member

Posts: 50

Join Date: March 1, 2007

Recent Posts

Hello,
I finally managed to migrate from Liferay 5.1.2 to Liferay 5.2.1.
My existing site was containing some stuff I did not want to lose when upgrading to 5.2.1, and I am not interested in the default data loaded by Liferay 5.2.1.
Environment:
- Oracle 10g Express
- Liferay-tomcat-5.5-5.2.1
Preparation:
- Backup your database
- Unzip the liferay tomcat bundle : I used a new directory to not override the existing version,but I will have to redeploy all my themes, portlets, and customizations.
DB configuration (if you do not use your application server's JNDI datasource):
- Create the portal-ext.properties file
- Add the following lines:
1jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
2jdbc.default.url=jdbc:oracle:thin:@localhost:1521:xe
3jdbc.default.username=your_user
4jdbc.default.password=your_password

- Add the following properties:
1schema.run.enabled=false
2schema.run.minimal=true

- Copy the Oracle driver JAR file to <tomcat_install_dir>/common/lib/ext
- Delete the "sevencogs" theme and hook from the tomcat's "webapps" folder
- Edit the "webapps/wol-portlet/WEB-INF/jdbc.properties"
- Configure the DB :
1jira.driverClassName=oracle.jdbc.driver.OracleDriver
2jira.url=jdbc:oracle:thin:@localhost:1521:xe
3jira.username=your_user
4jira.password=your_password

- Delete the "data/hsql" directory if exists (if it is created again, then something is wrong in the configuration)
Now start Liferay: in the logs, the Dialect detector should find Oracle. The auto-upgrade process will upgrade your database. When the WOL portlet is initialized, Oracle should be detected as well.
Finally I deployed all my custom assets (themes, portlets, ...)
Hope this helps, and comments are welcome ;-)
Regards
Hervé