Solved

PMON failed to acquire latch

Posted on 2010-09-01
4
3,753 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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 video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

621 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