++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please Read The Disclaimer At The Bottom Of This Email ++++++++++++++++++++++++++++++++++++++++++++++++++++++
Hi, It has been a while, but I remember similar issue where the DB link connection closed after a certain period of inactivity. When a query ran after the link/session was closed, we were getting similar error message. The way around it was to run a dummy query just before performing the real query. Hope this will be of some help. Jiri Pospisil LCH.Clearnet<http://www.lchclearnet.com/> From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of William Rentfrow Sent: 18 August 2009 19:32 To: [email protected] Subject: ARERR 552 - Database link is not open ** We are doing an upgrade - as part of that we're porting a stored procedure to the new db instance. The DBA can login as ARAdmin and execute this stored procedure as expected. However, when we do the exact same command from workflow (filter Run Process) we get this along with the ARERR 552: *** ERROR *** ORA-02081: database link is not open ORA-06512: at "ARADMIN.V_EMP_NEW", line 50 ORA-02081: database link is not open ORA-06512: at line 1 Any guesses? Again this works for the DBA as user ARAdmin. William Rentfrow Principal Consultant, StrataCom Inc. [email protected]<mailto:[email protected]> Corporate Website, www.stratacominc.com<http://www.stratacominc.com/> Blog, www.williamrentfrow.com<http://www.williamrentfrow.com/> 715-410-8156 C _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ************************************************************************************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify [email protected]. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com ************************************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
