# /home/POS/php/phpku /home/POS/php/testora.php
PHP Warning: Module ‘oci8’ already loaded in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library ‘pdo_oci.so’ (tried: /usr/lib64/php/modules/pdo_oci.so (libclntsh.so.19.1: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/pdo_oci.so.so (/usr/lib6 4/php/modules/pdo_oci.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

a. remark
# nano /etc/php.ini
;extension=oci8.so

b. move
# mv /etc/php.d/30-pdo_oci.ini /root/30-pdo_oci.ini

c. recompile
# cd /temp/oci8-2.2.0
# phpize
Configuring for:
PHP Api Version: 20190902
Zend Module Api No: 20190902
Zend Extension Api No: 320190902

# ./configure -with-oci8=shared,/u01/app/oracle/product/11.2.0/db_1/
# make
# make install
Installing shared extensions: /usr/lib64/php/modules/

d. restart httpd
# systemctl restart httpd
# systemctl status httpd
● httpd.service – The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2022-03-24 19:21:44 WITA; 9s ago
Docs: man:httpd(8)
man:apachectl(8)
Process: 9517 ExecStop=/bin/kill -WINCH ${MAINPID} (code=exited, status=0/SUCCESS)
Main PID: 9528 (httpd)
Status: “Total requests: 0; Current requests/sec: 0; Current traffic: 0 B/sec”
Tasks: 6
CGroup: /system.slice/httpd.service
├─9528 /usr/sbin/httpd -DFOREGROUND
├─9529 /usr/sbin/httpd -DFOREGROUND
├─9530 /usr/sbin/httpd -DFOREGROUND
├─9531 /usr/sbin/httpd -DFOREGROUND
├─9532 /usr/sbin/httpd -DFOREGROUND
└─9534 /usr/sbin/httpd -DFOREGROUND

Mar 24 19:21:44 host01.localdomain systemd[1]: Starting The Apache HTTP Server…
Mar 24 19:21:44 host01.localdomain systemd[1]: Started The Apache HTTP Server.

e. running app php
# /home/POS/php/phpku /home/POS/php/testora.php
Connected to Oracle!

f. my script
# cat phpku
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=host01.localdomain; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=host01; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
php $1

# cat testora.php
<!–?php
$conn = oci_connect(“scott”,”TIGER”,”HOST01″);
if (!$conn) {
echo “oci8 working! However the following errors occurred:
“;
$m = oci_error();
echo $m[‘message’], “\n”;
exit;
} else {
print “Connected to Oracle!”;
}
oci_close($conn);
?>

Leave a comment

Trending