R: [PHP-DB] Re: [PHP] Oracle8.16 error ORA-12546,so weird, sugges tions r welcome!

Running httpd as oracle/dba could be harmful for oracle itself. check ORACLE_HOME (and so down on directories) has permission 755 Ciao Roberto > -----Messaggio originale----- > Da: Eric Wang [mailto:eric@otherways.com] > Inviato: martedì 26 settembre 2000 8.29 > A: Michael Howitz > Cc: php-db@lists.php.net > Oggetto: Re: [PHP-DB] Re: [PHP] Oracle8.16 error ORA-12546,so weird, > suggestions r welcome! > > > I tried set httpd user and group to oracle and dba, but it didn't make > a difference. > > On Tue, 26 Sep 2000 11:05:15 +0200 > Michael Howitz <mac@gmx.net> wrote: > > > no, sqlplus is not needed for accessing an oracle-db using php > > the user noboby needn't be able to execute this program. > > > > but, are you having more than one tnsnames.ora > > and is your ORACLE_HOME-shell variable pointing to the right > > oracle-home? > > > > mac > > > > Thies Arntzen wrote: > > > > > > On Mon, Sep 25, 2000 at 04:49:33PM -0700, Eric Wang wrote: > > > > System: > > > > Redhat6.2 > > > > PHP4.02 > > > > Aapche1.3.12 > > > > Oracle 8.16 > > > > > > > > When I tried to connect oracle with php: > > > > <? > > > > ocilogon("system","test","TEST"); > > > > ?> > > > > > > your webserver most likely runs as "nobody" - please make > > > sure that "nobody" can use sqlplus as well. > > > > > > tc > > > > > > > > > > > I get this error > > > > Warning: _oci_open_server: Error while trying to > retrieve text for error ORA-12546 in > /home/otherways/htdocs/testo.php on line 2 > > > > > > > > ORA-12546 TNS:permission denied > > > > Cause: User has insufficient privileges to perform the > requested operation. > > > > Action: Acquire necessary privileges and try again. > > > > > > > > but I use "sqlplus system/test@TEST", it totally ok. > > > > > > > > why php can't access oracle? > > > > > > > > please help! > > > >