centos, oracle client, php

[root@jds oci8-1.4.7]#php -r "oci_connect();"

PHP Fatal error:  Call to undefined function oci_connect() in Command line code on line 1

이렇게 나오면, php 와 oci 연동이 안되있는거다.

* 오라클 클라이언트 다운로드

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

에 접속후

Instant Client Package - Basic

Instant Client Package - SDK

을 다운로드 받아서 설치한다.

[root@jds oci8-1.4.7]#rpm -ivh oracle-instantclient11.2-basic-11.2.0.3.0-1.i386.rpm

[root@jds oci8-1.4.7]#rpm -ivh oracle-instantclient11.2-devel-11.2.0.3.0-1.i386.rpm

[root@jds oci8-1.4.7]#rpm -qa | grep oracle 명령어로 설치된 내역 확인

설치완료후, 다운로드 받은 rpm 파일은 삭제

* oci8 설치

[root@jds oci8-1.4.7]#wget http://pecl.php.net/get/oci8-1.4.7.tgz

[root@jds oci8-1.4.7]#tar xvzf oci8-1.4.7.tg

[root@jds oci8-1.4.7]#cd oci8-1.4.7

[root@jds oci8-1.4.7]#phpize

[root@jds oci8-1.4.7]#./configure --with-oci8=shared,instantclient,/usr/lib/oracle/11.2/client/lib

[root@jds oci8-1.4.7]#ln -s /usr/include/oracle/11.2/client/ /usr/lib/oracle/11.2/client/lib/include

[root@jds oci8-1.4.7]#make all install

/usr/lib/php/modules/ 디렉토리에 oci8.so 가 생성됨

* PHP와 OCI 연동

[root@jds oci8-1.4.7]#echo 'extension=oci8.so' > /etc/php.d/oci8.ini

[root@jds oci8-1.4.7]#php -r "oci_connect();"

PHP Warning:  oci_connect() expects at least 2 parameters, 0 given in Command line code on line 1

이렇게 나오면 OK

이제 php 코딩하면 된다.