Database Administration (MOSC)

MOSC Banner

ora 29273 HTTP request failed+ora 12541 no listener error

edited Mar 25, 2019 5:05AM in Database Administration (MOSC) 14 commentsAnswered

Hi

ACL setup correctly as follows

GRANT execute ON UTL_HTTP TO GEO2;

BEGIN

  DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

    host => '*',

    ace  =>  xs$ace_type(privilege_list => xs$name_list('connect', 'resolve', 'http'),

                         principal_name => 'GEO2',

                         principal_type => xs_acl.ptype_db)

   );

END;

/

commit;

BEGIN

  DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE( 

    host => '*',

    ace  =>  xs$ace_type(privilege_list => xs$name_list('connect', 'resolve', 'http'),

                         principal_name => 'GEO2',

                         principal_type => xs_acl.ptype_db)

  );

END;

/

commit;

Task is to run scheduled reports and write to specific directory but failed with the following message(this is showed in logs)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center