10 Replies Latest reply on Apr 13, 2012 6:02 PM by Gogala Mladen

    PHP program works with Oracle db 11.2.0.1 but exits sideways with 11.2.0.2

    user12036311
      Hi

      Our PHP developer told me that his PHP program works with Oracle database 11.2.0.1 but exits sideways without errors with database 11.2.0.2.

      The PHP environment is:
      Suse release 11, current kernel revision is: 2.6.32.36-0.5-default #1 SMP 2011-04-14 10:12:31 +0200 x86_64 x86_64 x86_64 GNU/Linux,
      PHP 5.2.14 with Suhosin-Patch 0.9.7 (cli) (built: Mar 10 2011 17:37:25)
      Copyright (c) 1997-2009 The PHP Group
      Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
      with Suhosin v0.9.32.1, Copyright (c) 2007-2010, by SektionEins GmbH,
      Oracle full Client 11.2.0.2,
      OCI8 1.4.6 stable,
      Appache Server version: Apache/2.2.10 (Linux/SUSE)

      I contacted the Oracle Tech Support, they told me that because we are not using the mod_php provided by Oracle http server, they could not provide support from their side. They told me to follow the documentation "How to install and use PHP 5 with Oracle HTTP Server 11g" to use Oracle HTTP server instead of Apache Server for our PHP environment.

      I am wondering if anyone encouters the same problem and find a fix/workaround for it? Because the same PHP program works just fine with the 11.2.0.2 Oracle database, our testing database but not 11.2.0.1 Oracle database, our production database. I don't know it's the database upgrade (from 11.2.0.1 to 11.2.0.2) cuasing the problem or our PHP environment/setup won't work with a 11.2.0.2 database.

      I am wondering if anyone has any ideas on why it's happening and know a solution for it. Thank you.