Oracle Instant Client: Ora-28759: Failure to Open File

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!

How to connect to Oracle Cloud Database with instant client from CentOS 7?

I wrote this up last week in How to connect to Oracle Autonomous Cloud Databases.

You can edit sqlnet.ora if you don't have the config files in the default network/admin directory. If they are in that directory then you don't need to edit it, because the pre-supplied path "?/network/admin" maps to the network/admin subdirectory under where the libclntsh.so file is.

The other alternative is to use "Easy Connect Plus" syntax like:

tcps://adb.ap-sydney-1.oraclecloud.com:1522/abc_cjjson_high.adb.oraclecloud.com?wallet_location=/Users/cjones/Cloud/CJJSON

Extract cwallet.so from the wallet zip, and stick it in a directory (I used /Users/cjones/Cloud/CJJSON). Then find the host, servicename, port etc from the wallet tnsnames.ora file and build up your easy connect string. Then you can 'throw away' the zip file since it is not needed :)

Related Topics