PHP fails but SQLPLUS works..ORA-01858
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: PHP fails but SQLPLUS works..ORA-01858

  1. #1
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152

    PHP fails but SQLPLUS works..ORA-01858

    I installed Oracle to linux Red Hat and PHP compiled. When the developer connects he gets this error which looks like 2 problems:

    Warning: OCIFetchInto: Error while trying to retrieve text for error ORA-01858 in /var/www/html/examples/oci.php on line 20

    Not sure whats missing..

  2. #2
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    We believe we traced it down to file permissions. When starting apache as the Oracle userid the problem disappeared.

    After examining /var/oracle we saw that it lacked group privelages. chmod 755 on that dir seemed to allow access to apache for OCI calls via PHP language.

    Odd how native Oracle ( sqlplus ) connectivity worked the whole time.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Was there anything in the apache logs ...because even sqlplus is just a OCI application..

    regards
    Hrishy

  4. #4
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    I did not know that. I thought sqlplus was native. Well the apache user would fork a process for PHP so I asked the developer who noticed the errors going to the apache logs, to attempt to browse oracle_home/bin and he could not.

    So we started apache as Oracle user and everything worked.

    That led to the discovery of the high level Oracle dir lacking group rights which was left over from the netadmins failed oracle installa nd I did not detect it when I did my install.

    PHP allows for oracalls and ocicalls. The oracalls ( native ) were working. The OCI calls were not. sqlplus was incorrect to add to this because I was after all logged in as 'oracle' for that.

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width