Archive for category Oracle

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:


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:

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

# Oracle

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:

Leave a comment