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
 [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-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 23:01:28 2024 UTC