OraFAQ Forum: Networking and Gateways » Help! ORA 0040 and 28511

Home » RDBMS Server » Networking and Gateways » Help! ORA 0040 and 28511 (ORACLE 10 g , DB2 , win XP)

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

Help! ORA 0040 and 28511 [message #278933]

Tue, 06 November 2007 06:10

freakabhi
Messages: 74
Registered: November 2007
Location: mumbai

Member

Hi all....

I need help in one of the Query I am running...

This query is Union query, where...

1) first select clause of which takes data from Oracle

2) second select clause of which takes from DB2 system using
DB link,.....

now,SWITCH_TIME for Oracle where I run the query is set to 12 mins,
but when I run the query sometimes it pops up with the message of ORA-0040: active time limit exceeded...within 3-4 minutes only...this happens about 2 out of 6 times..else query run fine
i.e same query with same condition....

also some time it gives error of ORA: 02086 followed by ORA: 28511 problem from [dblink]... This also happens sometime....

otherwise most of the times query come up with data....
same query with same parameters...

HOW is this possible.......?????
Please give some suggestions

Report message to a moderator

Re: Help! ORA 0040 and 28511 [message #278939 is a reply to message #278933]

Tue, 06 November 2007 06:56

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-00040: active time limit exceeded - call aborted
 *Cause:  The Resource Manager SWITCH_TIME limit was exceeded.
 *Action: Reduce the complexity of the update or query, or contact your
          database administrator for more information.

ORA-28511: lost RPC connection to heterogeneous remote agent using SID=%s
 *Cause:  A fatal error occurred in one of the following places:
          -- the connection between the ORACLE server and the agent
          -- the heterogeneous services remote agent itself
          -- the connection to the non-Oracle system
          This error occurred after communication had been established
          successfully.
 *Action: Check for network problems and remote host crashes. The problem is
          probably in the agent software. If so, contact a customer support
          representative of the agent vendor.

Regards
Michel

Report message to a moderator

Re: Help! ORA 0040 and 28511 [message #278963 is a reply to message #278939]

Tue, 06 November 2007 08:08

freakabhi
Messages: 74
Registered: November 2007
Location: mumbai

Member

Thanx michel for reply.....

infact cause of error I did know, but how come same query can
throw 2 different errors same time or runs fine..??

my concern is, why the results are not consistent..???

Report message to a moderator

Re: Help! ORA 0040 and 28511 [message #279001 is a reply to message #278963]

Tue, 06 November 2007 09:41

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The explaination is "Check for network problems and remote host crashes".
Depending on on which step was the query or which underlying error you can have a different error message.

Regards
Michel

Report message to a moderator

Previous Topic:	Ora-12170 Connection time out
Next Topic:	the advantage of tnsnames.ora

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:30:19 CDT 2024