Oracle and PHP5 in Debian-like systems
This post helped me install Oracle XE on my developer machine successfully! It worked for my Debian Lenny system previously, and I’ve personally verified it to work with MEPIS 8.0, Ubuntu 9.04 and Linux Mint 7, Linux Mint 8 and Xubuntu 10.04.
Oracle Express Edition (XE)
This step is optional if you already have an Oracle server to use, but in my experience, it’s far better to have one setup locally.
Add the following repository to your apt sources:
deb http://oss.oracle.com/debian unstable main non-free
Install Oracle XE:
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add - sudo apt-get update sudo apt-get install oracle-xe-universal
It’s a pretty big download (~260 MB). The installation, like most in Debian systems, is a breeze. When the installer completes there is one extra step:
sudo /etc/init.d/oracle-xe configure
You’ll be asked to create a system/sys (administrative user) password, and whether or not to start Oracle on boot.
Oracle Instant Client
You can skip this step if Step 1 was completed. Instant Client is required only if Oracle XE is unavailable.
Downloaded the RPMs from here. You’ll need the
devel packages for Linux. Once the download is complete, use
alien to convert the
.rpm into a
.deb package; e.g.,
sudo apt-get install alien # Converting and installing RPMs sudo alien oracle*.rpm sudo dpkg -i oracle*.deb
OCI8 Static Object
This step is required for Oracle/PHP to play nice.
sudo apt-get install php-pear php5-dev sudo pecl install oci8
At some point, you’ll be prompted to input ORACLE_HOME. If Oracle XE is installed, enter
Save a new file as
/etc/php5/conf.d/oci8.ini. Add the text
extension=oci8.so, so that it becomes available everywhere.
sudo /etc/init.d/apache2 restart