php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #11169 OCILogon failed
Submitted: 2001-05-29 08:52 UTC Modified: 2002-04-13 08:36 UTC
From: truejaws at unitel dot co dot kr Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.5 OS: Solaris 7
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: truejaws at unitel dot co dot kr
New email:
PHP Version: OS:

 

 [2001-05-29 08:52 UTC] truejaws at unitel dot co dot kr 
My program cannot connect to oracle server.
I think this bug is equal to Richard's (#6456), that was closed for no feedback.
(hi kir@php.net, tnsping works successfully.)

For any questions about this bug, I'll reply ASAP.


compiled options:
-----------------
./configure --with-oci8=/oracle --enable-track-vars


error producing:
----------------

$ cat tt.php
#!/usr/local/bin/php -q
<?
function Logon() {
    OCIInternalDebug(1);
    $dbuser = "userid";
    $dbuserpwd = "pwd";

    $conn = OCILogon($dbuser, $dbuserpwd, "our_dbserver");
    return $conn;
}

$conn = Logon();
if($conn != false){
    echo"OK> DB connection ok\n";
} else {
    echo"ERR> DB connection fail\n";
}

?>
$ php tt.php
X-Powered-By: PHP/4.0.5
Content-type: text/html

OCIDebug: _oci_open_server new conn=0 dname=our_dbserver<br>
<br>
<b>Warning</b>:  OCISessionBegin: ORA-03120: two-task conversion routine: integer overflow
 in <b>tt.php</b> on line <b>7</b><br>
OCIDebug: _oci_open_session: FAILURE -> CLEANUP called<br>
OCIDebug: START _oci_close_session: logging-off sess=0<br>
OCIDebug: _oci_close_session: logging-off DEAD session<br>
OCIDebug: oci_do_connect: FAILURE -> CLEANUP called<br>
OCIDebug: START _oci_conn_list_dtor: id=0<br>
OCIDebug: END   _oci_conn_list_dtor: id=0<br>
ERR> DB connection fail
OCIDebug: START php_rshutdown_oci<br>
OCIDebug: END   php_rshutdown_oci<br>
OCIDebug: START _oci_close_server: detaching conn=1 dbname=our_dbserver<br>
OCIDebug: START php_mshutdown_oci<br>
OCIDebug: END   php_mshutdown_oci<br>


System environment:
------------------

$ tnsping our_dbserver

TNS Ping Utility for Intel SVR4 UNIX: Version 8.1.5.0.0 - Production on 29-MAY-01 20:58:14

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=our_dbserver)(PORT=1521))
OK (10 msec)

$ sqlplus dev2/dev2@dev.ableclick.co.kr

SQL*Plus: Release 8.1.5.0.0 - Production on Tue May 29 21:24:08 2001

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SQL> 

$ php -v
4.0.5
$ uname -a
SunOS red 5.7 Generic_106542-11 i86pc i386 i86pc

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-29 09:22 UTC] sniper@php.net 
Have you set ALL the environment variables mentioned
on this page: http://www.php.net/oci8

--Jani
 [2001-05-29 10:06 UTC] truejaws at unitel dot co dot kr 
sqlplus works fine.

I think LD_PRELOAD variable is not necessary.


$ env
_=/usr/bin/env
HZ=100
PATH=/opt/SUNWspro/bin:/usr/ccs/bin:/usr/bin:/usr/local/bin:/usr/ucb:/etc:/usr/sbin:.:/oracle/bin
NLS_LANG=American_America.KO16KSC5601
LOGNAME=oracle
ORACLE_SID=XXXX
ORACLE_OWNER=xxxxxx
SHELL=/bin/ksh
ORA_NLS33=/oracle/ocommon/nls/admin/data
HOME=/oracle
LD_LIBRARY_PATH=/oracle/lib
DISPALY=red:0.0
TERM=vt100
ORACLE_HOME=/oracle
PWD=/tmp
TZ=ROK
 [2002-04-13 08:36 UTC] thies@php.net 
nothing php can do. something with your oracle-client setup is wrong.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 15:01:27 2025 UTC