INSTALASI PHP-OCI8 di RHEL5

1. Instal php-pear untuk
   mengcompile modul oci8

“yum install php-pear”

2. Download dan esktrak
   source code oci8.

cd
/usr/src

wget
-c http://pecl.php.net/get/oci8-1.2.5.tgz

tar
xvfz oci8-1.2.5.tgz

3. Buat file
   konfigurasi. Dengan pecl, dan compile oci8

pecl
build

cd
oci8-1.2.5

phpize

./configure --with-oci8=shared,instantclient,/opt/oracle/instantclient

make

make
instal

4. Kopikan modul kedalam
   folder modul php.

cp
/usr/src/oci8-1.2.5/modules/oci8.so /usr/lib/php/modules/oci8.so

5. Buat file konfigurasi
   untuk mengaktifkan modul oci8

nano
/etc/php.d/oci8.ini

isi dengan

;
Enable oci8 extension module

extension=oci8.so

6. Restart Apache, Cek
   dengan phpinfo(), modul sudah siap.

INSTALASI ORACLE INSTANTCLIENT LINUX

1. Download terlebih
   dahulu 3 buah file yaitu

• instantclient-basic-linux32-10.2.0.3-20061115.zip

• instantclient-sdk-linux32-10.2.0.3-20061115.zip

• instantclient-sqlplus-linux32-10.2.0.3-20061115.zip

2. Esktrak ke 3 file
   tersebut ke dalam folder /opt/oracle

unzip
-d /opt/oracle instantclient-basic-linux32-10.2.0.3-20061115.zip

unzip
-d /opt/oracle instantclient-sdk-linux32-10.2.0.3-20061115.zip

unzip
-d /opt/oracle instantclient-sqlplus-linux32-10.2.0.3-20061115.zip

3. Lakukan konfigurasi
   Client

cd
/opt/oracle/instantclient_10_2 (your version may be diff)

sudo
ln -s libclntsh.so.10.1 libclntsh.so

sudo
ln -s libclntsh.so.10.1 libclntsh.so && ln -s libocci.so.10.1
libocci.so

sudo
mkdir bin

cd
bin

sudo
ln -s ../sqlplus .

4. Konfigurasikan file
   /opt/oracle/instantclient_10_2/admin/tnsname.ora, isi dengan:

simpondb
=

(DESCRIPTION
=

(ADDRESS
= (PROTOCOL = tcp)(HOST = 192.168.88.1)(PORT = 1521))

(CONNECT_DATA
=

(SERVER
= DEDICATED)

(SERVICE_NAME = db1)

)

)

5. Setting Environment
   agar aplikasi dapat menggunakan Oracle client.

touch
/etc/profile.d/oracle.sh

chmod
+x /etc/profile.d/oracle.sh

isikan
dengan

export
ORACLE_HOME=/opt/oracle/instantclient_10_2

export
TNS_ADMIN=/opt/oracle/instantclient_10_2/admin

export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME

export
PATH=$PATH:$ORACLE_HOME/bin