Home » RDBMS Server » Networking and Gateways » Help! ORA 0040 and 28511 (ORACLE 10 g , DB2 , win XP)
Help! ORA 0040 and 28511 [message #278933] Tue, 06 November 2007 06:10 Go to next message
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

Re: Help! ORA 0040 and 28511 [message #278939 is a reply to message #278933] Tue, 06 November 2007 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64110
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
Re: Help! ORA 0040 and 28511 [message #278963 is a reply to message #278939] Tue, 06 November 2007 08:08 Go to previous messageGo to next message
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..???


Re: Help! ORA 0040 and 28511 [message #279001 is a reply to message #278963] Tue, 06 November 2007 09:41 Go to previous message
Michel Cadot
Messages: 64110
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
Previous Topic: Ora-12170 Connection time out
Next Topic: the advantage of tnsnames.ora
Goto Forum:
  


Current Time: Mon Dec 05 10:56:01 CST 2016

Total time taken to generate the page: 0.07265 seconds