ID: 33712
Updated by: [EMAIL PROTECTED]
Reported By: lionel dot roux at bio-rad dot com
-Status: Open
+Status: Bogus
Bug Type: OCI8 related
Operating System: AIX5.2
PHP Version: 4.4.0
New Comment:
Obviously you have set the ORACLE_HOME to wrong value.
Not PHP problem.
Previous Comments:
------------------------------------------------------------------------
[2005-07-15 16:54:56] 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
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33712&edit=1
