10 Replies Latest reply: Feb 14, 2013 3:52 AM by Step_Into_Oracle_DBA RSS

    background process qmnc

    949210
      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
      PL/SQL Release 10.2.0.1.0 - Production
      "CORE     10.2.0.1.0     Production"
      TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
      NLSRTL Version 10.2.0.1.0 - Production
      on windows server 2003
      the alert log shows the following every minute
      ksvcreate: Process(m000) creation failed
      Thu Feb 14 00:09:04 2013
      Restarting dead background process QMNC
      QMNC started with pid=16, OS id=2012
      Thu Feb 14 00:09:56 2013
      sho parameter processes
      aq_tm_processes                                    integer     0                                                                                                    
      db_writer_processes                                integer     1                                                                                                    
      gcs_server_processes                               integer     0                                                                                                    
      job_queue_processes                                integer     10                                                                                                   
      log_archive_max_processes                          integer     2                                                                                                    
      processes                                          integer     300        
      please advise the cause and solution/s to this
      thank you

      Edited by: 946207 on Feb 14, 2013 4:32 AM
        • 1. Re: background process qmnc
          sb92075
          There should be a _qmnc trace file created in your bdump. DO you have one and does it contain anything?                                                                                                                                                                                                               
          • 2. Re: background process qmnc
            asahide
            Hi,

            Can you check this note?
            PROCESS J000 And M000 Die [ID 790397.1]
            <<https://support.oracle.com/epmos/faces/DocumentDisplay?_&id=790397.1>>

            Regards,
            • 3. Re: background process qmnc
              949210
              i do not see an _qmnc file in the bdump location after a search

              Edited by: 946207 on Feb 14, 2013 5:13 AM
              • 4. Re: background process qmnc
                949210
                a system wide search did not result in any file by this name
                search term=*qm*
                is the information being written to some other file
                ?
                • 5. Re: background process qmnc
                  Osama_Mustafa
                  Check MOS note
                  Troubleshooting Guide (TSG) - ksvcreate: Process(xxxx) creation failed / ORA-00445: background process "xxxx" did not start after n seconds [ID 1379200.1]
                  • 6. Re: background process qmnc
                    Aman....
                    This is the definition of this process.
                    http://docs.oracle.com/cd/E11882_01/server.112/e11013/glossary.htm#ADQUE3596

                    Check out the MOS doc id mentioned by Osama. That should help.

                    Aman....
                    • 7. Re: background process qmnc
                      Step_Into_Oracle_DBA
                      the alert log shows the following every minute
                      ksvcreate: Process(m000) creation failed
                      Hi,

                      Looks like database is running out of memory defined at the database level.

                      1) Check server ram size and sga max size. (Reduce the value of SGA if its more than 2 GB)
                      2) At the time error occurs check oracle.exe for how much memory it takes.
                      3) In 32 bit windows environment, oracle.exe will not take more than 2 gb. (Options available to set 3 GB also)
                      4) As database process is 300, check whether database i reaching this limit.

                      Mark your Post as Answered or Helpful if Your question is answered.

                      Thanks & Regards,
                      SID

                      (StepIntoOracleDBA)

                      Email : stepintooracledba@gmail.com

                      http://stepintooracledba.blogspot.in/

                      http://www.stepintooracledba.com/
                      • 8. Re: background process qmnc
                        949210
                        i referred
                        http://docs.oracle.com/cd/E11882_01/server.112/e24448/bgprocesses.htm
                        http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams008.htm
                        aq_tm_processes integer 0
                        there is no streams setup
                        • 9. Re: background process qmnc
                          949210
                          this is an x64 operating system
                          the following query
                          select length(addr)*4 || '-bits' word_length from v$process where rownum=1;
                          returns 32 bits
                          sho parameter sga
                          sga_max_size                                       big integer 3G                                                                                                   
                          sga_target                                         big integer 2504M        
                          the oracle*32.exe shows 2638640K

                          Edited by: 946207 on Feb 14, 2013 3:17 PM
                          • 10. Re: background process qmnc
                            Step_Into_Oracle_DBA
                            You can try your chance by reducing SGA_maX_SIZE from 3g to 2.5GB. I hope its because of the memory leak in windows systems. If reducing SGA doesnt seems to help then please create a SR and check with Oracle Support.


                            Mark your Post as Answered or Helpful if Your question is answered.

                            Thanks & Regards,
                            SID

                            (StepIntoOracleDBA)

                            Email : stepintooracledba@gmail.com

                            http://stepintooracledba.blogspot.in/

                            http://www.stepintooracledba.com/