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
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
The version of php (5.2.3) is still the same, the configure options
are the sames, the oracle lib is the same (9.2) and the php.ini
parameters are the same too. I just changed the oci8 version.
Has anyone the same problem ? Is this a normal behaviour ? If yes, why
and is there a workaround ?
Thanks for your answers.
Piece of code which used to work (version 1.2.3) and doesn't work
anymore (version 1.3.4):
$conn = oci_connect('EDUCATION', 'manager', 'MEN1PRD');
Piece of code which works (version 1.3.4):
$conn = oci_connect('EDUCATION', 'manager', 'MEN1PRD.WORLD');
Content of sqlnet.ora (which is in the same directory as tnsname.ora):
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = WORLD
LOG_DIRECTORY_SERVER = /var/tmp
Contenat of tnsname.ora
( DESCRIPTION =
( ADDRESS = ( PROTOCOL = TCP )( HOST = host1 )( PORT = 1521 ) )
( ADDRESS = ( PROTOCOL = TCP )( HOST = host2 )( PORT = 1521 ) )
( LOAD_BALANCE = yes )
( CONNECT_DATA =
( SERVER = DEDICATED )
( SERVICE_NAME = SN_MEN1PRD )
The connexion is made to the database
[Mon Feb 16 18:05:14 2009] [error] [client 127.0.0.1] PHP Warning:
oci_connect() [<a href='function.oci-connect'>function.oci-connect</a>]:
ORA-12154: TNS:could not resolve service name in /var/www/docs/test1.php
on line 2
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php