Saltar al contenido

Setting Oracle XE instant client with XAMPP and Windows XP

  • por

I got question from my student :

“Is it possible to try PHP5 and Oracle ? I already have working Xampp in my computer .

I my self install Oracle XE on my computer and grant access for my student .

But I have problem when installing Oracle Client , Oracle XE client need 256 MB memory
Since other plugin takes it and make actual memory to 254 MB.

After reading “The Underground PHP and Oracle Manual ” I got proper solution for my student :

1. Download Oracle instant client for windows

2. Extract the file and put all extracted file into one folder , ex : C:\myoracle10

3. Setting PATH

Right Click on My Computer Icon and choose Properties

ora Setting Oracle XE instant client  with XAMPP  and Windows XP

Choose Environment Variables

ora2 Setting Oracle XE instant client  with  XAMPP and Windows XP

You can edit existing “PATH” variables by double clicking PATH line

ora3 Setting Oracle XE instant client  with  XAMPP and Windows XP

Add C:\myoracle10 plus ” ; ” sign

ora4 Setting Oracle XE instant client  with  XAMPP and Windows XP

Click OK to save

4. Tell PHP to load oracle extension

Open php.ini in apache/bin folder

ora5 Setting Oracle XE instant client  with  XAMPP and Windows XP
Uncomment line php_oci8.dll

ora6 Setting Oracle XE instant client  with  XAMPP and Windows XP

Restart XAMPP

Test the connection by running this file : (save as oracle.php)

$c = oci_connect(‘hr’, ‘palcomtech’, ‘//localhost/XE’);
$s = oci_parse($c, ’select city from locations’);
oci_execute($s);
while ($res = oci_fetch_array($s)) {
echo $res[‘CITY’] . ”
“;
}
oci_close($c);

Test it in localhost

You should see city names if no error found .

Congratulation

  • xampp oracle
  • oracle xampp
  • xampp oracle windows
  • xampp oracle xe
  • xampp with oracle
  • xampp oracle 10g
  • xamp oracle
  • xampp y oracle
  • xampp for oracle
  • xampp oracle instant client
  • instal oracle into xampp
  • xampp and oracle
  • oracle xe instant client
  • xampp php oracle
  • xampp oracle php
  • oracle xe xampp
  • xampp windows oracle
  • oracle php xampp
  • xampp con oracle
  • xampp client
  • oracle xe client
  • oracle on xampp
  • oracle 10g xampp
  • oracle xampp windows
  • oracle instant client xampp
  • xampp com oracle
  • oracle with xampp
  • setting xampp oracle
  • oracle for xampp
  • xammp oracle
  • xampp instantclient
  • php oracle xampp
  • xampp connect oracle
  • konfigurasi xampp dan oracle 10g express
  • xampp oracle client
  • php oracle on xampp
  • oracle express instant client
  • oracle xe
  • oraclexe instantclient
  • oracle and xampp
  • oracle no xampp
  • install oracle xampp
  • instant client
  • oracle xe client windows
  • installare oracle con xampp
  • how to use xampp with oracle
  • setting oracle client in windows
  • setting oracle client
  • xampp oracle 10
  • xampp oracle qindows

Fuente:  http://www.rasyid.net/2006/11/06/setting-oracle-xe-instant-client-with-xampp-and-w/

Si te ha interesado este artículo y deseas un apoyo o asesoría en algún requerimiento, envíame un mensaje a: (info@juliopari.com) o sino a través de Linkedin: https://www.linkedin.com/in/juliopari/

Etiquetas: