PHP Connection to Oracle

1. Installing Oracle Client
   

   oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

   oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

   :http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
   

   RPM-IVH oracle-install*

   The build directory at this time:/usr/lib/oracle/11.2/client64/lib

   Add content to/etc/ld.so.conf:

   /usr/lib/oracle/11.2/client64/lib

   Execute command: Ldconfig

3. Installing OCI8

   : Http://pecl.php.net/package/oci8

   /usr/bin/phpize (Generate configure configuration file with Phpize)

   ./configure--with-php-config=/usr/bin/php-config--with-oci8=shared,instantclient,/usr/lib/oracle/11.2/client64 /lib

   Make && make install

   Note: Phpize installation: Yum install Php-devel

5. Connect Oracle

   
   

   <?php

   $conn = Oci_connect (' User, ' password ', ' Ip:port/sid ');

   
   

   $sql = "SELECT count (*) from Test";

   $sth = Oci_parse ($conn, $sql);

   Oci_execute ($sth, Oci_default);

   while ($r =oci_fetch_row ($sth))

   {

   echo $r [0];

   }

   
   

   ?>

7. Problem handling:

   Oracle 11G Special Issues:

   When you first connect, you are prompted

   Ora-24408:could not generate unique server group name

   Solve:

   More/etc/sysconfig/network

   View HOSTNAME

   Vi/etc/hosts

   127.0.0.1 HOSTNAME

PHP Connection to Oracle