Oracle instant client : ORA-28759: failure to open file Oracle instant client : ORA-28759: failure to open file oracle oracle

Oracle instant client : ORA-28759: failure to open file


There were 2 problems that i was fighting with. First was that the url of wallet was pointing to the directory 1 level above than that where my files were placed, and secondly, I was using short syntax of connection. I wsa using this:

# /usr/lib/oracle/11.2/client64/bin/sqlplus /@AVAYAPDSDB

And the successfull appeared to be that :

# /usr/lib/oracle/11.2/client64/bin/sqlplus login/password@AVAYAPDSDB

So now I would add sqlplus to the PATH and begin to set up php enviroment))

Hope this all might be usefull for any one. The main advice from me to any one who would be facing similar issues : turn on client tracing!!!

Good luck !

p.s: Some time have Passed, And I realised, that it is important to mention how to trace any proces easily on linux, without any special settings.

For this use command strace. Example:

strace  -o /tmp/log_of_trace.txt ./configure

Instead of ./con... you can call oracle client connection or any other processes that you want to trace. In log you'll get all nesessary information and errors, and all in stacktrace! That is very helpfull!!

A lot of Info for searching where the problem is hiding =)

Luck to all!