Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can php not use oracle client rather than oracle instant client + trouble enabling oci8

user5716448Apr 8 2017 — edited Apr 11 2017

Hi,

Have php installed and can run php.

Have oracle client installed and can use this with sqlplus and other third-part tools including 32-bit applications which use remote oracle datbases.

However, troubling enabling oci as doonot see it in phpinfo.

Have eidtefd php.ini checked have dll etc.

couple of questions

1)   what is difference between instant client and oracle client with regard php is oracle client not enough

2) is there a way to log errors/debug to see why cone ction between php and racle not ebing made.

php 7, oracle 11.2.0.3 iis on windows oracle on remote database

Thanks

Comments

Christopher Jones-Oracle

Re oracle client vs Instant Client: see the FAQ: Instant Client FAQ

Re debugging, there are various levels of debugging, such as adding this to PHP scripts:

error_reporting(E_ALL);  // In PHP 5.3 use E_ALL|E_STRICT ini_set('display_errors', 'On');

Start with this.  You probably don't need to do network tracing

user5716448

Thanks for reply.

When copy the oci.dll from the oracle client directory we see oci8 enabled but then get message

[10-Apr-2017 12:47:16 UTC] PHP Warning:  oci_connect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the directory with Oracle Instant Client libraries

we have the oracle client which is 32-bit and works with all other 32-bit applications on the pc which is running windows 8.1.

Why can't it see oracle client - php extnesions o.k as when comment out in others can see O.K?

> oci_connect(): OCIEnvNlsCreate() failed.

This error means that you are using an OCI8 DLL compiled for Oracle 12 but your PATH is picking up Oracle 11 libraries.

user5716448

Thanks for advice.

We have oracle 11.2.0.3 client installed and oracle 12 instant client which put in PATH as first entry so would have thought this would have picked it up.

In the meantime, installed php 5.4.45 like my colleague and can see oci8 as enabled it and poving as you mentioned can use php with standard oracle client.

Do you know if the latest version of php on the website requires a particular version of oracle 12 client client - had used the 32-bit one?

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 9 2017
Added on Apr 8 2017
#php
4 comments
2,713 views