OraFAQ Forum: General

Home » Other » General » ORA -24247

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA -24247 [message #468346]

Thu, 29 July 2010 16:12

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

Report message to a moderator

Re: ORA -24247 [message #468349 is a reply to message #468346]

Thu, 29 July 2010 16:32

John Watson
Messages: 8962
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.

Report message to a moderator

Re: ORA -24247 [message #468350 is a reply to message #468349]

Thu, 29 July 2010 17:14

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/

Report message to a moderator

Re: ORA -24247 [message #468503 is a reply to message #468349]

Fri, 30 July 2010 05:50

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

Report message to a moderator

Re: ORA -24247 [message #468506 is a reply to message #468346]

Fri, 30 July 2010 06:47

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Version - 10.2.0

really?

Report message to a moderator

Re: ORA -24247 [message #468507 is a reply to message #468506]

Fri, 30 July 2010 06:54

OraclePTDBA
Messages: 5
Registered: July 2010
Location: Hyderabad

Junior Member

yes!!

Report message to a moderator

Re: ORA -24247 [message #468511 is a reply to message #468507]

Fri, 30 July 2010 07:22

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>

Report message to a moderator

Re: ORA -24247 [message #468513 is a reply to message #468511]

Fri, 30 July 2010 07:32

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

Report message to a moderator

Re: ORA -24247 [message #468518 is a reply to message #468513]

Fri, 30 July 2010 08:51

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?

Report message to a moderator

Re: ORA -24247 [message #468562 is a reply to message #468518]

Fri, 30 July 2010 12:13

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

I didn't think ACLs existed with 10g. Are both your databases are the same version?

Report message to a moderator

Re: ORA -24247 [message #468565 is a reply to message #468562]

Fri, 30 July 2010 12:35

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

Report message to a moderator

Re: ORA -24247 [message #468569 is a reply to message #468565]

Fri, 30 July 2010 12:50

John Watson
Messages: 8962
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 04:29:16 CST 2024