Re: [PHP-DB] sqlnet.ora doesn't seem to be read since oci8 1.3.4

[email protected] (Christopher Jones)
Newsgroups php.db
Message-ID <[email protected]>
Jérôme Loyet wrote:
 > Hello,
 >
 > I used to use oci8 version 1.2.3 and I wanted to update to last
 > version (1.3.4). Everything works fine except the fact that
 > "sqlnet.ora" does not seems to be read.
 >
 > I use the following string to describe my database in oci_connect: "MEN1PRD".
 >
 > In sqlnet.ora there is the parameter NAMES.DEFAULT_DOMAIN which is set
 > to "WORLD".
 >
 > In the tnsname.ora I have a full definition for "MEN1PRD.WORLD".
 >
 > With oci8 1.2.3, it worked but since I upgraded to 1.3.4 this is not
 > the case anymore. I have to use the same ID in oci_connect and
 > tnsname.org. The sqlnet.ora NAMES.DEFAULT_DOMAIN does not seem to be
 > used anymore.

Where are your network files located and how you tell PHP where to
find them.  Do you set ORACLE_HOME or TNS_ADMIN?  Where are they set?

At a wild guess, perhaps you are using putenv() in your scripts -
which is never recommended.  See page 106 of the current (1.5) version
of http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf
on how to set environment variables.

Chris

-- 
Email: [email protected]  Tel: +1 650 506 8630
Twitter:  http://twitter.com/ghrd    Free PHP Book: http://tinyurl.com/UGPOM
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.