OraFAQ Forum: Server Administration » Restarting dead background process QMNC

Home » RDBMS Server » Server Administration » Restarting dead background process QMNC (Oracle 10g, Solaris 5.x)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restarting dead background process QMNC [message #341394]

Mon, 18 August 2008 13:42

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Hi,
I see my alert_log file filled with

Restarting dead background process QMNC

...errors.

Could someone please tell what's going on or how to diagnose this issue?

This is urgent..

Thanks,
Pinky

Report message to a moderator

Re: Restarting dead background process QMNC [message #341395 is a reply to message #341394]

Mon, 18 August 2008 13:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Results 1 - 10 of about 133 for oracle Restarting dead background process

I am sorry to see that GOOGLE is broken for you.
Please wait patiently while repairs are completed.
Additional information will be posted after repairs have been completed.

Report message to a moderator

Re: Restarting dead background process QMNC [message #341396 is a reply to message #341394]

Mon, 18 August 2008 13:55

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing is urgent in forum but reading OraFAQ Forum Guide.

It depends when and how many times this message comes. Note this is not an error message but may be a signal there is a problem if it is frequent.

Regards
Michel

Report message to a moderator

Re: Restarting dead background process QMNC [message #341397 is a reply to message #341395]

Mon, 18 August 2008 13:57

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Anacedent,

I tried to google it first, couldn't find anything, so ended up asking it here.

Thanks for being sarcastic, but it didn't help. Thanks again.

Report message to a moderator

Re: Restarting dead background process QMNC [message #341398 is a reply to message #341396]

Mon, 18 August 2008 14:02

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Michel, when people are in trouble and they just want to get straight to the answer, they naturally end up not reading the guide first, but posting the question. Sorry for that.

But I hope with your responses we would know how to take care of the guidelines.

While looking at the "bdump/dev1_qmnc_2650.trc" file, here's what I saw:

Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
With the Real Application Clusters option
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db
System name:    SunOS
Node name:      dev1000
Release:        5.10
Version:        Generic_127111-11
Machine:        sun4v
Instance name: dev1
Redo thread mounted by this instance: 1
Oracle process number: 37
Unix process pid: 2650, image: oracle@dev1000 (QMNC)

*** 2008-05-28 16:20:04.555
*** SERVICE NAME:(SYS$BACKGROUND) 2008-05-28 16:20:04.553
*** SESSION ID:(125.3) 2008-05-28 16:20:04.553
KSXPLOOKUP: kjxgnqry failed KSXP 720QMNC 8 7

Thanks for your quick turnaround.

Pinky

Report message to a moderator

Re: Restarting dead background process QMNC [message #341399 is a reply to message #341398]

Mon, 18 August 2008 14:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

It depends when and how many times this message comes.

Post 20 lines before up to the message in alert.log.

Regards
Michel

Report message to a moderator

Re: Restarting dead background process QMNC [message #341400 is a reply to message #341399]

Mon, 18 August 2008 14:54

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Here are the last 20 lines of the alert.log

Restarting dead background process QMNC
QMNC started with pid=43, OS id=22606
Mon Aug 18 14:02:49 2008
Restarting dead background process QMNC
QMNC started with pid=98, OS id=24999
Mon Aug 18 14:07:04 2008
Restarting dead background process QMNC
QMNC started with pid=102, OS id=27316
Mon Aug 18 14:11:06 2008
Restarting dead background process QMNC
QMNC started with pid=72, OS id=29575
Mon Aug 18 14:15:21 2008
Restarting dead background process QMNC
QMNC started with pid=115, OS id=1945
Mon Aug 18 14:19:24 2008
Restarting dead background process QMNC
QMNC started with pid=122, OS id=4158
Mon Aug 18 14:23:37 2008
Restarting dead background process QMNC
QMNC started with pid=112, OS id=6456
Mon Aug 18 14:27:49 2008
Restarting dead background process QMNC
QMNC started with pid=38, OS id=8806
Mon Aug 18 14:31:57 2008
Restarting dead background process QMNC
QMNC started with pid=82, OS id=11106
Mon Aug 18 14:36:12 2008
Restarting dead background process QMNC
QMNC started with pid=82, OS id=13450
Mon Aug 18 14:40:24 2008
Restarting dead background process QMNC
QMNC started with pid=54, OS id=15754
Mon Aug 18 14:44:39 2008
Restarting dead background process QMNC
QMNC started with pid=72, OS id=18082
Mon Aug 18 14:48:54 2008
Restarting dead background process QMNC
QMNC started with pid=25, OS id=20426
Mon Aug 18 14:53:04 2008
Restarting dead background process QMNC
QMNC started with pid=49, OS id=22679
Mon Aug 18 14:57:16 2008
Restarting dead background process QMNC
QMNC started with pid=25, OS id=25105
Mon Aug 18 15:01:30 2008
Restarting dead background process QMNC
QMNC started with pid=60, OS id=27442
Mon Aug 18 15:05:42 2008
Restarting dead background process QMNC
QMNC started with pid=99, OS id=29756
Mon Aug 18 15:09:57 2008
Restarting dead background process QMNC
QMNC started with pid=54, OS id=2140
Mon Aug 18 15:14:09 2008
Restarting dead background process QMNC
QMNC started with pid=58, OS id=4471
Mon Aug 18 15:18:22 2008
Restarting dead background process QMNC
QMNC started with pid=101, OS id=6780
Mon Aug 18 15:19:12 200

And it keeps going on, no other errors. Not a sign of what happened before it started dying.

Thanks

Report message to a moderator

Re: Restarting dead background process QMNC [message #341401 is a reply to message #341400]

Mon, 18 August 2008 14:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post 20 lines before the first message.

Regards
Michel

[Updated on: Mon, 18 August 2008 14:57]

Report message to a moderator

Re: Restarting dead background process QMNC [message #341403 is a reply to message #341401]

Mon, 18 August 2008 15:21

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Unfortunately, alert file starts with these errors, I guess due to them being so many, portion of the alert filehas been wiped out.

Report message to a moderator

Re: Restarting dead background process QMNC [message #341404 is a reply to message #341403]

Mon, 18 August 2008 15:32

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure your database is opened.

Regards
Michel

Report message to a moderator

Re: Restarting dead background process QMNC [message #341453 is a reply to message #341404]

Mon, 18 August 2008 21:32

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Yes, my DB is open and running. The only reason I came across this issue was due to slow performance of the DB.

-Pinky

[Updated on: Tue, 19 August 2008 07:31]

Report message to a moderator

Re: Restarting dead background process QMNC [message #341584 is a reply to message #341404]

Tue, 19 August 2008 07:31

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Any thoughts?

Michel?
Mohammed?
Anyone?

Report message to a moderator

Re: Restarting dead background process QMNC [message #341594 is a reply to message #341584]

Tue, 19 August 2008 08:07

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As you remove the insteresting part of alert.log it is hard to say.
I bet you have an ORA-00600 or ORA-07445 somewhere.

Stop and restart the database and post your alert.log then.

Regards
Michel

Report message to a moderator

Re: Restarting dead background process QMNC [message #341630 is a reply to message #341594]

Tue, 19 August 2008 10:51

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

That's exactly what I said, addition of too many errors in the alert file capped off the oldest info, which could lead to some answers. It was not my intention to provide you limited information from the alert file.

However, I was able to restart the whole node and the DB seems to be working fine yesterday.

What else could be done in order to investigate it?

[Updated on: Tue, 19 August 2008 10:52]

Report message to a moderator

Re: Restarting dead background process QMNC [message #341633 is a reply to message #341630]

Tue, 19 August 2008 11:46

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing as the useful information are gone.
Why do you truncate alert.log?
Don't do that; copy the oldest part but do not delete it without a backup.

Regards
Michel

Report message to a moderator

Re: Restarting dead background process QMNC [message #341636 is a reply to message #341630]

Tue, 19 August 2008 12:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>What else could be done in order to investigate it?
metalink note 305662.1 talks all about it.

Are you using streams/RAC?

Report message to a moderator

Re: Restarting dead background process QMNC [message #341665 is a reply to message #341633]

Tue, 19 August 2008 20:15

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

As I expected... Laughing

I never truncated the log. Its just the way its setup I guess. New informationkeeps coming in and the old one goes out.

How can I keep more information in alert log, without it having to kicked out of it?

Thanks Michel

Report message to a moderator

Re: Restarting dead background process QMNC [message #341666 is a reply to message #341636]

Tue, 19 August 2008 20:16

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

I am using RAC.

Thanks for your input.

Report message to a moderator

Re: Restarting dead background process QMNC [message #341675 is a reply to message #341666]

Tue, 19 August 2008 22:49

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

As per Mr.Mahesh Rajendran, Are you using streams?

Provide following output.

1. Show parameter compatible
2. show parameter aq_tm

And check metalink notes 395137.1

Babu

[Updated on: Tue, 19 August 2008 22:51]

Report message to a moderator

Re: Restarting dead background process QMNC [message #341812 is a reply to message #341666]

Wed, 20 August 2008 07:05

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Known bug. Check metalink.

Report message to a moderator

Re: Restarting dead background process QMNC [message #342526 is a reply to message #341675]

Fri, 22 August 2008 11:49

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Babu,
There is no significant detail about the resolution of the problem.

Here is all what it says on the MetaLink DocID you provided.

Edit MC: copyrighted material removed
Don't post Metalink note

[Updated on: Fri, 22 August 2008 11:51] by Moderator

Report message to a moderator

Re: Restarting dead background process QMNC [message #342528 is a reply to message #342526]

Fri, 22 August 2008 11:53

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This note can't help you as you said your database is opened.
Remember I asked this.

Regards
Michel

Report message to a moderator

Re: Restarting dead background process QMNC [message #342529 is a reply to message #341675]

Fri, 22 August 2008 11:55

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

Oops, my bad.

However, here is the restof the info you asked for.

SQL> Show parameter compatible

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      10.2.0.3.0



SQL> show parameter aq_tm

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0

Just to let you now that the problem is long solved, I am just trying to dig down deep to machine the problem out.

Thanks for your help guys!

Pinky

Report message to a moderator

Re: Restarting dead background process QMNC [message #342530 is a reply to message #342528]

Fri, 22 August 2008 11:56

deepmachine
Messages: 80
Registered: August 2008
Location: United States

Member

True,
It was just a copy paste from MetaLink, not MY info.

That is why it's been removed Smile

Thanks
Pinky

Report message to a moderator

Previous Topic:	Oracle 8.1.7 database - Oracle not available
Next Topic:	New instance of OracleXE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 23:16:21 CST 2024