Database Administration (MOSC)

MOSC Banner

ACL error ORA-29273,ORA-06512,ORA-12541

edited Jan 4, 2017 2:06AM in Database Administration (MOSC) 5 commentsAnswered


Hi

I  have newly created  wallet in one of our environments , imported the certificate given by the developer . Import was successful.

Later created acl like below .

begin

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'UTL_HTTP.xml', description=>'UTL_HTTP access ', principal=> 'CCL', is_grant=>TRUE, privilege=>'connect');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'UTL_HTTP.xml',principal => 'CCL', is_grant=>TRUE, privilege=>'resolve');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl=>'UTL_HTTP.xml',host=>'iambccdpqa1.bmogc.net ',lower_port  => 80, upper_port => 7192 );

end;

/

(Since the port mentioned by the developer is 7192  and I was able to telnet to the host with that port I have put the upper_port as 7192. The URL is 

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