Introduction
Now a day, many PHP applications have been developed keeping Oracle as database instead of MySQL and it’s a very common problem for those, using Oracle 11g in Windows 7 (64-bit) with PHP applications that the connection of Oracle database has been refused to connect. Here I have used Instant Client to connect Oracle database with my PHP application.
Instead of using separate installation of PHP and Apache, I have used here WAMP server. Just follow the step-by-step to connect Oracle database with PHP applications on the platform of Windows 7 (64-bit).
Step-by-Step
STEP 1. Install WAMP server and Oracle 11g at first.
STEP 2. For Windows 7 (64-bit), extract instantclient-basic-windows.x64-11.2.0.3.0.zip, downloaded from http://www.oracle.com/technetwork/topics/winx64soft-089540.html to C:\Windows\SysWOW64\instantclient_11_2 and set it on PATH variable for Environment variable.
STEP 3. Reboot the system now.
STEP 4. Allow PHP extension from php.ini as
extension=php_oci8_11g.dll (just remove the ";" from the start of the line)
STEP 5. Restart WAMP server.
STEP 6. Open the file to see the database name as
D:\app\Farhan\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.168.1.2)
)
)
Here, the service name is found as "orcl.168.1.2
" .
STEP 7. Make the connection in PHP script as
oci_connect(your_username, your_password, "localhost/orcl.168.1.2");
Conclusion
Now try it on your environment, wish you will be succeeded easily to connect with Oracle database from PHP applications on the platform of Windows 7 (64-bit).
I have received B.Sc. degree in Computer Science and Engineering from Khulna University of Engineering and Technology, (KUET) Bangladesh in 2003 and Master of Business Administration in Management from University of Dhaka, Bangladesh in 2009. I started my IT career as a Software Engineer at BDCOM Online Limited, then worked for BRAC BDMail Network Limited (bracNet). At present, I am working with Application Development, Integration and Maintenance department of the International Centre for Diarrhoeal Disease Research, Bangladesh (ICDDR,B) - an international health research organization located in Dhaka, Bangladesh, dedicated to saving lives through research and treatment.