Re: [PHPLIB] Oracle Login Problems From: Mark Nold (MarkN <email protected>)
Date: 10/28/99

I assume your php or webserver user is not the same as the Oracle user?

Trying logging in as the webserver user via sqlplus and see what happens.

Your possible problems are an inaccible tnsnames.ora or sqlnet.ora or possibly the env variables you have stated are wrong. Try logging in as your oracle owner and do a set | grep -i ora

My www server has the following set in its env

ORACLE_HOME=/oracle/product/7.3.3
ORACLE_SID=mimsprd
ORAENV_ASK=YES
ORAHOME=/oracle/product/7.3.3

Works for me. Also i have no idea about the German character set.. could this be the problem?

Mark Nold
markn <email protected>
Systems Consultant
"Change is inevitable - except from vending machines"

>>> Kristian Koehntopp <kk <email protected>> 10/28 2:35 pm >>>

I have the following script:

www:/usr/local/httpd/htdocs # cat ora.php3
<?php
  PutEnv("ORACLE_HOME=/home/oracle/product/805");
  PutEnv("NLS_LANG=NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1");
// PutEnv("NLS_LANG=german_germany.we8pc850");
// PutEnv("LD_LIBRARY_PATH=/home/oracle/product/805/lib");
// PutEnv("ORA_NLS33=/home/oracle/product/805/ocommon/nls/admin/data");

  echo "I am here!<br>\n";
  flush();

 $t = ociplogon("x_dba","x","x");
 echo "Connection id: $t<br>\n";

 echo "Back again<br>\n";

?>

I can connect as User Oracle with "sqlplus x_dba/x <email protected>" to the
server, but when I try the above script, I get

   I am here!
   Warning: OCISessionBegin: ORA-24365: error in character conversion in /www/htdocs/ora.php3 on line 11
   Connection id:
   Back again.

Ideas, anybody?

Kristian 

-- 
Kristian Köhntopp, NetUSE Kommunikationstechnologie GmbH
Siemenswall, D-24107 Kiel, Germany, +49 431 386 436 00
Using PHP3? See our web development library at
http://phplib.netuse.de/ (We have moved! Update your bookmarks!)
-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.