Which OCI8 DLL to use in PHP 5.3

As I foreshadowed in a now distant post, Pierre has installed Oracle 11g Instant Client on the PHP Windows build box and updated the OCI8 build scripts for PHP 5.3 (and PHP 6).

PHP 5.3 now has two mutually exclusive versions of the OCI8 extension DLL:

php_oci8.dll


  • Built with Oracle 10gR2 client libraries. These libraries connect to Oracle Database 8.1 through to Oracle 11. (The DLL will also work with Oracle 11g libraries, but no DRCP connection pooling support is available)


  • enable in your php.ini with extension=php_oci8.dll


php_oci8_11g.dll


  • Uses Oracle 11g client libraries. These libraries connect to Oracle Database 9.2 through to Oracle 11.


  • Allows you to use Oracle 11g connection pooling


  • Enable in your php.ini with extension=php_oci8_11g.dll


The two DLLs have the same user script API that do the same thing. You only need to (and only can) enable one at any one time. Choose the one that matches your Oracle client libraries.

Php_oci8_11g.dll is obviously a "new thing". Since PHP 5.3 has already entered its Alpha stage, NOW IS THE TIME TO TEST OCI8.

In a related inflexion point change for PDO_OCI, the old php_pdo_oci8.dll (built with Oracle 8 libraries) has been dropped in PHP 5.2.7 and 5.3. Windows builds now only include php_pdo_oci.dll, which built with Oracle 10gR2 libraries. (Through the magic of Oracle library compatibility, this DLL will also work with Oracle 11g Instant Client).

Thanks to Pierre, Rob, and Elizabeth S for help the getting the builds updated, to John Mertic for updating the MSI installer, and to Steph for some early correspondence on the topic.

Comments:

To slightly gig Oracle, let's have a look at what an open source project would do in this situation. Consider ssh protocol 1. Many criticize it, and the commercial version cut all support for it, but the OpenBSD version continues to include and support it, and I use it. It's faster slow processors. I would like nothing more than to see the Oracle database source code seized by the government's eminent domain so we could put an end to this forced obsolescence. Theo de Raadt could also do wonders for the security. Especially since I've still got v7.3.4 mission critical servers.

Posted by Charles Fisher on December 05, 2008 at 01:32 AM PST #

The OCI8 extension is part of PHP and is an open source project.

Posted by Chris Jones on December 06, 2008 at 01:54 AM PST #

Post a Comment:
Comments are closed for this entry.
About

Tourists looking out over an Opal mine
I'm a Product Manager in Server Technologies, working on scripting languages and developer-access.
Email: christopher.jones@oracle.com
Twitter: http://twitter.com/ghrd
Book: Free PHP Oracle book
Download: PHP Linux RPMs with the OCI8 extension
Links: OTN PHP Developer Center

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today