PHP/Oracle Error

[Philip D Heady]

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

Anyone get this error before?

[gmuldoon]

In article <0x****************@news.uswest.net>, pd*****@comcast.net
says...

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

Anyone get this error before?

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]

Thanks.

You think it's ok to run php w/ oracle in a production environment?
"gmuldoon" <gm*************@scu.edu.au> wrote in message
news:MP************************@news.asgard.net.au ...

In article <0x****************@news.uswest.net>, pd*****@comcast.net
says...

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

Anyone get this error before?

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

[gmuldoon]

pd*****@comcast.net says...

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

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]

"Philip D Heady" <pd*****@comcast.net> schrieb:

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

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

Regards,
Matthias

[Philip D Heady]

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" <mu******************@usenetverwaltung.org> wrote in
message news:c0**********@usenet.esken.de...

"Philip D Heady" <pd*****@comcast.net> schrieb:

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

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

Regards,
Matthias

[gmuldoon]

pd*****@comcast.net says...

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.

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]

"Philip D Heady" <pd*****@comcast.net> wrote in message news:<0x****************@news.uswest.net>...

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

Anyone get this error before?

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/opensourc...q.html#connect

-- CJ