Home » RDBMS Server » Server Administration » Restarting dead background process QMNC (Oracle 10g, Solaris 5.x)
Restarting dead background process QMNC [message #341394] Mon, 18 August 2008 13:42 Go to next message
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
Re: Restarting dead background process QMNC [message #341395 is a reply to message #341394] Mon, 18 August 2008 13:54 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: Restarting dead background process QMNC [message #341396 is a reply to message #341394] Mon, 18 August 2008 13:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Restarting dead background process QMNC [message #341397 is a reply to message #341395] Mon, 18 August 2008 13:57 Go to previous messageGo to next message
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.
Re: Restarting dead background process QMNC [message #341398 is a reply to message #341396] Mon, 18 August 2008 14:02 Go to previous messageGo to next message
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
Re: Restarting dead background process QMNC [message #341399 is a reply to message #341398] Mon, 18 August 2008 14:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Restarting dead background process QMNC [message #341400 is a reply to message #341399] Mon, 18 August 2008 14:54 Go to previous messageGo to next message
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
Re: Restarting dead background process QMNC [message #341401 is a reply to message #341400] Mon, 18 August 2008 14:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.
Re: Restarting dead background process QMNC [message #341404 is a reply to message #341403] Mon, 18 August 2008 15:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you sure your database is opened.

Regards
Michel
Re: Restarting dead background process QMNC [message #341453 is a reply to message #341404] Mon, 18 August 2008 21:32 Go to previous messageGo to next message
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 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
Any thoughts?

Michel?
Mohammed?
Anyone?
Re: Restarting dead background process QMNC [message #341594 is a reply to message #341584] Tue, 19 August 2008 08:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Restarting dead background process QMNC [message #341630 is a reply to message #341594] Tue, 19 August 2008 10:51 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Restarting dead background process QMNC [message #341636 is a reply to message #341630] Tue, 19 August 2008 12:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?
Re: Restarting dead background process QMNC [message #341665 is a reply to message #341633] Tue, 19 August 2008 20:15 Go to previous messageGo to next message
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
Re: Restarting dead background process QMNC [message #341666 is a reply to message #341636] Tue, 19 August 2008 20:16 Go to previous messageGo to next message
deepmachine
Messages: 80
Registered: August 2008
Location: United States
Member
I am using RAC.

Thanks for your input.
Re: Restarting dead background process QMNC [message #341675 is a reply to message #341666] Tue, 19 August 2008 22:49 Go to previous messageGo to next message
babuknb
Messages: 1734
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Known bug. Check metalink.
Re: Restarting dead background process QMNC [message #342526 is a reply to message #341675] Fri, 22 August 2008 11:49 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This note can't help you as you said your database is opened.
Remember I asked this.

Regards
Michel
Re: Restarting dead background process QMNC [message #342529 is a reply to message #341675] Fri, 22 August 2008 11:55 Go to previous messageGo to next message
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
Re: Restarting dead background process QMNC [message #342530 is a reply to message #342528] Fri, 22 August 2008 11:56 Go to previous message
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
Previous Topic: Oracle 8.1.7 database - Oracle not available
Next Topic: New instance of OracleXE
Goto Forum:
  


Current Time: Sun Dec 04 12:54:47 CST 2016

Total time taken to generate the page: 0.04581 seconds