Re: PHP - Oracle 7.3.4 - ORA-12154

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

 



> 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).

Couldn't you use --with-oci, even with that php version ? it's the newer and
better module for oracle (both oracle 7 and 8). Look at ocilogon() function
and friends.

> 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.

I had also trouble with ora12154. I use now a workaround :
when I use : $connection = OCILogon($user, $pass, $tns) or die("No
Connection");
for the third parameter ($tns), I don't use the name found in tnsnames.ora,
but directly the entire syntax
something like :
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = <ip address>)
          (Port = 1521)
        )
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = <ip address>)
          (Port = 1526)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )


Regards,
Philippe



-- 
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