Configuring Oracle OCI8 for windows 64 bit

php oracle oci8
Glory picture Glory · Jan 21, 2016 · Viewed 8.4k times · Source

I have been facing problems configuring oracle oci8 for windows

I'm using windows 7 64 bit, xampp v3.2.2, php 5.6.15 and oracle g11 express

I have tried the following steps but I can't find the oci package when running phpinfo:

  1. I downloaded both Instant Client Package - Basic and Instant Client Package - ODBC Version 12.1.0.2.0

  2. unzip the files into one file in c to be at the following path (C:\instantclient_11_2)

  3. add the path to environment variable (path) for oracle product (C:\instantclient_11_2;C:\oraclexe\app\oracle\product\11.2.0\server\bin;)

  4. restart my computer

  5. run the script (odbc_install)

    6- removed ; infront of the extension=php_oci8_11g.dll in php.ini

but It didn't work , can anyone tell me why?

Answer

Chintan Gor picture Chintan Gor · Mar 17, 2016

Oracle 11g + WAMP + Windows. This tutorial shows you how to use PHP with Oracle Database 11g. First of all let's assume that I am using Windows 7 64bit along with Oracle database 11G and WAMP server, so I have already downloaded Oracle instant client x64. If you are using 32bit Windows then download 32bit client otherwise it wont work. Steps :-

  1. Install Oracle database 11g XE

  2. Install WAMP

  3. Download appropriate Oracle instant client

  4. Extract all the content of Oracle instant client and copy all the .DLL files and paste into the directory like this D:\wamp\bin\apache\Apache2.2.17\bin

  5. Turn on the WAMP server and left click on the icon > PHP > PHP extension > check the php_oci8_11g only. If you are using Oracle database older then 11g like 10g then you must check on php_oci8 only.

  6. Turn on the Oracle database 11g XE services. Also the OracleServiceORCL should be there in services.

  7. Write a PHP code to connect Oracle with database 11g XE, and save the code in www directory of WAMP server. Below is the code:

Related questions

can not load oci8 -> Fatal error: Call to undefined function oci_connect()

I want to connect to my oracle database, but i have a problem with function oci_connect. i have tried to uncomment this: extension=php_oci8.dll but, still have an error : Fatal error: Call to undefined function oci_connect() …

Read More
PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_oci8_12c.dll' - The specified procedure could not be found

we face a big problem to connect oracle server in php What i done Setp 1: Install Windows 7 32bit Step 2 : install XAMPP 32 ( Includes: Apache 2.4.29, PHP 7.1.11, phpMyAdmin 4.7.4, OpenSSL 1.0.2, XAMPP Control Panel 3.2.2) Step : Instant Client Package - Basic: All files required to run …

Read More
How to sort by numbers first with Oracle SQL query?

I have this table with a 'title' field which is varchar2 and I want to select all rows and sort them first by number and then by the alphabet as it normally happens. For instance, I currently get this using …

Read More