PHP/Oracle Error

[Philip D Heady]

PHP Warning: ocilogon(): _oci_open_serve r: Error while trying to retrieve
text for error ORA-12154

Anyone get this error before?

[gmuldoon]

Re: PHP/Oracle Error

In article <0xxWb.185$C%.6 3556@news.uswes t.net>, pdheady@comcast .net
says...[color=blue]
> PHP Warning: ocilogon(): _oci_open_serve r: Error while trying to retrieve
> text for error ORA-12154
>
> Anyone get this error before?[/color]

Oracle client being used by PHP's OCI library unable to resolve database
name and thus make a connection to database. Probably an error between
the DbName you are passing in your OCILogon script and your tnsnames.ora
file.

Geoff M

[Philip D Heady]

Re: PHP/Oracle Error

Thanks.

You think it's ok to run php w/ oracle in a production environment?


"gmuldoon" <gmuldoon_nospa m@scu.edu.au> wrote in message
news:MPG.1a9556 6d7d34680c98968 e@news.asgard.n et.au...[color=blue]
> In article <0xxWb.185$C%.6 3556@news.uswes t.net>, pdheady@comcast .net
> says...[color=green]
> > PHP Warning: ocilogon(): _oci_open_serve r: Error while trying to[/color][/color]
retrieve[color=blue][color=green]
> > text for error ORA-12154
> >
> > Anyone get this error before?[/color]
>
> Oracle client being used by PHP's OCI library unable to resolve database
> name and thus make a connection to database. Probably an error between
> the DbName you are passing in your OCILogon script and your tnsnames.ora
> file.
>
> Geoff M[/color]

[gmuldoon]

Re: PHP/Oracle Error

pdheady@comcast .net says...
[color=blue]
> You think it's ok to run php w/ oracle in a production environment?[/color]

Why not?

Currently running here:
Apache 1.3.26 + PHP 4.0.6 on a Tru64 UNIX web server querying Oracle
8.1.7.4 on a separate Tru64 UNIX database server behind a firewall.
Overdue on a couple of version upgrades.

Moving off the web server off Tru64 soon to a Linux cluster attached to
an EMC SAN, database server either going to Linux or Sun. Staying with
Apache + PHP for now, but investigating Tomcat + Java as one possible
alternative. Won't be moving off Oracle, integrated with other
enterprise systems.

Geoff M

[Matthias Esken]

Re: PHP/Oracle Error

"Philip D Heady" <pdheady@comcas t.net> schrieb:
[color=blue]
> You think it's ok to run php w/ oracle in a production environment?[/color]

I do and I'm dealing with millions of records for a german lottery.

Regards,
Matthias

[Philip D Heady]

Re: PHP/Oracle Error

Ok. We've been using Oracle9i here at work w/ all custom Perl code. And I'm
recommending to start switching over to PHP cause it's just more efficient
and faster.

"Matthias Esken" <muelleimer2003 nospam@usenetve rwaltung.org> wrote in
message news:c0eftr.258 .1@usenet.esken .de...[color=blue]
> "Philip D Heady" <pdheady@comcas t.net> schrieb:
>[color=green]
> > You think it's ok to run php w/ oracle in a production environment?[/color]
>
> I do and I'm dealing with millions of records for a german lottery.
>
> Regards,
> Matthias[/color]

[gmuldoon]

Re: PHP/Oracle Error

pdheady@comcast .net says...[color=blue]
> Ok. We've been using Oracle9i here at work w/ all custom Perl code. And I'm
> recommending to start switching over to PHP cause it's just more efficient
> and faster.[/color]

More efficient and faster in terms of development - almost certainly.

More efficient and faster in terms of execution - maybe, maybe not,
dependent on lots of thing.

Geoff M

[cjbj]

Re: PHP/Oracle Error

"Philip D Heady" <pdheady@comcas t.net> wrote in message news:<0xxWb.185 $C%.63556@news. uswest.net>...[color=blue]
> PHP Warning: ocilogon(): _oci_open_serve r: Error while trying to retrieve
> text for error ORA-12154
>
> Anyone get this error before?[/color]

It means (i) You got ORA-12154 (ii) The web server environment doesn't
have ORACLE_HOME set, so the Oracle process can't find the message
file to give you the correct text for the error.

A web search will bring up lots of disscussion on the error. Also see

http://otn.oracle.com/tech/opensource/php/php_troubleshooting_faq.html#connect

-- CJ