Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28759: failure to open file

MaahjoorNov 18 2015 — edited Nov 29 2015

Dear all,

we are using Oracle 10.2.0.5 on windows 2008 server. all 64 bit. i am following this tutorial

https://oracle-base.com/articles/misc/utl_http-and-ssl

in the step Test Secured Connection in the above link, i receive the following error

SQL>  EXEC show_html_from_url('https://myurl/IBulkSMS.asmx');

BEGIN show_html_from_url('https://myrul/IBulkSMS.asmx'); END;

*

ERROR at line 1:

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1389

ORA-29261: bad argument

ORA-06512: at "SYS.SHOW_HTML_FROM_URL", line 22

ORA-29273: HTTP request failed

ORA-06512: at "SYS.UTL_HTTP", line 1029

ORA-28759: failure to open file

ORA-06512: at line 1

i think my problem is solved in the below link, but i don't know how to implement the solution provided.

https/wallet ora-28759: failure to open file

according to the solution in the thread

Wallet Manager set permissions on the files, so they can only be read by the user who created them. Either modify the permissions or copy the files to another location. And then in your "set_wallet" reference the new location.

ho to modify the permission? i am loged in as administrator to my machine, and i created those wallet, files and directory from the same user.

could somebody guide me?

thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2015
Added on Nov 18 2015
15 comments
11,170 views