UTL_HTTP.set_wallet & Oracle Wallet & ORA-28759

[Dejan Topalovic]

Hi to all!

I am trying to connect over https using UTL_HTTP Package, but
unsuccessful... It throws up this ORA error:

ORA-28759: failure to open file

Code snip:
...
UTL_HTTP.set_wallet('file:/home/oracle/wallets','oraw4lL3t');
...

sqlnet.ora contains following entry:

WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA = (DIRECTORY = /home/oracle/wallets))
)

Database is 10g on IBM AIX.

What coul'd be the reason for this error and how can I resolve this problem?

All help appreciated.

[Frank van Bortel]

Post by Dejan Topalovic
Hi to all!
I am trying to connect over https using UTL_HTTP Package, but
ORA-28759: failure to open file
...
UTL_HTTP.set_wallet('file:/home/oracle/wallets','oraw4lL3t');
...
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA = (DIRECTORY = /home/oracle/wallets))
)
Database is 10g on IBM AIX.
What coul'd be the reason for this error and how can I resolve this problem?
All help appreciated.

http://www.oreillynet.com/cs/user/view/cs_msg/26880

[Dejan Topalovic]

Post by Frank van Bortel
http://www.oreillynet.com/cs/user/view/cs_msg/26880

Thanks for the link, but I cannot find any helpful information there ... :(
I mean, I've maded everything like there, but the error comes up again,
pointing at the line, that contains:

UTL_HTTP.set_wallet('file:/home/oracle/wallets','oraw4lL3t');


Any other suggestions?

[Frank van Bortel]

Post by Dejan Topalovic

Post by Frank van Bortel
http://www.oreillynet.com/cs/user/view/cs_msg/26880

Thanks for the link, but I cannot find any helpful information there ... :(
I mean, I've maded everything like there, but the error comes up again,
UTL_HTTP.set_wallet('file:/home/oracle/wallets','oraw4lL3t');
Any other suggestions?

/home/oracle/wallets: is it readable for the oracle process?

Also, there's an OBE page for utl_http; google...

[Dejan Topalovic]

Post by Frank van Bortel

Post by Dejan Topalovic

Post by Frank van Bortel
http://www.oreillynet.com/cs/user/view/cs_msg/26880

Thanks for the link, but I cannot find any helpful information there ... :(
I mean, I've maded everything like there, but the error comes up again,
UTL_HTTP.set_wallet('file:/home/oracle/wallets','oraw4lL3t');
Any other suggestions?

/home/oracle/wallets: is it readable for the oracle process?

Yep.

Post by Frank van Bortel
Also, there's an OBE page for utl_http; google...

Heh, Google is my best friend ;-) but, even Google couldn't help me ...

I know how to use UTL_HTTP, don't worry...

I've also asked my DBA friend, who have more then 10 years experience, but
even he couldn't help me... Noone in our department worked with Oracle
Wallet :(