Archive for category Oracle
Liferay with Oracle XE
Posted by tetyana in liferay, Oracle, Persistence on January 21, 2011
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