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!

utl_request ORA-29049 error when request salesforce.com

2750634Dec 18 2014 — edited Mar 6 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2015
Added on Dec 18 2014
1 comment
1,098 views