Error 2103 Oracle
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog oracle terminating the instance due to error 2103
ORA-00494 enqueue [CF] held forOra-00239
too long tips Oracle Database Tips by Burleson Consulting August 8, 2015 Question: I am getting an ORA-00494 error and
Ora-00494: Enqueue [cf] Held For Too Long
the trace file. This error causes my database to crash:. ORA-00494: enqueue [CF] held for too long /u01/app/oracle/admin/mysid/bdump/ora_lgwr_143.trcKilling enqueue blocker (pid=152) on resourceCF-00000000-00000000 by killing session 83.0 What is the cure for this
Ora-239
ORA-00494 error? Answer: The oerr utility shows this on the ORA-00494 ORA-00494: enqueue string held for too long (more than string seconds) by 'inst string, osid string' Cause: The specified process did not release the enqueue within the maximum allowed time.Action: Reissue any commands that failed and contact Oracle Support Services with the incident information. The ORA-00494 error occurs during periods of super-high stress, activity to the ora-00240 point there the server becomes unresponsive due to overloaded disk I/O, CPU or RAM. See MOSC Note ID 779552.1 "ORA-00494 During High Load After 10.2.0.4 Upgrade" says that Oracle kills blocking processes during periods of high DML load and issues the ORA-00494 error. In your case, it is the log writer process. Also see Database Crashes With ORA-00494 [MOSC Note ID 753290.1 Solutions for ORA-00494: Resize online redo logs Spread-out the DML over longer periods Adjust several hidden parameters: Two Oracle database hidden parameters can be reconfigured to prevent further incident happens by the same cause - Oracle Kill Blocker Interface mechanism: 1) _kill_controlfile_enqueue_blocker = { TRUE | FALSE } TRUE. Default value. Enables this mechanism and kills blocker process in CF enqueue. FALSE. Disables this mechanism and no blocker process in CF enqueue will be killed. 2) _kill_enqueue_blocker = { 0 | 1 | 2 | 3 } 0. Disables this mechanism and no foreground or background blocker process in enqueue will be killed. 1. Enables this mechanism and only kills foreground blocker process in enqueue while background process is not affected. 2. Enables this mechanism and only kills background blocker process in enqueue. 3. Default
Sign in Expand/collapse global hierarchy Home Aleph Knowledge Articles Expand/collapse global location ORA-00494: enqueue [CF] held for too long (more than 900 seconds) Last updated 09:10, 9 Dec 2015 minact-scn: useg scan erroring out with error e:12751 Save as PDF Share Share Share Tweet Share No headers Article ora-12751: cpu time or run time policy violation Type: General Product: Aleph Product Version: 18.01 Description:We were down this morning. We were able to bring 00494 country code the system up but want to know how we can preventthis Oracle error {"ORA-00494: enqueue [CF] held for too long (more than 900 seconds)"} from bringing our system http://www.dba-oracle.com/t_ora_00494_euqueue_cf_held_for_too_long.htm down. Oracle alert log:Wed Jan 27 15:10:55 2010Thread 1 advanced to log sequence 1083 (LGWR switch) Current log# 3 seq# 1083 mem# 0: /ora01/oradata/aleph0/aleph0_redo03.logWed Jan 27 22:16:59 2010Errors in file /exlibris/app/oracle/admin/aleph0/bdump/aleph0_arc1_31636.trc:ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 31585'Wed Jan 27 22:17:00 2010Errors in file /exlibris/app/oracle/admin/aleph0/bdump/aleph0_arc0_31634.trc:ORA-00494: enqueue [CF] held for https://knowledge.exlibrisgroup.com/Aleph/Knowledge_Articles/ORA-00494%3A_enqueue_%5BCF%5D_held_for_too_long_(more_than_900_seconds) too long (more than 900 seconds) by 'inst 1, osid 31585'Wed Jan 27 22:17:07 2010System State dumped to trace file /exlibris/app/oracle/admin/aleph0/bdump/aleph0_arc1_31636.trcWed Jan 27 22:17:08 2010Killing enqueue blocker (pid=31585) on resource CF-00000000-00000000 by killing session 165.1Killing enqueue blocker (pid=31585) on resource CF-00000000-00000000 by terminating the processWed Jan 27 22:17:08 2010Killing enqueue blocker (pid=31585) on resource CF-00000000-00000000ARC0: terminating instance due to error 2103Wed Jan 27 22:17:13 2010Termination issued to instance processes. Waiting for the processes to exitWed Jan 27 22:17:19 2010Instance termination failed to kill one or more processesInstance terminated by ARC0, pid = 31634Resolution:Metalink note: "Database Crashes With ORA-00494 [ID 753290.1] describes the following"Cause:The lgwr has killed the ckpt process, causing the instance to crash.From the alert.log we can see:That the database has waited too long for a CF enqueue, so the following error has been reported.ORA-00494: enqueue [CF] held for too long (more than 900 seconds) by 'inst 1, osid 38356'Then the LGWR has killed the blocker, which was in this case the CKPT process which cau
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications http://dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=52700 Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | No question at this time error 2103 DBA Top 10 1 M. Cadot 37400 2 F. Diaz 33800 3 J. Schnackenberg 18400 4 A. Kavsek 16050 5 B. Vroman 15850 6 P. Wisse 14750 7 T. Boles 14400 8 M. Hidayathullah ... 11500 9 A. Hudspith 8600 10 A. Khan 4400 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as error 2103 oracle RSS feed Site StatisticsEver registered users47779Total active users2112Act. users last 24h16Act. users last hour1Registered user hits last week612Registered user hits last month6457 Go up instance crash Next thread: Upgrade RAM with motherboard for 1 of 11gr2 node Prev thread: FTP connection refused Message Score Author Date Hi Guys, Memory Spec:
Linux:oracle:DBNA...... Tso P Jul 12, 2012, 08:28 Hi, >>Instance terminated by ARC0, pid = 13985 ...... Tarun Biswas Jul 12, 2012, 08:41 [Content removed due to copyright violation. Pleas...... Tarun Biswas Jul 12, 2012, 08:46 Actually, ARC tried to get a lock on control fil...... Michel Cadot Jul 12, 2012, 08:55 @Tarun Biswas It is illegal to copy and paste...... Michel Cadot Jul 12, 2012, 09:02 By the way, it is Metalink/MOS note "ORA-00494 O...... Michel Cadot Jul 12, 2012, 09:11 Yes , I have copied from Metalink as sometime peop...... Tarun Biswas Jul 12, 2012, 09:16 Thanks guys for the replies... How do I find ou...... Tso P Jul 12, 2012, 09:34 How do I find out know who was pid 9520?