Home » Other » General » ORA -24247
ORA -24247 [message #468346] Thu, 29 July 2010 16:12 Go to next message
OraclePTDBA
Messages: 5
Registered: July 2010
Location: Hyderabad
Junior Member
Hi

Getting this error -

"SQL Execution Error - ORA -24247 network access denied by access control list (ACL)"

Googled the above error but could not find any appropriate answer.Can you please tell what is the error about.

Regards
Re: ORA -24247 [message #468349 is a reply to message #468346] Thu, 29 July 2010 16:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Hello, PTDBA - you didn't give any information on your version of Oracle or what you were trying to do. But if it is 11g and if you were trying to do anything with TCP, you could look at dba_network_acls and dba_network_acl_privileges. Perhaps your database has been configured with fine-grained access control for external network services.
John.
Re: ORA -24247 [message #468350 is a reply to message #468349] Thu, 29 July 2010 17:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: ORA -24247 [message #468503 is a reply to message #468349] Fri, 30 July 2010 05:50 Go to previous messageGo to next message
OraclePTDBA
Messages: 5
Registered: July 2010
Location: Hyderabad
Junior Member
Version - 10.2.0

Error -
"SQL Execution Error , ORA -24247 network access denied by access control list (ACL)"

There is a problem abt DB server EUEOLTD5.AE.XX.COM, schema: NWPS.

When my application NWPS connect to EUEOLTQ5.AE.XX.COM,schema: NWPS_Web, it is running well, but when I connect to EUEOLTD5, the application is not working good. So when I debug the application , found that an update sql can't be executed properly, it executed all the time and can't be stopped.

The query is : UPDATE NEWS_USER_ADMIN SET NEWS_LAST_ACCESSED = SYSDATE WHERE NEWS_SSO_ID ='501186776'

It's a simple query, when connected to EUEOLTQ5, the query can be executed properly but the same when executed in EUEOLTD5 throws me an above error.

Regards
Re: ORA -24247 [message #468506 is a reply to message #468346] Fri, 30 July 2010 06:47 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Version - 10.2.0

really?
Re: ORA -24247 [message #468507 is a reply to message #468506] Fri, 30 July 2010 06:54 Go to previous messageGo to next message
OraclePTDBA
Messages: 5
Registered: July 2010
Location: Hyderabad
Junior Member
yes!!
Re: ORA -24247 [message #468511 is a reply to message #468507] Fri, 30 July 2010 07:22 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
@OraclePTDBA

Run following Query and and copy and paste sql session output.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL>
Re: ORA -24247 [message #468513 is a reply to message #468511] Fri, 30 July 2010 07:32 Go to previous messageGo to next message
OraclePTDBA
Messages: 5
Registered: July 2010
Location: Hyderabad
Junior Member
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Re: ORA -24247 [message #468518 is a reply to message #468513] Fri, 30 July 2010 08:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>It's a simple query, when connected to EUEOLTQ5, the query can be executed properly but the same when executed in EUEOLTD5 throws me an above error.
is there any TRIGGER which sends an email message as a result of this DML?
Re: ORA -24247 [message #468562 is a reply to message #468518] Fri, 30 July 2010 12:13 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I didn't think ACLs existed with 10g. Are both your databases are the same version?
Re: ORA -24247 [message #468565 is a reply to message #468562] Fri, 30 July 2010 12:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/pls/db102/search?remark=quick_search&word=ACL&tab_id=&format=ranked
Re: ORA -24247 [message #468569 is a reply to message #468565] Fri, 30 July 2010 12:50 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Oh, right - I didn't know ACLs were around back with 10g. I first came across them with 11g and controlling access to network resources, implemented with DBMS_NETWORK_ACL_ADMIN. So I wondered if your EUEOLTQ5.AE.XX.COM server was 10g, and your EUEOLTD5.AE.XX.COM server upgraded to 11g.
If its a problem with your XML stuff, I'll sign off.
Previous Topic: How do we verify who has deleted rows from a table ?
Next Topic: Oracle shuts down (PortgreSQL's) open source test servers
Goto Forum:
  


Current Time: Thu Mar 28 13:36:59 CDT 2024