Installing Moodle on Oracle 19c Database

Installing Moodle on Oracle 19c Database

by Vikash Kumar Mishra -
Number of replies: 9
Hi All,

I am performing installation of Moodle 4.3.3 on Oracle 19c. It's Linux environment (RHEL 7.9). I'm getting error while installing oci8.so extension php. It has dependency on php-devel package. ph-devel package has dependency on "libcom_err". 


Unfortunately, libcom_err package is already available with higher verion which can not be downgrade. Please help me on this. if there are another methods, please suggest.







Average of ratings: -
In reply to Vikash Kumar Mishra

Re: Installing Moodle on Oracle 19c Database

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Unless there is a VERY good reason - don't use Oracle with Moodle. It's technically supported, but nobody develops/tests on it and so on. I can promise you that you'll have a hard time.

AND... after Moodle version 4.5, support for Oracle is being removed altogether...

In reply to Howard Miller

Re: Installing Moodle on Oracle 19c Database

by Vikash Kumar Mishra -
Dear Howard Miller,

I am being forced to use Oracle. I also want to test it on Oracle. In this case, what can i do?
In reply to Vikash Kumar Mishra

Re: Installing Moodle on Oracle 19c Database

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
I expected you were going to say something like that.

You need to go back to whoever is forcing you and point out that Moodle support for Oracle is ending. It's therefore the wrong choice.

Moodle is optimised to work with MySQL and Postgres. One of those is the correct database.
In reply to Howard Miller

Re: Installing Moodle on Oracle 19c Database

by Vikash Kumar Mishra -
Dear Howard,

Thanks for your responses...

Moodle support is ending soon not ended. We are already using other applications on Oracle database. This is why we want to install Moodle on it. Let's talk in present. Although, Moodle earlier version 4.3.3 is supported on Oracle and we want to install it on Oracle.

If you are aware related to my issue, please give the solution or any alternative.
In reply to Vikash Kumar Mishra

Re: Installing Moodle on Oracle 19c Database

by Marcus Green -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Vikash, you are possibly asking in the wrong place. That looks like an issue relating to the PHP support for connecting to the Oracle database rather than connected with Moodle itself. If you can get the PHP to talk to the Oracle database you might get it to install. You would be better off asking where people commonly use PHP with the Oracle database which as the other replies have indicated is very few people on the Moodle.org forums.
Average of ratings: Useful (2)
In reply to Vikash Kumar Mishra

Ri: Installing Moodle on Oracle 19c Database

by Sergio Rabellino -
Picture of Particularly helpful Moodlers Picture of Plugin developers
Taking care of all the other useful responses to which I subscribe, you shouldn't mix remi packages with compiled ones.
First, install Oracle instantclient downloadable from Oracle web site (usually a zip/tar) and put an /etc/ld.so.conf.d/oracle.conf  writing into the path to the instantclient libraries directory.
Then you should be able to install php-oci8 package from remi directly.

HTH anyway.

Average of ratings: Useful (2)
In reply to Sergio Rabellino

Re: Ri: Installing Moodle on Oracle 19c Database

by Vikash Kumar Mishra -
Should i create the oracle.conf file in /etc/ld.so.conf.d directory as this conf file is not available? if yes, what should i give the variable name which will call to instantclient directory/path?
like - instantlient_path=/var/instantclient/instantclient_11_1 or what?
In reply to Vikash Kumar Mishra

Ri: Re: Ri: Installing Moodle on Oracle 19c Database

by Sergio Rabellino -
Picture of Particularly helpful Moodlers Picture of Plugin developers
Create if not exists and no, put only the directory path, nothing else.
After creating the file, you can do a reboot or simply call the "ldconfig" command to update the system's lib directory collection.
In reply to Sergio Rabellino

Re: Ri: Re: Ri: Installing Moodle on Oracle 19c Database

by Vikash Kumar Mishra -
The issue is not resolved yet......i think this is not an issue....please go through my first post then you will understand the issue. go through attached files also.

[root@test ~]# peardev install pecl/oci8
downloading oci8-3.3.0.tgz ...
Starting to download oci8-3.3.0.tgz (191,561 bytes)
.........................................done: 191,561 bytes
13 source files, building
running: phpize
Can't find PHP headers in /usr/include/php
The php-devel package is required for use of this command.
ERROR: `phpize' failed