不是哪儿的问题,我用 <? if ($conn=Ora_Logon("user@SID","pwd")) { echo "SUCCESS ! Connected to database\n"; } else {echo "Failed :-( Could not connect to database\n";} Ora_Logoff($conn); phpinfo(); ?> 测试,也报错:Warning: Oracle: Connection Failed: Error while trying to retrieve text for error ORA-01019
phpinfo中oci8里面的oracle_home对不对?,再不行就把apache的user改能启动oracle的user
如下:./configure --prefix=/usr/local/php434 --with-apxs=/usr/local/apache13/bin/apxs --with-mysql=/usr --enable-sigchild --enable-safe
-mode --with-system-regex --disable-debug --enable-magic-quotes --enable-track-vars --with-zlib-dir=/usr/local --with-ttf=/usr/local
--enable-gd-native-ttf --with-jpeg-dir=/usr --with-gd=/usr/local --with-oracle=/usr/oracle/9i --with-oci8=/usr/oracle/9iapache的user改掉后(user:oracle;Group:sysdba),程序访问引入的文件是会有访问权限问题。(关键还是我不太懂php)
如果apache的running user为oracle可能是有点小问题,但apache中的group用#-1就可以了.
也可以相反地,让apache的running user有/usr/oracle/9i目录权限也是可以的啊
我的目的只是想看一西到底是不是因为apache user的权限导致此问题的
$this->Link_ID = @OCIplogon ("$this->DBUser", "$this->DBPassword", "$this->DBDatabase");
else
$this->Link_ID = @OCIlogon ("$this->DBUser", "$this->DBPassword", "$this->DBDatabase");
这是连接代码
<?
if ($conn=Ora_Logon("user@SID","pwd"))
{ echo "SUCCESS ! Connected to database\n";
}
else
{echo "Failed :-( Could not connect to database\n";}
Ora_Logoff($conn);
phpinfo();
?> 测试,也报错:Warning: Oracle: Connection Failed: Error while trying to retrieve text for error ORA-01019