Due To Error Ora-2396
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not
Opidcl Aborting Process Unknown Ospid Due To Error Ora-28
post a blank message. Please type your message and try again. More discussions opidcl aborting process unknown ospid due to error ora-604 in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 8 Replies Latest reply on Apr 6, 2011
Ora-24761
2:11 PM by Arsalan Dehghanisariyarghan ORA-2396 Karan Kukreja Nov 15, 2010 6:03 AM Hi all , Hope everyone had a good weekend.. :) I got this alert in my alert mail : opidcl ora-29904 aborting process unknown ospid (14605_1) due to error ORA-2396 and the trace file had the following details: ********************************************************************* TNS-00505: Operation timed out nt secondary err code: 145 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.xx)(PORT=xxxx)) opidcl aborting process unknown ospid (14605_1) due to error ORA-2396 Wed Dec 23 10:10:22 2009 *********************************************************************** Does it mean a user tried to connect and was unable to connect because ORA-2396 , ora-02396 which comes when "exceeded maximum idle time, please connect again" - from http://ora-02396.ora-code.com/ and in the above error, what does this mean : opidcl aborting process unknown ospid (14605_1) 21578Views Tags: none (add) abortingContent tagged with aborting, opidclContent tagged with opidcl, ora2396Content tagged with ora2396, processContent tagged with process This content has been marked as final. Show 8 replies 1. Re: ORA-2396 CKPT Nov 15, 2010 6:08 AM (in response to Karan Kukreja) I think you have the answer :) Error: ORA 2396 Text: exceeded max Idle Time, please connect again ------------------------------------------------------------------------------- Cause: A user has exceeded the maximum time allowed to remain idle. Action: The user must reconnect to the database. reconnect database again.or you can change in the profile "IDLE_TIME" resource post select resource_name,limit from dba_profiles where resource_name='IDLE_TIME';check http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2007.htm Edited by: CKPT on Nov 15, 2010 11:37 AM 1 person found this helpful Like Show 0 Likes(0) Actions 2. Re: ORA-2396 Karan Kukreja Nov 15, 2010 6:15 AM (in response to Karan Kukreja) Hi CKPT. thanks for immediate response. Could you please elaborate on this : "opidcl aborting process unknown ospid (14605_1)" what is exactly opidcl ? what it seems to me is : (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: ora-2396 exceeded maximum idle time, please connect again SQL Server > Getting started with SQL Server Question 0 Sign in ora 02396 exceeded maximum idle time please connect again to vote Hi All, We have Setup a transactional replication from SQL server 2014 to Oracle. Configured the oracle network client and are able to connect to oracle and query it, even the transactional replication works fine, however after some time if the oracle login (through which we https://community.oracle.com/thread/2131949 have configured the subscriber) remains idle then the connection get's timed out and it generates the above specified error and the replication fails. Any help would be appreciated. Thanks. Edited by Asif_DBA Thursday, August 07, 2014 1:52 PM Thursday, August 07, 2014 1:43 PM Reply | Quote Answers 0 Sign in to vote Can you check the below values? SQL> https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c4282cfc-2e91-4d3b-aa8f-786cc45d656d/ora2396-exceeded-maximum-idle-time-please-connect-again?forum=sqlgetstarted SELECT PROFILE FROM DBA_USERS WHERE USERNAME = 'xyz'; PROFILE ------------------------------ UNLIMITED_PROFILE SQL> SELECT PROFILE, LIMIT FROM DBA_PROFILES WHERE RESOURCE_NAME = 'IDLE_TIME'; PROFILE LIMIT ------------------------------ ---------------------------------------- DEFAULT 90 UNLIMITED_PROFILE UNLIMITED Refer the below link for more information http://docs.oracle.com/html/A85397_01/statem13.htm --Prashanth Proposed as answer by Lydia ZhangMicrosoft contingent staff, Moderator Friday, August 08, 2014 9:16 AM Marked as answer by Asif_DBA Friday, August 08, 2014 10:41 AM Thursday, August 07, 2014 2:14 PM Reply | Quote Answerer All replies 0 Sign in to vote Hello, I have seen so many issues related to the version of Oracle client, that my first suggestion cannot be other but to try a previous version or a newer version of the Oracle client, and drop the publication create it again. Hope this helps. Regards, Alberto Morillo SQLCoffee.com Thursday, August 07, 2014 2:11 PM Reply | Quote Moderator 0 Sign in to vote Can you check the below values? SQL> SELECT PROFILE FROM DBA_USERS WHERE USERNAME = 'xyz'; PROFILE ------------------------------ UNLIMITED_PROFILE SQL> SELECT PROFILE, LIMIT FROM DBA_PROFILES WHERE RESOURCE_NAME = 'IDLE_TIME'; PROFILE LIMIT ------------------------------ ------------------------------- Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management http://businessintelligence.ittoolbox.com/groups/technical-functional/brio-l/ora02396-exceeded-maximum-idle-time-please-connect-again-535872 SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS http://oracle-latest-technology.blogspot.com/2013/11/opidcl-aborting-process-unknown-ospid.html Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM PCMag maxwellarnold I_am_the_dragon Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate DukeGanote Craig Borysowich Dennis Stevenson Richard mircea_luca Nikki Klein AbhaiTripathi knowscognosdoi due to Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Webroot Dell Software Oracle Service Max View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Brio Software For discussion on Brio Software , please visit the Business Intelligence - General Discussions group. More Business Intelligence Groups Your account is ready. You're now being signed due to error in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-02396: exceeded maximum idle time, please connect again .. martyyn asked Aug 24, 2004 | Replies (1) We have a job scheduled that does many things and a small change has been made and the query resubmitted to the BCS. However we are now getting the following error.... ---- ORA-02396: exceeded maximum idle time, please connect again Error in process. Warning: Oracle Error 2396: ORA-02396: exceeded maximum idle time, please connect again .. Oracle Error 2396: ORA-02396: exceeded maximum idle time, please connect again .. Error in closing the document. Job-Ltdw-2835: Completed at 08/24/04 02: have encountered the following error message. opidcl aborting process unknown ospid (12874_47230856307152) due to error ORA-28 Solution It seems this issue is fixed in 11.2.0 version. For other version you need to apply a small patch. The details of this patch and this issue is written in the following metalink document. The patch link is also mentioned in this document. "Bug 6377339 - Misleading alert log message for "opiodr aborting" (Doc ID 6377339.8)" Labels: Database Issues No comments : Post a Comment Previous Next Home Subscribe to: Post Comments ( Atom ) Search This Blog ADF Apps DBA Apps DBA Issues Apps DBA Tutorial BPEL/ESB/SOA Database Issues Database Tutorial OA Framework oracle performance tuning Webcenter Suite Workflow Popular Posts Step by step Oracle Apps R12.1.3 Rapid Cloning How to apply patch in Oracle Apps R12.2 A step by step guide libXtst.so.6 cannot open shared object file error during Oracle Installation How to send Notification using Oracle Workflow Step by step guide for creating Disaster Recovery site for Oracle Apps R12 How to Start Background Engines of Oracle Workflow in R12.1.1 Oracle Apps DBA Health Checkup and performance scripts Part 2 Details Oracle Apps Auditing and performance check ORA-10173 Dynamic Sampling time out error Apps DBA Tutorial 01 - Concurrent Manager What to do if a worker fails during adpatch application on R12 Recent Posts tag cloud ADF ( 8 ) Apps DBA ( 40 ) Apps DBA Issues ( 11 ) Apps DBA Tutorial ( 16 ) BPEL/ESB/SOA ( 3 ) Database Issues ( 4 ) Database Tutorial ( 24 ) OA Framework ( 2 ) oracle performance tuning ( 3 ) Webcenter Suite ( 3 ) Workflow ( 3 ) Blog Archive 2014 ( 7 ) October ( 1 ) September ( 2 ) August ( 2 ) March ( 1 ) February ( 1 ) 2013 ( 24 ) December ( 2 ) November ( 4 ) How to delete tempfile in temporary tablespace in ... How to Disable all scheduled Concurrent Request in... How to use Logminer to analyze the archive log opidcl aborting process unknown ospid (xxxx_xxxxxx... September ( 3 ) August ( 7 ) May ( 1 ) April ( 1 ) March ( 3 ) February ( 2 ) January ( 1 ) 2012 ( 16 ) December ( 1 ) August ( 3 ) July ( 3 ) May ( 2 ) March ( 1 ) February ( 4 ) January ( 2 ) 2011 ( 49 ) December ( 13 ) October ( 1 ) June ( 4 ) May ( 1 ) April ( 4 ) March ( 10 ) February ( 8 ) January ( 8 ) 2010 ( 16 ) December ( 3 ) April ( 2 ) February ( 11 ) Followers Popular Posts Step by step Oracle Apps R12.1.3 Rapid Cloning Prerequisite Steps 1. If your target seOra-19624
Ora-609