Today a colleague of mine called me to watch a strange problem. A Delphi written program refused, on his pc, to connect to an Oracle instance giving the error:
"ORA-12154: TNS:could not resolve the connect identifier specified".
I checked the connection string and it seemed correct. I tried connecting with tnsping and then with sqlplus and they all succeed.
Then I checked the same program on my pc, and there it worked. At that moment a bell rang in my head. I came back at my colleague's desk and looked at the folder name in which the program was stored. It was "Jobtime WF (exe)".
It seems that Oracle OCI doesn't like path with parenthesis. Changing the folder name fixed the error.
I had already met this error in year 2000, when I started working with Oracle, but from then I forgot it. This kind of thing happened to me quite often.
I mean I often feel that some technical detail become new just because I forgot it.
It always reminds to me a quote used by epigraph by Borges, at the beginning of "El Aleph":
Salomon saith: There is no new thing upon the earth. So that as Plato had an immagination, that all knowledge was but remembrance; so Salomon giveth his sentence, that all novelty is but oblivion.
Francis Bacon: Essays, LVIII
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment