ID: 26424 Updated by: [EMAIL PROTECTED] Reported By: vinz_ at libero dot it -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: solaris 8 PHP Version: 4.3.2 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip Previous Comments: ------------------------------------------------------------------------ [2003-11-27 04:50:22] vinz_ at libero dot it I verify and It's ok. I would want to evidence that the problem is random. The web server work correctly for days or weeks. The db Oracle work correctly always. It's necessary stop/start iPlanet to reconnect again. If I use OCINLogon()? THX for help. Bye ------------------------------------------------------------------------ [2003-11-26 17:22:39] [EMAIL PROTECTED] Can you please verify that you really set and exported the Oracle environment variables mentioned in http://www.php.net/manual/en/ref.oci8.php in the environment of your web server user (before you start your web server).? "Error while trying to retrieve text" usually means that the Oracle libraries don't even know about ORACLE_HOME. ------------------------------------------------------------------------ [2003-11-26 08:58:24] vinz_ at libero dot it Description: ------------ Hi Hall, I have this problem. Some times (random) the web server does not succeed to connect itself to an other server Oracle. The web server answers in way corrected on door 80. - Web Server: Netscape iPlanet 4.1 SP7; - PHP 4.3.2; - Oracle 8.1.7. Thank you for Help. Bye Reproduce code: --------------- $link = OCILogon($user, $pass, $sid); with $sid= "=(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521)))(CONNECT_DATA=(SID=oracle)))"; Expected result: ---------------- Connection. Actual result: -------------- Warning: ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-65535 in /local/netscape/server4/php-bin/dboraconnect.inc on line 25 OCIDebug: _oci_open_server: FAILURE -> CLEANUP called OCIDebug: START _oci_close_server: detaching conn=0 dbname=(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test)(PORT = 1521)))(CONNECT_DATA=(SID=oracle))) OCIDebug: _oci_close_server: closing DEAD server OCIDebug: oci_do_connect: FAILURE -> CLEANUP called OCIDebug: START _oci_conn_list_dtor: id=0 OCIDebug: END _oci_conn_list_dtor: id=0 OCIDebug: START php_rshutdown_oci OCIDebug: END php_rshutdown_oci ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26424&edit=1
