Question Having Trouble with OCI8

[Cory16]

Server operating system version

Almalinux 9.4

Plesk version and microupdate number

18.0.63 #1

I'm following this thread (below) and still can't get OCI8 to work on my system:

Resolved - Debian / oci8 extension for PHP 7.4

Hi all, We have problem to install oci8 extension. 5 years ago we have informations from Igor (Resolved - Fedora 7 / Plesk Onyx : oci8 extension). We must install again oci8, but now: Plesk Obsedian 18.0.42 Debian 11 PHP FTM 7.4 We did this: Last instantclicent: -...

talk.plesk.com

My system is:
Insta-client downloaded was 23.5
PHP 8.3.10
Alma 9
Plesk Obsidian Web Host Edition Version 18.0.63 Update #1

The thread is a little old. Can anyone help me, that would be appreciated.

Trying to query a Oracle 19C database.

Thanks,

Cory

 

[Cory16]

I think it has to do with the Oracle Client (Insta Client) installation not being in the folder and not installed properly - I'm working on it. It would be nice to have a step by step on installing Oracle Client.

 

[Maarten]

Have you tried uploading and installing the PECL package using this article?

https://support.plesk.com/hc/en-us/articles/15233115709463-How-to-install-PECL-packages-in-Plesk

This is the location where you can download the oci8 package:

PECL :: Package :: oci8

pecl.php.net

 

[Cory16]

I did... It seems like OCI8 is installed... Oracle is installed and working (I can log in using SQLPLUS on all users (oracle, root, and the one php uses).

I say "seems" because the oci_connect command is there and it does recognize it as a command... my php_info does list OCI8 information now, the only thing is now the:

$conn = oci_connect($USER_NAME, $PASSWOOD, $DATABASE)

results in a null being set in $conn, no error, no nothing - I've tried using the TNSNAMES entry, I've tried with the full connection entry... and NOTHING.

 

[Cory16]

So... it was the ORACLE_HOME and LD_LIBRARY_PATH environmental variables not being set... I need to figure out how to set them once in Linux, but adding this to my php code at the beginning of every sheet that queries oci8 works:

putenv("LD_LIBRARY_PATH=/path/to/oracle/home/lib");
putenv("ORACLE_HOME=/path/to/oracle/home");

Now to set it once.