Liferay Oracle database configuration

[Based on http://tetyana.wordpress.com/2011/01/21/liferay-with-oracle-xe/]

Tune up your Oracle XE

 

Use command-line sqlplus

Go to oracle “bin” directory, e.g. C:\oraclexe\app\oracle\product\11.2.0\server\bin\, execute:

sqlplus system

and then enter password.

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

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

Then restart Oracle XE.

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

Setup Oracle as your Liferay Database

 

Configure Liferay to use Oracle XE

In ..\liferay-portal-6.0.5\tomcat-6.0.26\webapps\ROOT\WEB-INF\classes create file portal-ext.properties and enter the following configuration:

#

# Oracle

#

jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver

jdbc.default.url=jdbc:oracle:thin:@localhost:1521:xe

jdbc.default.username=<username>

jdbc.default.password=<password>

 

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

 

 

 

Problem with Oracle XE 11g

While creating DB scheme, Liferay is reporting the following error:

ORA-01723: zero-length columns are not allowed

 

Manually create Liferay database

TBD

Problems with Oracle XE 10g

After installation Liferay is reporting an error:

ORA-12519, TNS:no appropriate service handler found

There is the following solution:

  1. Exec SQL: ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
  2. Restart Oracle database
  3. Restart Liferay portal

More information

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