Re: Oracle8.16 error ORA-12546,so weird, suggestions r welcome!
| From: | Michael Howitz | Date: | Tue, 26 Sep 2000 09:05:15 +0000 |
| Subject: | Re: Oracle8.16 error ORA-12546,so weird, suggestions r welcome! | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3081@lists.php.net to get a copy of this message | ||
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!
> >