The documentation of Liferay 6.x is not detailed enough and does not contain those preliminary settings which need to be checked by DBAs in order to deploy Liferay properly.
Having the NLS_LENGTH_SEMANTICS set to CHAR or creating the database with a block size less than 8K prevents Liferay to create some indices.
- When NLS_LENGTH_SEMANTICS=CHAR
- When DB_BLOCK_SIZE=4K
Customers tend to ask about the recommended settings in terms of Oracle and it's a frequently recurring question as well. Of course we cannot foretell all the parameters which would make a certain installation to operate optimally, but at least those factors should be documented that hamper Liferay's deployment.
Affected customer's so far