php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #33712 Unable to connect to Oracle database(ORA-12705)
Submitted: 2005-07-15 16:54 UTC Modified: 2005-07-16 22:16 UTC
From: lionel dot roux at bio-rad dot com Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 4.4.0 OS: AIX5.2
Private report: No CVE-ID: None
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: lionel dot roux at bio-rad dot com
New email:
PHP Version: OS:

 

 [2005-07-15 16:54 UTC] lionel dot roux at bio-rad dot com
Description:
------------
hello,
I have the following messages using :  
$id=OCILogon("dtpfra","dtpfra",$db,$NLS_LANG);

Warning: ocilogon(): OCISessionBegin: Error while trying to retrieve text for error ORA-12705 in /usr/local/apache2/htdocs/fonctions.php on line 27
testconn=-1

The following parameters have been set in envars:
export ORA_NLS32=/home/oracle/9.2.0/ocommon/nls/admin/data
export LIBPATH="/home/oracle/9.2.0/lib32:/usr/local/apache2/lib:$LIBPATH"
export LD_LIBRARY_PATH="/home/oracle/9.2.0/lib:/home/oracle/9.2.0/lib32"
export ORACLE_BASE="/home/oracle"
export ORACLE_HOME="$ORACLE_HOME:/home/oracle/9.2.0"
export TNS_ADMIN="$ORACLE_HOME/network/admin:$TNS_ADMIN"
export NLS_LANG=american_america.WE8ISO8859P1
export LANG=C
#export LANG=en_US
export TWO_TASK=$ORACLE_HOME 

Reproduce code:
---------------
putenv("ORACLE_SID=DLPFRA");
 getenv("ORACLE_HOME");
 getenv("TNS_ADMIN");
 getenv("LD_LIBRARY_PATH");
 $ORACLE_SID = getenv("ORACLE_SID");
 $ORACLE_HOME = getenv("ORACLE_HOME");
 $LD_LIBRARY_PATH=getenv("LD_LIBRARY_PATH");
 $TNS_ADMIN=getenv("TNS_ADMIN");
 $NLS_LANG=getenv("NLS_LANG");
 $LANG=getenv("LANG");
 print "VERIF :$ORACLE_SID, $ORACLE_HOME,  $LD_LIBRARY_PATH, $TNS_ADMIN, $NLS_LANG";

 $db="(DESCRIPTION=
         (ADDRESS_LIST=
           (ADDRESS=(PROTOCOL=TCP)
             (HOST=FRUX33)(PORT=1521)
           )
         )
           (CONNECT_DATA=(SERVICE_NAME=dtpfra))
     )"; 
 $id=OCILogon("dtpfra","dtpfra",$db,$NLS_LANG);




Expected result:
----------------
Connection to the database

Actual result:
--------------
VERIF :DLPFRA, :/home/oracle/9.2.0, /home/oracle/9.2.0/lib:/home/oracle/9.2.0/lib32, :/home/oracle/9.2.0/network/admin:, american_america.WE8ISO8859P1
Warning: ocilogon(): OCISessionBegin: Error while trying to retrieve text for error ORA-12705 in /usr/local/apache2/htdocs/fonctions.php on line 27

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-07-16 22:16 UTC] tony2001@php.net
Obviously you have set the ORACLE_HOME to wrong value.
Not PHP problem.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Fri Apr 25 00:01:27 2025 UTC