Bug #80846 [Com]: oci8 extension can't detect instance client under M1
| From: | ramongnr2009 at hotmail dot com | Date: | Mon, 26 Apr 2021 13:42:05 +0000 |
| Subject: | Bug #80846 [Com]: oci8 extension can't detect instance client under M1 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-233577@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=80846&edit=1
ID: 80846
Comment by: ramongnr2009 at hotmail dot com
Reported by: denirun at gmail dot com
Summary: oci8 extension can't detect instance client under M1
Status: Open
Type: Bug
Package: OCI8 related
Operating System: macOS BigSur 11.2.2, M1
PHP Version: 8.0.3
Block user comment: N
Private report: N
New Comment:
I tested on versions 8 and 7 (7.3, 7.4)
Previous Comments:
------------------------------------------------------------------------
[2021-04-26 13:09:36] ramongnr2009 at hotmail dot com
same problem here,
I've done this process too and it doesn't solve:
https://github.com/oracle/node-oracledb/issues/149#issuecomment-165678929
------------------------------------------------------------------------
[2021-03-08 10:01:21] denirun at gmail dot com
Description:
------------
Problem exists under Apple M1 chip only!
After setâup Oracle Instant Client under M1, and run sqlplus to check, does instant client
works â the sqlplus works without any problems. All connection, and some simple sqls works
perfectly.
Than after set up oci8 extension via pecl, and provide path to instant client â the script
don't find any errors, and installation finished with success.
After check how extension loaded, PHP stops with critical exception:
dyld: lazy symbol binding failed: Symbol not found: _OCIClientVersion
Test script:
---------------
cd ~/Downloads
curl -O https://download.oracle.com/otn_software/mac/instantclient/198000/instantclient-basic-macos.x64-19.8.0.0.0dbru.dmg
curl -O https://download.oracle.com/otn_software/mac/instantclient/198000/instantclient-sdk-macos.x64-19.8.0.0.0dbru.dmg
curl -O https://download.oracle.com/otn_software/mac/instantclient/198000/instantclient-sqlplus-macos.x64-19.8.0.0.0dbru.dmg
hdiutil mount instantclient-basic-macos.x64-19.8.0.0.0dbru.dmg
hdiutil mount instantclient-sdk-macos.x64-19.8.0.0.0dbru.dmg
hdiutil mount instantclient-sqlplus-macos.x64-19.8.0.0.0dbru.dmg
/Volumes/instantclient-basic-macos.x64-19.8.0.0.0dbru/install_ic.sh
hdiutil unmount /Volumes/instantclient-basic-macos.x64-19.8.0.0.0dbru
hdiutil unmount /Volumes/instantclient-sdk-macos.x64-19.8.0.0.0dbru
hdiutil unmount /Volumes/instantclient-sqlplus-macos.x64-19.8.0.0.0dbru
sudo mkdir -p /opt/oracle
sudo mv instantclient_19_8/ /opt/oracle
pecl install oci8
# Oracle Instant Client [autodetect] : instantclient,/opt/oracle/instantclient_19_8
php -i | grep oci8
Expected result:
----------------
oci8
oci8.connection_class => no value => no value
oci8.default_prefetch => 100 => 100
oci8.events => Off => Off
oci8.max_persistent => -1 => -1
oci8.old_oci_close_semantics => Off => Off
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20
Actual result:
--------------
oci8
OCI8 Support => enabled
OCI8 DTrace Support => disabled
OCI8 Version => 3.0.1
dyld: lazy symbol binding failed: Symbol not found: _OCIClientVersion
Referenced from: /opt/homebrew/lib/php/pecl/20200930/oci8.so
Expected in: flat namespace
dyld: Symbol not found: _OCIClientVersion
Referenced from: /opt/homebrew/lib/php/pecl/20200930/oci8.so
Expected in: flat namespace
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=80846&edit=1