Solved

PMON failed to acquire latch

Posted on 2010-09-01
4
3,604 Views
Last Modified: 2012-05-10
Have a database running on SLES 9
server:/ # uname -a
Linux server 2.6.16.46-0.12-smp #1 SMP Thu May 17 14:00:09 UTC 2007 x86_64 x86_64 x86_64 GNU/Linux
server:/ # cat /etc/SuSE-release
SUSE Linux Enterprise Server 9 (x86_64)
VERSION = 9
PATCHLEVEL = 1
And we have Oracle:
/opt/u01/app/oracle/admin/prr2/bdump/prr2_mmon_12499.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/u01/app/oracle/product/10.2.0/xyz
System name:      Linux
Node name:      server
Release:      2.6.16.46-0.12-smp
Version:      #1 SMP Thu May 17 14:00:09 UTC 2007
Machine:      x86_64
Instance name: xyz
Redo thread mounted by this instance: 1
Oracle process number: 11
Unix process pid: 12499, image: oracle@nefertari (MMON)

*** 2010-09-01 04:48:32.845
*** SERVICE NAME:(SYS$BACKGROUND) 2010-09-01 04:48:32.830
*** SESSION ID:(178.1) 2010-09-01 04:48:32.830
ktsmgtur(): TUR was not tuned for 2245 secs
ktsmg_advance_slot(): MMNL advances slot after 2245 seconds

When oracle db stops:

Wed Sep  1 04:10:17 2010
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Sep  1 04:10:30 2010
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Sep  1 04:10:42 2010
PMON failed to acquire latch, see PMON dump
PPMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Sep  1 04:10:55 2010
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Wed Sep  1 04:10:58 2010
ALTER DATABASE CLOSE NORMAL

PMON failed to acquire latch, see PMON dump
PMON failed tSat Aug 28 04:10:58 2010
ALTER DATABASE CLOSE NORMAL

Any help would be appreciated.

0
Comment
Question by:edolivier
4 Comments
 
LVL 2

Expert Comment

by:jiruiz
ID: 33584264
Have you see the PMON dump?
0
 
LVL 62

Expert Comment

by:gheist
ID: 33584373
There is a query bot canceled or commited for that long, so self-tuning thread/process stood still for that long.
0
 

Author Comment

by:edolivier
ID: 33587628
I am very new to dba field. How do I see PMON dump?
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 33588828
I've never seen that error in Oracle before, but the log file for PMON (as well as for the other Oracle background processes) should be in your "background_dump_dest" directory.  Where is that on your system?  We don't know.  It depends on how the Oracle install and configuration was done there.

To find out, in SQL*Plus, you can do:
show parameter %dump%

When I do that in one of our test systems (on RedHat Linux) I get this output:

NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------
background_core_dump                 string      partial
background_dump_dest                 string      /var/trace/system
core_dump_dest                       string      /var/trace/core
max_dump_file_size                   string      UNLIMITED
shadow_core_dump                     string      PARTIAL
user_dump_dest                       string      /var/trace/user
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
winscp 000webhost.com 6 73
How to change the nameserver on Ubuntu Server 6 48
oracle collections 2 20
why truncate is faster than delete in oracle ? 4 24
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question