php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #26424 Warning: ocilogon(): ORA-65535
Submitted: 2003-11-26 08:58 UTC Modified: 2003-12-04 02:27 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: vinz_ at libero dot it Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 4.3.2 OS: solaris 8
Private report: No CVE-ID: None
 [2003-11-26 08:58 UTC] 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


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-11-26 17:22 UTC] elmicha@php.net
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-27 04:50 UTC] 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-12-04 02:27 UTC] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Dec 22 06:01:30 2024 UTC