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
