Installing Oracle in WAMP environment

Installing Oracle in WAMP environment

Download Oracle Express Edition (Free download) from the link.

Download Oracle SQL Developer which is a free download too from the link below:

If you dont have any experience working with Oracle SQL Developer, you can read this article

Install wamp server 2.5

enable php_oci8.dll extension in php modules

You need to download “Instant Client Downloads for Microsoft Windows (32-bit)“. Download Version 11.2.0.4.0 Instant Client Package from the link above.

Place the files in any directory eg: C:\WampDeveloper\Tools\Oracle\instantclient_11_2

Then modify the System’s PATH environmental variable with the end location. This is important as otherwise its DLLs (OCI.dll) will not be found/loaded by PHP’s php_oci8_11g.dll: C:\WampDeveloper\Tools\Oracle\instantclient_11_2

Restart the wamp server.

Try this in any php code file for testing of oracle & php database connection.

You can use hostname “//localhost/xe” or “(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=xe)))” in the connection statement.

I had an inspiration from this article