Oracle error of the Process (m000) creation failed

2011-03-08  来源:本站原创  分类:Database  人气:133 

Reflect a development of the database developers have problems, can not connect, log in to the background check alert log

Quote

Tue Mar 8 07:49:09 2011
Process m000 died, see its trace file
Tue Mar 8 07:49:09 2011
ksvcreate: Process (m000) creation failed
Tue Mar 8 07:50:10 2011
Process m000 died, see its trace file
Tue Mar 8 07:50:10 2011
ksvcreate: Process (m000) creation failed
Tue Mar 8 07:51:11 2011
Process m000 died, see its trace file
Tue Mar 8 07:51:11 2011
ksvcreate: Process (m000) creation failed
[Ora10g @ localhost bdump] $ tail-f alert_xe.log
Tue Mar 8 08:48:11 2011
ksvcreate: Process (m000) creation failed
Tue Mar 8 08:49:12 2011
Process m000 died, see its trace file
Tue Mar 8 08:49:12 2011
ksvcreate: Process (m000) creation failed
Tue Mar 8 08:50:13 2011
Process m000 died, see its trace file
Tue Mar 8 08:50:13 2011
ksvcreate: Process (m000) creation failed

You can see the m000 process creation fails, PMON process can not start the process. Under normal circumstances, PMON can not start the process for three reasons: 1, Oracle limits the number of connections over the process. 2, the process deadlocks. 3, bug
Connect to the database using sqlplus only appears Connected. State.

Quote

[Ora10g @ localhost ~] $ sqlplus "/ as sysdba"

SQL * Plus: Release 10.2.0.4.0 - Production on Tue Mar 8 08:48:34 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected.
SQL> exit
Disconnected

LOCAL = NO then check the connections and found that the process has reached its limit

Quote

[Ora10g @ localhost ~] $ ps-ef | grep LOCAL | wc-l
129
SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
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 150

You can see alert log errors, it is precisely because Oracle has reached a limit process, and then PMON process can not create m000

相关文章
  • Oracle error of the Process (m000) creation failed 2011-03-08

    Reflect a development of the database developers have problems, can not connect, log in to the background check alert log Quote Tue Mar 8 07:49:09 2011 Process m000 died, see its trace file Tue Mar 8 07:49:09 2011 ksvcreate: Process (m000) creation f

  • Listener listener oracle error 1067: The process terminated unexpectedly 2010-12-10

    Today encountered a problem: oracle in OracleOraHome10gTNSListener service will not start now, and Before you can start, and now starts an error: The local computer does not start OracleOraHome10gTNSListener service. Message is "Error 1067: The proce

  • Oracle 10g listener can not start, it says "Error 1067: The process terminated unexpectedly" 2010-10-09

    In the "services" to start Oracle 10g listener, prompt a warning message: On the local computer does not start OracleOraDb10_home2TNSListener service. Error 1067: The process terminated unexpectedly.

  • Listener listener oracle error 1067: process terminated unexpectedly 2010-12-10

    Encountered a problem today: oracle of OracleOraHome10gTNSListener services are now not start, and Can be normal before the start, it starts a error: can not start OracleOraHome10gTNSListener local computer services. Message is "Error 1067: The proce

  • Oracle 10g listener can not start, "Error 1067: The process terminated unexpectedly." 2010-10-09

    In the "Service" to start Oracle 10g listener, prompt a warning message: In the local computer does not start OracleOraDb10_home2TNSListener service. Error 1067: The process terminated unexpectedly.

  • Oracle Error Code List 2010-06-03

    Oracle error code list, to facilitate all inquiries! (More words, can not release all of the rest in one floor, the sofa) ORA-00001: unique constraint violation (.) ORA-00017: session requested to set trace event ORA-00018: exceeded maximum number of

  • ORACLE error message 2010-06-12

    00000,0, " Normal, complete success " 00001,0, " There are duplicate key index " 00017,0, " Request for a dialogue to set up accident " 00018,0, " Exceed the maximum number of sessions " 00019,0, " Exceed the m

  • Oracle Error List (1) 2010-07-31

    ORA-00001: unique constraint violation (.) ORA-00017: session request to set the track events ORA-00018: exceeded maximum number of sessions ORA-00019: exceeded maximum number of session licenses ORA-00020: exceeded maximum number of processes () ORA

  • Oracle Error List (2) 2010-07-31

    ORA-02201: sequence not allowed here (No.) ORA-02202: this cluster does not allow to add other table ORA-02203: INITIAL storage options not allowed ORA-02204: not allowed ALTER, INDEX and EXECUTE for the view ORA-02205: only SELECT and ALTER privileg

  • Oracle Error List (3) 2010-07-31

    ORA-09751: pw_attachPorts: Server call failed pws_attach ORA-09752: pw_attachPorts: port_allocate failure ORA-09753: spwat: invalid process ID ORA-09754: sppst: the process of sent to sppst invalid number ORA-09755: osngpn: port configuration failed

  • Oracle error code meaning 2010-08-27

    ORA-02001: user SYS is available does not allow to create a list of group index ORA-02002: write error when the trial record leads ORA-02003: invalid USERENV parameter ORA-02004: security breach ORA-02005: implicit (-1) length of the data type defini

  • ORACLE error list (part) 2010-11-04

    ORA-02001: user SYS is not allowed to create a list of group index available orA-02002: Error writing audit trail in mind orA-02003: invalid USERENV parameter orA-02004: security breach orA-02005: implicit (-1) length of the data type definition and

  • Oracle Error Codes - List - 1 2010-12-27

    ORA-00001: unique constraint violation (.) ORA-00017: session requested to set trace event ORA-00018: exceeded maximum number of sessions ORA-00019: exceeded maximum number of session licenses ORA-00020: exceeded maximum number of processes () ORA-00

  • ORACLE error list, we facilitate query! (Reprint) 2011-05-03

    ORACLE error list, we facilitate query! ORA-00001: unique constraint violation (.) ORA-00017: session requested to set trace event ORA-00018: exceeded maximum number of sessions ORA-00019: exceeded maximum number of session licenses ORA-00020: exceed

  • Oracle error code - List - 1 2010-12-27

    ORA-00001: unique constraint violation conditions (.) ORA-00017: session requested to set trace event ORA-00018: exceeded maximum number of sessions ORA-00019: exceeded maximum number of session licenses ORA-00020: exceeded maximum number of processe

  • oracle error code Daquan 2 2010-12-29

    ORA-01200: actual file size is less than the correct size of the block ORA-01201: file header can not be written correctly ORA-01202: wrong prototype for this file - wrong creation time ORA-01203: wrong prototype for this file - wrong creation SCN OR

  • ORACLE error list for everyone to check! 2011-05-03

    ORACLE error list for everyone to check! ORA-00001: unique constraint violation conditions (.) ORA-00017: session requested to set trace event ORA-00018: exceeded maximum number of sessions ORA-00019: exceeded maximum number of session licenses ORA-0

  • On the ora-12505 ORACLE error, and connectivity solutions and related information 2010-03-08

    On the ora-12505 ORACLE error, and connectivity solutions and related information Recently, I use jdbc to connect oracle 9i database, the following error occurred: Error occured while trying to connect to the database Error connecting to database: (u

  • oracle error code Daquan 1 2010-12-29

    Oracle error code list Oracle error code list for everyone to check! (More words, not all of the release, the rest in 1 sofa) ORA-00001: unique constraint violation conditions (.) ORA-00017: session requested to set trace event ORA-00018: exceeded ma

  • oracle error code Daquan 2011-06-20

    Reproduced: http://laoshifu.iteye.com/blog/854617 Oracle error code list Oracle error code list for everyone to check! (More words, not all of the release, the rest in 1 sofa) ORA-00001: unique constraint violation conditions (.) ORA-00017: session r