ORA-28582: direct connection not allow
| From: | PHP - NEWS | Date: | Wed, 15 Jun 2005 15:29:13 +0000 |
| Subject: | ORA-28582: direct connection not allow | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-39687@lists.php.net to get a copy of this message | ||
I test my script PHP on Debian(sarge) Oracle9.0.2 , and a mandrake Oracle 9.0.2 . On Mandrake all is OK, but on Debian, i have this message :
ORA-28582: a direct connection to this agent is not allowed
I search on Google, faqoracle, oracle.com, without finding any answers or way of solutions.
CODE PHP:
i need to add this on debian, if i want to have any message :
[code]
putenv("ORACLE_BASE=/home/oracle");
putenv("ORACLE_HOME=/home/oracle/OraHome");
putenv("ORACLE_SID=STOR");
[/code]
SCRIPT GLOBAL :
[code]
echo "TEST<BR><BR>";
if ($c=OCILogon("storeland", "storeland", "TEST-ORCL")) {
echo "Successfully connected to Oracle.\n";
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text];
}
$query = "select * from articles";
$stmt = ociParse($c, $query);
if (!ociExecute($stmt)){
echo " NOK";
return FALSE;
}else{
echo "OK<br>";} while ($succ = OCIFetchInto($stmt, $row)) {
foreach ($row as $item) {
echo $item." ";
}
echo "<br>\n";
}
[/code]
I create a new topic, as my problem is different.
Thanks a lot for your help.