PHP 5.0.4 cannot use Oracle*Net on 10.2

[Mladen Gogala]

My database is on Linux, FC3. I know it isn't supported, I am
not asking for support, I am just reporting a problem.

This is the error that I'm receiving:

Exception:oci8 error: [12154: Error while trying to retrieve text for
error ORA-12154 ] in CONNECT(local, 'SYSTEM', '****', )

Apache processes are failing like crazy:

[Thu Jul 07 22:25:15 2005] [notice] child pid 23090 exit signal
Segmentation fault (11) [Thu Jul 07 22:25:16 2005] [error] [client
127.0.0.1] File does not exist: /opt/apache/htdocs/favicon.ico [Thu Jul 07
22:25:23 2005] [error] [client 127.0.0.1] File does not exist:
/opt/apache/htdocs/favicon.ico [Thu Jul 07 22:25:25 2005] [error] [client
127.0.0.1] File does not exist: /opt/apache/htdocs/favicon.ico [Thu Jul 07
22:25:26 2005] [notice] child pid 23091 exit signal Segmentation fault
(11) [Thu Jul 07 22:25:39 2005] [notice] child pid 23087 exit signal
Segmentation fault (11) [Thu Jul 07 22:25:39 2005] [notice] child pid
23092 exit signal Segmentation fault (11) [Thu Jul 07 22:26:42 2005]
[error] [client 127.0.0.1] File does not exist:
/opt/apache/htdocs/favicon.ico [client 127.0.0.1] PHP Warning: ocilogon()
[<a href='function.ocilogon'>function.ocilogon</a>]: _oci_open_server:
Error while trying to retrieve text for error ORA-12154\n in
/usr/local/PHP/adodb/drivers/adodb-oci8.inc.php on line 228, referer:
http://localhost/dba/dba_helper.php [Thu Jul 07 22:26:51 2005] [error]
[client 127.0.0.1] File does not exist: /opt/apache/htdocs/favicon.ico

$ sqlplus scott/tiger

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 7 22:29:32 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning and Data Mining options

SQL>

Hopefully, 5.1 will resolve these problems when it gets out of beta.

Of course, it worked like a charm with 10.1.0.4

--
http://www.mgogala.com

[HansF]

On Fri, 08 Jul 2005 02:31:32 +0000, Mladen Gogala interested us by
writing:

My database is on Linux, FC3. I know it isn't supported, I am
not asking for support, I am just reporting a problem.

This is the error that I'm receiving:

Exception:oci8 error: [12154: Error while trying to retrieve text for
error ORA-12154 ] in CONNECT(local, 'SYSTEM', '****', )

Sounds like possibly your $ORACLE_HOME/network.admin/tnsnames.ora is not
set up to talk to the database the way PHP expects it to work. Or you are
not getting to the right tnsnames.ora

For example - which service are you using in SQLPlus? You probably have
$ORACLE_SID set up in that environment ... but it doesn't match the SID
used in PHP. (Occasionally multiple tnsnames.ora are created, one per
ORACLE_HOME, and the user accidently points at the wrong one.)

With the 'retrieve text' issue, it almost points at the $ORACLE_HOME not
being recognized inside PHP at all (but of course, it's beta so that might
be misleading)

Some troubleshooting hints (yes, they are for 9i but still valid. Or you
could look up the equiv in the 10g docco)

http://download-west.oracle.com/docs...les.htm#440455

Let us know how it resolves
--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

[Mladen Gogala]

On Fri, 08 Jul 2005 02:43:47 +0000, HansF wrote:

Sounds like possibly your $ORACLE_HOME/network.admin/tnsnames.ora is not
set up to talk to the database the way PHP expects it to work. Or you are
not getting to the right tnsnames.ora

Everything was set the right way, except one minor detail: $ORACLE_HOME
was not world-readable, so user "nobody" couldn't read it. I thought that
I was going mad....

--
http://www.mgogala.com

[Mladen Gogala]

On Fri, 08 Jul 2005 02:43:47 +0000, HansF wrote:

Let us know how it resolves

It still fails with core dump, though. It works like a charm when I link
it against the freshly installed 10.1 client.

--
http://www.mgogala.com