utl_request ORA-29049 error when request salesforce.com [message #629965] |
Thu, 18 December 2014 03:21 |
|
junkai.niu
Messages: 1 Registered: December 2014 Location: 中国
|
Junior Member |
|
|
SQL> select utl_http.request('https://login.salesforce.com/', NULL,'file:/tmp/','ASDF') from dual;
select utl_http.request('https://login.salesforce.com/', NULL,'file:/tmp/','ASDF') from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-29049: unknown record
ORA-06512: at line 1
I have created wallet like this:
orapki wallet create -wallet /tmp -pwd password123 -auto_login
orapki wallet add -wallet /tmp -trusted_cert -cert XXX.cer -pwd ASDF
Searched some results:
OERR: ORA-29049 Unknown record (Doc ID 288469.1)
{ This note contains error information about an "Oracle Server"
error number. It may contain additional support notes as
described in Note:22080.1 }
Error: ORA-29049 (ORA-29049)
Text: Unknown record
---------------------------------------------------------------------------
Cause: The record type is unknown.
Action: Enable Oracle Net tracing and attempt the connection again.
Contact Oracle customer support with the trace output.
So I started tracing and got the following logs:
///////////////////////////////////////////////////////////////
Error found. Error Stack follows:
id:0
Operation code:70
NS Error 1:12582
NS Error 2:0
NT Generic Error:0
Protocol Error:0
OS Error:0
NS & NT Errors Translation
12582, 00000 "TNS:invalid operation"
// *Cause: An internal function received an invalid request.
// *Action: Not normally visible to the user. For further details, turn
// on tracing and reexecute the operation. If error persists, contact
// Oracle Customer Support.
/
00000, 00000 "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Dont worry: Be happy.
/
00000, 00000 "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Dont worry: Be happy.
///////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////
Error found. Error Stack follows:
id:0
Operation code:70
NS Error 1:12630
NS Error 2:0
NT Generic Error:0
Protocol Error:0
OS Error:0
NS & NT Errors Translation
12630, 00000 "Native service operation not supported"
// *Cause: An operation requested by a user is not supported by the native
// services component.
// *Action: This may be an internal error if the operation should have been
// supported.
/
00000, 00000 "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Dont worry: Be happy.
/
00000, 00000 "Not An Error"
// *Cause: Everything is working as it should.
// *Action: Dont worry: Be happy.
/
///////////////////////////////////////////////////////////////
end....
Any idea?
Thanks,
Junkai
|
|
|
|