Liferay with Oracle XE

Well, that’s not a rocket science, but just a few simple tips for installing liferay 6 to work with oracle XE.

First you need to

Tune up your Oracle XE instanse:

use command-line:

type

sqlplus system

enter password

SQL> alter system set sessions=250 scope=spfile;
SQL> alter system set processes=200 scope=spfile;

SQL> shutdown immediate // or restart the database using any other ways you know: from the Oracle XE menu, from system services or whatever

This info is taken from here:

http://kishantha.blogspot.com/2009/03/increase-sessions-and-processes-of.html

Then create a user lportal with a passwork lportal and give this user DBA rights and all permissions.

Setup Oracle as your Liferay Database:

in ..\liferay-portal-6.0.5\tomcat-6.0.26\webapps\ROOT\WEB-INF\classes create file portal-ext.properties:

#
# Oracle
#
jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.url=jdbc:oracle:thin:@localhost:1521:xe
jdbc.default.username=lportal
jdbc.default.password=lportal

Find ojdbc14.jar in your Oracle XE folder and copy it to ..\liferay-portal-6.0.5\tomcat-6.0.26\webapps\ROOT\WEB-INF\lib

More detailed info here:
http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Database%20Configuration