Liferay CE 7.4.3.132ga132 Oracle DB Support

[haadi_bey1]

Hi LinkedIn Community,

I am upgrading my Liferay portal from Liferay CE 7.3.6-ga63 to Liferay CE 7.4.3.132-ga132. The current live Database being used for the Liferay 7.3.6-ga63 is Oracle 19c, but while upgrading the server, at the point where we the db_upgrade_client, it gives an error that the Oracle DB is not supported.

Is Oracle DB not supported in the community edition? Because I know it is supported in the DXP version, but is it not in the community edition?
If it is NOT supported, then please tell me some other solution for this situation as well. Because, right now, I am trying to convert it to the PostgreSQL which is also causing a huge amount of errors.

Regards,

[arun]

Yes, Liferay CE doesn’t support commercial databases such as SQL Server or Oracle. But, the latest version of Liferay DXP Free Tier does support.

You can refer to GitHub - amusarra/liferay-portal-database-all-in-one-support: This is the driver implementation to add support for Oracle, SQL Server and DB2 database for Liferay 7, 7.1, 7.2, 7.3 and 7.4 CE · GitHub for Oracle support (I wouldn’t suggest to use it as it is pretty outdated and not maintained, but gives you a general idea)

If you move in to DXP Free Tier, there is a tool (in beta) liferay-portal/modules/util/portal-tools-db-migration-importer at master · liferay/liferay-portal · GitHub that helps you migrate from Oracle to Postgres as well.

[haadi_bey1]

Hey There!

Thank you for that solution, but I tried something else. I converted the DB from Oracle to PostgreSQL and then performed the upgrade.

But I am encountering another issue. After upgrading the Liferay Portal from 7.3 to 7.4.3.132-ga132, when I try to access the admin panel through the ‘host:port/c/portal/login’, the URL changes, but the page does not. I have tried many URLs but it is not working. I want to access the admin panel, what should I do?