“UbuntuHelp:PHPOracle”的版本间的差异
来自Ubuntu中文
小 |
小 |
||
第2行: | 第2行: | ||
{{Languages|UbuntuHelp:PHPOracle}} | {{Languages|UbuntuHelp:PHPOracle}} | ||
To be able to access Oracle databases from PHP, you will need to have the Oracle OCI library installed in your machine. | 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: | There are two ways to get this library: | ||
− | + | # Install the Oracle Database [Oracle10g] [Oracle9i] | |
− | + | 2. Install Oracle Instant Client | |
− | + | ||
− | + | ||
If your Oracle database is in another machine, the Oracle Instant Client is a smaller install. | If your Oracle database is in another machine, the Oracle Instant Client is a smaller install. | ||
− | |||
=== PHP using Oracle Database Server === | === PHP using Oracle Database Server === | ||
− | |||
TODO | TODO | ||
− | |||
=== PHP using Oracle Instant Client === | === PHP using Oracle Instant Client === | ||
− | |||
Tested Environment: | Tested Environment: | ||
− | |||
Ubuntu Server 6.06 LTS | Ubuntu Server 6.06 LTS | ||
Oracle Instant Client 10.2.0.2 | Oracle Instant Client 10.2.0.2 | ||
− | |||
Prerequisites: | Prerequisites: | ||
− | |||
<pre><nowiki> | <pre><nowiki> | ||
sudo apt-get install build-essential | sudo apt-get install build-essential | ||
sudo apt-get install php5-dev php-pear | sudo apt-get install php5-dev php-pear | ||
</nowiki></pre> | </nowiki></pre> | ||
− | |||
Also download the Oracle Instant Client | Also download the Oracle Instant Client | ||
http://www.oracle.com/technology/tech/oci/instantclient/index.html | 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. | You will need the Basic (34MB) and SDK (600K). The Basic Lite version does not work. | ||
− | |||
<pre><nowiki> | <pre><nowiki> | ||
cd /usr/local/lib | cd /usr/local/lib | ||
第40行: | 第27行: | ||
sudo ln -s libclntsh.so.10.1 libclntsh.so | sudo ln -s libclntsh.so.10.1 libclntsh.so | ||
</nowiki></pre> | </nowiki></pre> | ||
− | |||
The symbolic link is needed by during the compilation step later. | The symbolic link is needed by during the compilation step later. | ||
− | |||
<pre><nowiki> | <pre><nowiki> | ||
sudo pecl install oci8 | sudo pecl install oci8 | ||
</nowiki></pre> | </nowiki></pre> | ||
− | |||
You will be prompted for the location of the library: | You will be prompted for the location of the library: | ||
− | |||
<pre><nowiki> | <pre><nowiki> | ||
instantclient,/usr/local/lib/oracle_10_2 | instantclient,/usr/local/lib/oracle_10_2 | ||
</nowiki></pre> | </nowiki></pre> | ||
− | |||
If successful, you may now add the following line at the bottom of php.ini | If successful, you may now add the following line at the bottom of php.ini | ||
− | |||
<pre><nowiki> | <pre><nowiki> | ||
extension = oci8.so | extension = oci8.so | ||
</nowiki></pre> | </nowiki></pre> | ||
− | |||
The php.ini is found in 2 places: /etc/php5/apache2/php.ini and /etc/php5/cli/php.ini | The php.ini is found in 2 places: /etc/php5/apache2/php.ini and /etc/php5/cli/php.ini | ||
− | |||
<pre><nowiki> | <pre><nowiki> | ||
sudo /etc/init.d/apache2 reload | sudo /etc/init.d/apache2 reload | ||
</nowiki></pre> | </nowiki></pre> | ||
− | |||
Check <?php echo phpinfo() ?> to verify if the OCI8 module is available. | Check <?php echo phpinfo() ?> to verify if the OCI8 module is available. | ||
− | |||
=== Further Reading === | === Further Reading === | ||
− | |||
* [http://www.orafaq.com/wiki/PHP Oracle PHP Wiki] | * [http://www.orafaq.com/wiki/PHP Oracle PHP Wiki] | ||
[[category:UbuntuHelp]] | [[category:UbuntuHelp]] |
2007年11月30日 (五) 21:01的版本
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]
2. 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.