Reproduce the Hang of the Oracle database

What is the Oracle Diagnostic Methodology (ODM )? [ID 312789.1] odm test: query statement: select to_number (addr, 'xxxxxxxxxxxxxxxxxx') from v $ latch_parent where name = 'process allocation '; select name from v $ latch_parent where name like '% library %'; select name from v $ latch_children where name like '% library % '; select name from v $ latch_parent where name like '% process %'; session A: [oracle @ resoft ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 22:52:42 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select to_number (addr, 'xxxxxxxxxxxxxxxxxxxxxxxx ') from v $ latch_parent where name = 'process allocation '; TO_NUMBER (ADDR, 'xxxxxxxxxxxxxxxxxx') Explain 53666888sql> select pid, program from v $ process; pid program ---------- limit 1 pseudo 2 oracle @ resoft (PMON) 3 oracle @ resoft (PSP0) 4 oracle @ resoft (VKTM) 5 oracle @ resoft (GEN0) 6 oracle @ resoft (DIAG) 7 oracle @ resoft (DBRM) 8 oracle @ resoft (DIA0) 9 oracle @ resoft (MMAN) 10 oracle @ resoft (DBW0) 11 orac Le @ resoft (LGWR) pid program ---------- listen 12 oracle @ resoft (CKPT) 13 oracle @ resoft (SMON) 14 oracle @ resoft (RECO) 15 oracle @ resoft (MMON) 16 oracle @ resoft (MMNL) 17 oracle @ resoft (D000) 18 oracle @ resoft (S000) 19 oracle @ resoft (TNS V1-V3) 20 oracle @ resoft (QMNC) 21 oracle @ resoft (Q000) 22 oracle @ resoft (Q001) pid program -------------------------------------------- -------------- 23 oracle @ resoft (SMCO) 24 oracle @ resoft (VKRM) 25 oracle @ resoft (CJQ0) 26 oracle @ resoft (W000) 27 oracle @ resoft (TNS V1-V3) 28 oracle @ resoft (W001) SQL> oradebug setorapid 2; Oracle pid: 2, Unix process pid: 2770, image: oracle @ resoft (PMON) SQL> oradebug suspend; Statement processed. at this time, you can still log on to [oracle @ resoft ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:01:31 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionssession A: SQL> oradebug call kslgetl 536896888 1; Function returned 1 at this time, you cannot use any user to log on. [Oracle @ resoft ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:03:37 2013 Copyright (c) 1982,201 1, Oracle. All rights reserved .... Release Method: reconnect a session B: [oracle @ resoft ~] $ Sqlplus-prelim/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:14:39 2013 Copyright (c) 1982,201 1, Oracle. All rights reserved. [oracle @ resoft ~] $ Sqlplus-prelim/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:19:47 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. SQL> shutdown abort; ORACLE instance shut down. SQL> startupORACLE instance started. ORA-01012: not logged onProcess ID: 0 Session ID: 0 Serial number: 0 close all sessions, including the connected shell, close the shell terminal connection or command window. Reconnect to the database [oracle @ resoft ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:23:45 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to an idle instance. SQL> startupORACLE instance started. total System Global Area 845348864 bytesFixed Size 1348216 bytesVariable Size 595594632 bytesDatabase Buffers 243269632 bytesRedo Buffers 5136384 bytesDatabase mounted. database opened. database hang Information collection: [oracle @ resoft ~] $ Sqlplus-prelim/as sysdbaSQL * Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:29:27 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. SQL> oradebug setmypid; Statement processed. SQL> oradebug dump systemstate 266; Statement processed. SQL> oradebug tracefile_name/u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_4889.trc the next thing to do is to analyze and toss the database...