特殊:Badtitle/NS100:PHPOracle

{{#ifexist: :PHPOracle/zh | | {{#ifexist: PHPOracle/zh | | {{#ifeq: {{#titleparts:PHPOracle|1|-1|}} | zh | | }} }} }} {{#ifeq: {{#titleparts:PHPOracle|1|-1|}} | zh | | }}

To be able to access Oracle databases from PHP, you will need to have the Oracle OCI library installed in your machine.

There are two ways to get this library:

• Install the Oracle Database [Oracle10g] [Oracle9i]
• Install Oracle Instant Client

If your Oracle database is in another machine, the Oracle Instant Client is a smaller install.

PHP using Oracle Database Server

TODO

PHP using Oracle Instant Client

Tested Environment:

Ubuntu Server 6.06 LTS Oracle Instant Client 10.2.0.2

Prerequisites:

sudo apt-get install build-essential
sudo apt-get install php5-dev php-pear

Also download the Oracle Instant Client http://www.oracle.com/technology/tech/oci/instantclient/index.html

You will need the Basic (34MB) and SDK (600K). The Basic Lite version does not work.

cd /usr/local/lib
sudo unzip <location-of-instant-client-basic>
sudo unzip <location-of-instant-client-sdk>
cd instantclient_10_2
sudo ln -s libclntsh.so.10.1 libclntsh.so

The symbolic link is needed by during the compilation step later.

sudo pecl install oci8

You will be prompted for the location of the library:

instantclient,/usr/local/lib/oracle_10_2

If successful, you may now add the following line at the bottom of php.ini

extension = oci8.so

The php.ini is found in 2 places: /etc/php5/apache2/php.ini and /etc/php5/cli/php.ini

sudo /etc/init.d/apache2 reload

Check <?php echo phpinfo() ?> to verify if the OCI8 module is available.

Further Reading

• Oracle PHP Wiki