The first time we install xampp for windows, by default, the only active database connection is MySQL. Therefore, if user wants to activate connection to oracle database, user needs to set it up first. How to activate/set up oracle database connection in xampp for windows? Here are some things i did to successfully activate oracle connection:
- To check whether your oracle setting has been activated or not, go to phpinfo, look for string oci8. If string found it indicate that connection to oracle is available, otherwise to activate connection do the following steps:
- Open all php.ini files in xampp folder (or you can open only the currently used php.ini file by looking at the phpinfo), then make the following necessary changes:
- Find string extension=php_oci8.dll. You’ll find there’s a semicolon ‘;‘ ahead of the string.
- Remove the semicolon to activate the oracle extension.
- Save the php.ini file.
- Install oracle client. Simply just install it on your computer, there is no settings required. You can download it from this oracle site.
- Activate or restart xampp.
- To make sure that connection to oracle database has successfully activated, go to phpinfo. Find string: oci8. If founded, then now xampp can communicate with oracle database.
Works for me 
Advertisement
Like this:
One blogger likes this post.
12 Comments
Thanks!
This post has been very useful: now I can work with Oracle ^__^
you’re welcome, thank you for leaving comment
Hi Frnd
im using xampp latest version oracle claint 9i, & oracle9i database in the remote server in a lan. I’ve made the settings as u told, but i couldn,t c oci details in phpinfo().
pls do the needful
Lots of of people talk about this issue but you wrote down some true words.
Simple words. I like your comment, thanks there
Thanks!
I have to delete oracle 8.05 client (from registry) and it works.
Bye!
Please help me configuring XAMPP because Im a new user of ORACLE,,,,can you send the full details i want to downlaod or to install
go to this site .html to find out the latest version of xampp development. The contents are from apachefriends who maintain the xampp development
it gives complete direction of how to install xampp and also provides the download links.
Then to configure the oracle,you may follow the steps in here.
Good luck
If I had a quarter for each time I came to solvetheproblems.wordpress.com.. Incredible post.
This didn’t work for me at first. Later I went back into php.ini, found the [OCI8] section, and uncommented the following lines:
oci8.max_persistent = -1
…
oci8.persistent_timeout = -1
…
oci8.ping_interval = 60
I have no idea if these really helped or if I just needed to shut down my machine and completely restart (this also happened), but OCI8 showed up in my phpinfo after these changes.
in my case, i just restart the xampp and then i can find the OCI8 string.
Perhaps you’re using other version of xampp and requires other setting
Thanks a lot for this, I wish everyone would note the solution to their everyday work problems onto a blog.