Oracle database requirements for Liferay DXP

[Ignacio Fernandez, modificado hace 6 años.]

Hi.

We are involved in a project where we are going to install Liferay DXP using Oracle 12c as database. Right now in a development environment to try it out. But we wondering if is necessary to create database with a specific setup, for example, character set defined as UTF-8. What is a good size for liferay user's tablespaces.

Does anyone have experience installing Liferay with Oracle?

Thanks in advance. Regards.
ifernan

[Jorge Díaz, modificado hace 6 años.]

If you are going to use Liferay DXP and have questions about configuring it with Oracle, you should open a ticket to Liferay Support.

Liferay DXP subscriptions includes access to LESA. You can open tickets there.

A last warning: Liferay 7 community don't work with non open-source databases (Oracle, DB2 and SQL Server are not supported)

[Ignacio Fernandez, modificado hace 6 años.]

Thanks Jorge for your answer.

We work for a government firm. At this moment, we are waiting for the Liferay licenses. That is a long process, you know. So, we want to go ahead an get development environments ready. That's the reason to ask for help here.

[Olaf Kock, modificado hace 6 años.]

Ignacio Fernandez:

But we wondering if is necessary to create database with a specific setup, for example, character set defined as UTF-8. What is a good size for liferay user's tablespaces.

UTF-8: Go with it.

Size of tablespace: "It depends" (TM). No, really: You know best how much data you're going to store there. How many users? Will you store binary data in the database? Do you use content extensively or just embed external applications? What features will you use? etc. - Even if you answer those questions now, the answer will most likely still be "it depends".

As you state that you're currently in a development environment: Build your dev- (and later your test-) environment, set it into relationship to your final production size and judge from there.