Re: Oracle Client @ Windows: ORA-12154 when calling from path with brackets "("

Hi,

This is cos when you connect via sqlnet the directory of the .exe is passed along with the .exe name and other info to the server. You can see this by doing a trace at level 16 via sqlnet.ora

trace_level_client = 16
trace_file_client = sqlnet
trace_directory_client = e:\oracle\ora81\network\trace

in the trace you would find;

nspsend: 3D 28 50 52 4F 47 52 41  |=(PROGRA|
nspsend: 4D 3D 45 3A 5C 6F 72 61  |M=E:\ora|
nspsend: 63 6C 65 5C 6F 72 61 38  |cle\ora8|
nspsend: 31 5C 62 69 6E 5C 53 51  |1\bin\SQ|
nspsend: 4C 50 4C 55 53 2E 45 58  |LPLUS.EX|
nspsend: 45 29 28 48 4F 53 54 3D  |E)(HOST=|
nspsend: 48 51 30 31 36 32 39 29  |HQ01629)|

The "(" is getting interpreted by sqlnet as being part of the information sent during the connect, ie; as part of the connect string. A "(" in the wrong place would render the connect string invalid and hence the 12154.

I would suggest you drop the "(" from the dir name. You could of course try the square bracket "[" and see if that makes a diff, but I rekon its a can of worms.

I also remember years ago something along the same lines of getting a 12154 if the hostname had a non alpha numeric in it.

I wonder if a jdbc connect string would error in the same mannerl? Maybe worth a try.

--
Daniel