Thanks for the question, haitham.

Asked: February 08, 2023 - 1:40 pm UTC

Last updated: February 20, 2023 - 4:18 am UTC

Version: 22.2

Viewed 10K+ times! This question is

You Asked

hello,

I working on oracle apex for long time , this is first time that we face a common an error message
when tries to print any report through oracle apex that available on this https://apex.oracle.com/

Error processing request.
Contact your application administrator.

Technical Info (only available for developers)
is_internal_error: true
apex_error_code: APEX.UNHANDLED_ERROR
ora_sqlcode: -29273
ora_sqlerrm: ORA-29273: HTTP request failed ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 1230 ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 830 ORA-12541: TNS:no listener ORA-06512: at "SYS.UTL_HTTP", line 380 ORA-06512: at "SYS.UTL_HTTP", line 1148 ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 804 ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 1071 ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 1490 ORA-06512: at "APEX_220200.WWV_FLOW_WEBSERVICES_API", line 612 ORA-06512: at "APEX_220200.WWV_FLOW_PRINT_UTIL", line 789 ORA-06512: at "APEX_220200.WWV_FLOW_RENDER_QUERY", line 1842 ORA-06512: at "APEX_220200.WWV_FLOW_RENDER_QUERY", line 1930
component.type: APEX_APPLICATION_PAGES
component.id: 98455000000000
component.name: Global Page - Desktop
error_backtrace:
ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 1230
ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 830
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1148
ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 804
ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 1071
ORA-06512: at "APEX_220200.WWV_FLOW_WEB_SERVICES", line 1490
ORA-06512: at "APEX_220200.WWV_FLOW_WEBSERVICES_API", line 612
ORA-06512: at "APEX_220200.WWV_FLOW_PRINT_UTIL", line 789
ORA-06512: at "APEX_220200.WWV_FLOW_RENDER_QUERY", line 1842
ORA-06512: at "APEX_220200.WWV_FLOW_RENDER_QUERY", line 1930
ORA-06512: at "APEX_220200.WWV_FLOW", line 2986

and Connor said...

"TNS:no listener" means you reached out to a server/port combination that could ultimately be reached by the database.

This could be one of a number of things

- wrong hostname or port
- hostname could not be resolved by DNS
- firewall blocks access to the host
- you need a proxy

As you can tell, its all about the network here

Rating

(1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

3

A reader, February 13, 2023 - 8:00 am UTC

i am using the free cloud service via oracle.apex.com , so we can not do anything related to the network, the host server was working fine , i think apex team working on some updates or upgrade apex version after that http sever get down !!

February 20, 2023 - 4:18 am UTC

what host are you trying to reach from apex.oracle.com