|Win 7; Oracle - PHP connection / please Help [message #528761]
||Wed, 26 October 2011 23:15
Registered: October 2011
I am kinda novice in all 3 technologies (Oracle, PHP, Apache). Please help me.|
1. Want to do Oracle/ PHP programming. Display/transfer data from/to oracle to browser screens using PHP
2. This I want to do this only on one machine (my laptop) - not on networked machines.
My machine :
Win 7 64 bit Home Premium. Apache is running good. PHP5.3.8 running good.
Oracle 11g R2 installed. Able to connect to Sys, system, scott etc in windows console,
also through SQL developer. Could create my own tables and insert data.
But could not access oracle home page //localhost:1521/ so far.
on accesing //127.0.0.1/ - only phpinfo page displayed (no oracle homepage)
My questions -
Do I need to download 'Oracle Enterprise Manager' to do this? (becoz, I was trying //localhost:1521/em - but no success)
Do I have to configure 'userdir' in httpd.conf? I could not do this (most info on the web is for unix)
Do I need to download 'Oracle Instant Client' ?
Do I need php_oci8.dll? I don't have this file in my php\ext directory.
I checked in the console window and registry:
There is no 'dbconsole' service in the list of services. Is this ok? I have 4 oracle services - VSS, JobScheduler, MTSReco, home_1ClrAgent, OracleORCL; all started and running
oracle_home = C:\app\Administrator\product\11.2.0\dbhome_1 (it is there in registry)
oracle_unqname=orcl (it is there in registry)
LSNRCTL for 64-bit Windows: Version 188.8.131.52.0 - Production on 26-OCT-2011 22:29
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Version TNSLSNR for 64-bit Windows: Version 184.108.40.206.0 - Produ
Start Date 26-OCT-2011 16:07:20
Uptime 0 days 6 hr. 22 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File C:\app\Administrator\product\11.2.0\dbhome_1\network\a
Listener Log File c:\app\administrator\diag\tnslsnr\Ramana-PC\listener\a
Listening Endpoints Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
When I tried 'emtcl status dbconsole' I get the follwing:
OC4J Configuration issue. C:\app\Administrator\product\11.2.0\dbhome_1/oc4j/j2ee
/OC4J_DBConsole_220.127.116.11_orcl not found.
What I have to do to see the a PHP script connected to Oracle DB?
What I have to do to see home page //localhost:1521/em ?
Thanks in advance for your time.