RE: [PHP] Oracle Connection
| From: | Andrew Hill | Date: | Mon, 27 Nov 2000 18:16:19 +0000 |
| Subject: | RE: [PHP] Oracle Connection | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-27416@lists.php.net to get a copy of this message | ||
Carlos,
Good point. Try logging in as oracle and connecting using the native
interface (svrmgrl)
eg:
svgmgrl
connect (database name)
and then try a Select statement.
If you can successfully run on, then you have a problem in your PHP layer.
If you cannot (as I suspect) then you need to fix something in the install -
my money is still on environment variables.
Best regards,
Andrew
> -----Original Message-----
> From: Carlos Henrique [mailto:ch@ifx.com.br]
> Sent: Monday, November 27, 2000 1:37 PM
> To: ahill@openlinksw.com
> Subject: RES: [PHP] Oracle Connection
>
>
> But in this case, why PHP compiles ok?
>
> Carlos
> PS: thanks for your attention!
>
> -----Mensagem original-----
> De: Andrew Hill [mailto:ahill@openlinksw.com]
> Enviada em: segunda-feira, 27 de novembro de 2000 14:18
> Para: Carlos Henrique
> Assunto: RE: [PHP] Oracle Connection
>
>
> Carlos,
>
> Perhaps, if the directories containing the necessary Oracle files
> cannot be
> found it would have the same effect.
>
> Best regards,
> Andrew
>
>
> > -----Original Message-----
> > From: Carlos Henrique [mailto:ch@ifx.com.br]
> > Sent: Monday, November 27, 2000 1:08 PM
> > To: ahill@openlinksw.com
> > Subject: RES: [PHP] Oracle Connection
> >
> >
> > Andrew, I checked the variables and its ok! The source of
> problem can be a
> > bad oracle installation?
> >
> > Carlos
> >
> > -----Mensagem original-----
> > De: Andrew Hill [mailto:ahill@openlinksw.com]
> > Enviada em: segunda-feira, 27 de novembro de 2000 11:06
> > Para: Carlos Henrique; PHP LIST
> > Assunto: RE: [PHP] Oracle Connection
> >
> >
> > Carlos,
> >
> > The Oracle error you report is ususally caused by the Oracle environment
> > variables not being set before you start Oracle. ( ORACLE_HOME,
> > ORACLE_BASE,
> > ORACLE_SID, LD_LIBRARY_PATH) you also may want to pass them in
> > to your php
> > via putenv("ORACLE_HOME=/path/to/ora/home");
> >
> > Hope this helps.
> >
> > > -----Original Message-----
> > > From: Carlos Henrique [mailto:ch@ifx.com.br]
> > > Sent: Monday, November 27, 2000 8:23 AM
> > > To: PHP LIST
> > > Subject: [PHP] Oracle Connection
> > >
> > >
> > > Friends,
> > >
> > > I installed an oracle client/libs in my apache/php server in order to
> > > connect to a remote oracle server. Recompiled my PHP
> > installation (not the
> > > apache, it's DSO) sucessfully and when I try to connect using
> > ora_logon it
> > > returns "Warning: Oracle: Connection Failed: Error while trying
> > > to retrieve
> > > text for error ORA-12154 in ... ". TNS names setup are ok.
> > >
> > > Any tips or hints in configuring oracle/php?? Thanks!
> > >
> > > Regards,
> > > Carlos
> >
> >
> >
>
>
>