Skip to main content

Process m000 died, see its trace file



Alert Log:

[oracle@ bdump]$ view alert_HDRTG12.log
Thu May 28 22:05:42 PDT 2015
Process P021 died, see its trace file
Thu May 28 22:05:47 PDT 2015
Process m000 died, see its trace file
Thu May 28 22:05:47 PDT 2015
ksvcreate: Process(m000) creation failed
Thu May 28 22:06:00 PDT 2015
Process P021 died, see its trace file
Thu May 28 22:06:10 PDT 2015
Process P021 died, see its trace file
Thu May 28 22:06:43 PDT 2015

[oracle@bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Thu May 28 23:38:59 2015

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------------------------
HDRTG12

SQL> select * from v$resource_limit where RESOURCE_NAME in ('sessions','processes','transactions');


RESOURCE_NAME    CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION   LIMIT_VALUE
-------------    ------------------ --------------- ------------------- ------------
processes                      28              50         50              50
sessions                       31              62        100              100
transactions                  248             327        110           UNLIMITED


CAUSE: One of the reasons for the above errors is when the no of process exceeds.


SOLUTION: Is to increase the PROCESSES parameter value.

SQL> alter system set processes=100 scope=spfile;

System altered.

NOTE: Increasing processes parameter increases the amount of shared memory that needs to be reserved & the OS must be configured to support the larger amount of shared memory. So here we first need to increase the Memory & SGA to increase the process, sessions & transaction parameters.


Thank You!




Comments

Popular posts from this blog

ORA-28007: THE PASSWORD CANNOT NE REUSED

             - Here will see how to deal with  => ORA-28007: the password cannot be reused -  I got a request from client user, stating his account has been locked. When I check the status of the account I found the below. connect to SYS user & execute the below query of that database. SQL> select password,username,account_status,profile from dba_users where username='TEST'; PASSWORD               USERNAME   ACCOUNT_STATUS                 PROFILE ------------------             ----------------  -------------------------------           -------------------- AB2Aa8AC9971521e3     TEST       EXPIRED(GRACE)&LOCKED    NONAPP_USERS So, then I have unlocked the account and checked the same again & I found the below results. ...

CHANGING DBID FOR ORACLE DATABASE 11G

C:\Users\computer>sqlplus SQL*Plus: Release 11.1.0.7.0 - Production on Thu Sep 10 21:03:33 2013 Copyright (c) 1982, 2008, Oracle.  All rights reserved. Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select dbid from v$database;       DBID ---------- 2188161033 SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options C:\Users\computer>nid DBNEWID: Release 11.1.0.7.0 - Production on Thu Sep 10 21:04:44 2013 Copyright (c) 1982, 2007, Oracle.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET ...