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. 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. ++ Jerome Reproduce code: --------------- 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 MEN1PRD_RAC = ( 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 ) ) ) Expected result: ---------------- The connexion is made to the database Actual result: -------------- [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