Re: Re: 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! > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >