#33712 [NEW]: Unable to connect to Oracle database(ORA-12705)

From: lionel dot roux at bio-rad dot com Operating system: AIX5.2 PHP version: 4.4.0 PHP Bug Type: OCI8 related Bug description: Unable to connect to Oracle database(ORA-12705) 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 -- Edit bug report at http://bugs.php.net/?id=33712&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33712&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33712&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33712&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33712&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33712&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33712&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33712&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33712&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33712&r=support Expected behavior: http://bugs.php.net/fix.php?id=33712&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33712&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33712&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33712&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33712&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33712&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33712&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33712&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33712&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33712&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33712&r=mysqlcfg