#26424 [Fbk->NoF]: Warning: ocilogon(): ORA-65535

From: Date: Thu, 04 Dec 2003 07:27:08 +0000
Subject: #26424 [Fbk->NoF]: Warning: ocilogon(): ORA-65535
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-51670@lists.php.net to get a copy of this message 
 ID:               26424
 Updated by:       sniper@php.net
 Reported By:      vinz_ at libero dot it
-Status:           Feedback
+Status:           No Feedback
 Bug Type:         OCI8 related
 Operating System: solaris 8
 PHP Version:      4.3.2
 New Comment:

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.




Previous Comments:
------------------------------------------------------------------------

[2003-11-30 04:21:36] sniper@php.net

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



------------------------------------------------------------------------

[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] 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-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

Thread (5 messages)

« previous php.bugs (#51670) next »