Re: PHP - Oracle 7.3.4 - ORA-12154

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



add the failover directive in tnsnames.ora. Find how to on the web (not
sure right now)

-- 
Maxim Maletsky
maxim@php.net


On Fri, 07 Feb 2003 02:15:43 +0000 Maron Kristófersson <maron@transistor.tv> wrote:

> Hello!
> 
> I set up PHP on a Sun Solaris box a week ago (see phpinfo output below).
>    It has oracle 7.3.4 and php 4.0.4pl1 so I'm using the --with-oracle
> configure option.  Due to a special module we're using we're stuck with
> using that php version (4.0.4pl1).
> 
> At first I was getting the ORA-12154 TNS:could not resolve service name
> error almost every time.  I then followed the instructions to set the
> ORACLE_HOME and TNS_ADMIN environment variables in apaches http.conf.
> I've also tried using the putenv function to set the variables.
> 
> This really improved the situation but when I found it was still not
> working I wrote a small java program that calls the php page every 15
> seconds.  About 10% of the time I get the TNS (ORA-12154) error but the
> other 90% it works perfect.  This applies both to selecting and
> inserting data.
> 
> -- partial output from phpinfo() --
> System SunOS red 5.7 Generic_106541-15 sun4u sparc SUNW,Ultra-250
> Build Date Jan 29 2003
> Configure Command './configure' '--with-apxs=/opt/apache/bin/apxs'
> '--with-mysql=no' '--with-oracle=/opt/app/oracle/product/7.3.4/'
> 
> oracle
> Oracle Support enabled
> Oracle Version 7.3
> Compile-time ORACLE_HOME /opt/app/oracle/product/7.3.4/
> Libraries Used
> 
> I really need to get this working so all ideas would be appreciated.
> 
> Best regards,
> 
> Maron Kristófersson
> Reykjavík
> Iceland
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux