Solve PHP to Oracle connection problem
- Status: Pending
- Prize: $50
- Entries Received: 3
Contest Brief
QUICK JOB: PHP on Apache is showing an error connecting to Oracle DB. The same machine connecting to Oracle from the CLI (shell) is fine but inside Apache an error comes up when using oci_pconnect()
Sqlplus works fine, as does using php from the shell, so Oracle is listening. The paths below contain files also. Operating system is Centos and Oracle 11
The error is:
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/lib:/u01/app/oracle/product/11.2.0/db_1/rdbms/lib:/lib:/usr/lib
A PHP Error was encountered
Severity: Warning
Message: oci_pconnect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and LD_LIBRARY_PATH are set and point to the right directories
Filename: models/mhl_model.php
Line Number: 85
A PHP Error was encountered
Severity: Warning
Message: oci_pconnect(): Error while trying to retrieve text for error ORA-01804
Filename: models/mhl_model.php
Line Number: 85
Unable to connect to database -
Recommended Skills
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!