| Win 7; Oracle - PHP connection / please Help [message #528761] |
Wed, 26 October 2011 23:15  |
 |
david_bathu
Messages: 5
Registered: October 2011
Location: Trinidad
|
Junior Member |
|
|
I am kinda novice in all 3 technologies (Oracle, PHP, Apache). Please help me.
My objective:
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.
More info:
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 11.2.0.1.0 - Production on 26-OCT-2011 22:29
:44
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
ction
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
SNMP OFF
Listener Parameter File C:\app\Administrator\product\11.2.0\dbhome_1\network\a
dmin\listener.ora
Listener Log File c:\app\administrator\diag\tnslsnr\Ramana-PC\listener\a
lert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=190.213.227.135)(PORT=1521)))
Services 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_190.213.227.135_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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
