Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Production database Hangs

poornaJan 19 2012 — edited Jan 19 2012
Hi,

Oracle Version : 10.2.0.3
Operating system : Linux.

Hi suddenly we are not able to access any tables related to v$ tables and after some time we came to know that there was dead lock in the database and we asked that user to close his connection and every thing is working fine by we are unable to start the Data pump export .

Here is the out put of my alert log file.
Thread 1 advanced to log sequence 81961
  Current log# 2 seq# 81961 mem# 0: /u03/oradata/vsukprod/redo02a.log
  Current log# 2 seq# 81961 mem# 1: /u02/oradata/vsukprod/redo02b.log
Thu Jan 19 02:30:20 2012
System State dumped to trace file /home/oracle/oracle/admin/vsukprod/udump/vsukprod_ora_14070.trc
Thu Jan 19 02:34:02 2012
System State dumped to trace file /home/oracle/oracle/admin/vsukprod/udump/vsukprod_ora_14092.trc
Thu Jan 19 03:06:20 2012
Thread 1 cannot allocate new log, sequence 81962
Private strand flush not complete
  Current log# 2 seq# 81961 mem# 0: /u03/oradata/vsukprod/redo02a.log
  Current log# 2 seq# 81961 mem# 1: /u02/oradata/vsukprod/redo02b.log
Thread 1 advanced to log sequence 81962
  Current log# 1 seq# 81962 mem# 0: /u03/oradata/vsukprod/redo01a.log
  Current log# 1 seq# 81962 mem# 1: /u02/oradata/vsukprod/redo01b.log
Thu Jan 19 03:12:56 2012
Thread 1 cannot allocate new log, sequence 81963
Private strand flush not complete
  Current log# 1 seq# 81962 mem# 0: /u03/oradata/vsukprod/redo01a.log
  Current log# 1 seq# 81962 mem# 1: /u02/oradata/vsukprod/redo01b.log
Thread 1 advanced to log sequence 81963
  Current log# 3 seq# 81963 mem# 0: /u03/oradata/vsukprod/redo03a.log
  Current log# 3 seq# 81963 mem# 1: /u02/oradata/vsukprod/redo03b.log
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:10 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 19 03:31:15 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:31:15 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:31:15 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:33:10 2012
ksvcreate: Process(m000) creation failed
Thu Jan 19 03:35:10 2012
kkjcre1p: unable to spawn jobq slave process 
Thu Jan 19 03:35:10 2012
Errors in file /home/oracle/oracle/admin/vsukprod/bdump/vsukprod_cjq0_3406.trc:

Thu Jan 19 03:36:07 2012
The value (30) of MAXTRANS parameter ignored.
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:39:10 2012
ksvcreate: Process(q002) creation failed
Thu Jan 19 03:40:21 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:41:10 2012
kkjcre1p: unable to spawn jobq slave process 
Thu Jan 19 03:41:10 2012
Errors in file /home/oracle/oracle/admin/vsukprod/bdump/vsukprod_cjq0_3406.trc:

Thu Jan 19 03:41:43 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:45:10 2012
ksvcreate: Process(m000) creation failed
Thu Jan 19 03:45:36 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:47:10 2012
kkjcre1p: unable to spawn jobq slave process 
Thu Jan 19 03:47:10 2012
Errors in file /home/oracle/oracle/admin/vsukprod/bdump/vsukprod_cjq0_3406.trc:

Thu Jan 19 03:49:53 2012
The value (30) of MAXTRANS parameter ignored.
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:51:10 2012
ksvcreate: Process(m000) creation failed
Thu Jan 19 03:53:10 2012
kkjcre1p: unable to spawn jobq slave process 
Thu Jan 19 03:53:10 2012
Errors in file /home/oracle/oracle/admin/vsukprod/bdump/vsukprod_cjq0_3406.trc:

Thu Jan 19 03:56:52 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 03:57:10 2012
ksvcreate: Process(q001) creation failed
Thu Jan 19 03:58:02 2012
Thread 1 cannot allocate new log, sequence 81964
Private strand flush not complete
  Current log# 3 seq# 81963 mem# 0: /u03/oradata/vsukprod/redo03a.log
  Current log# 3 seq# 81963 mem# 1: /u02/oradata/vsukprod/redo03b.log
Thread 1 advanced to log sequence 81964
  Current log# 2 seq# 81964 mem# 0: /u03/oradata/vsukprod/redo02a.log
  Current log# 2 seq# 81964 mem# 1: /u02/oradata/vsukprod/redo02b.log
Thu Jan 19 03:59:10 2012
kkjcre1p: unable to spawn jobq slave process 
Thu Jan 19 03:59:10 2012
Errors in file /home/oracle/oracle/admin/vsukprod/bdump/vsukprod_cjq0_3406.trc:

Thu Jan 19 04:03:10 2012
ksvcreate: Process(m000) creation failed
Thu Jan 19 04:05:05 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 04:05:10 2012
kkjcre1p: unable to spawn jobq slave process 
Thu Jan 19 04:05:10 2012
Errors in file /home/oracle/oracle/admin/vsukprod/bdump/vsukprod_cjq0_3406.trc:

Thu Jan 19 04:06:38 2012
The value (30) of MAXTRANS parameter ignored.
Thu Jan 19 04:07:10 2012
ksvcreate: Process(q001) creation failed
Thu Jan 19 04:11:10 2012
kkjcre1p: unable to spawn jobq slave process 
Thu Jan 19 04:11:10 2012
Errors in file /home/oracle/oracle/admin/vsukprod/bdump/vsukprod_cjq0_3406.trc:

Thu Jan 19 04:13:10 2012
ksvcreate: Process(m000) creation failed
Thu Jan 19 04:13:51 2012
The value (30) of MAXTRANS parameter ignored.
Output for my data pump export.
oracle@virqts4ora001{Primary}:vsukprod:/home/oracle
$ sh /home/oracle/scripts/.EXPORT_GFSPROD.sh

Export: Release 10.2.0.3.0 - Production on Thursday, 19 January, 2012 4:06:38

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Release 10.2.0.3.0 - Production


ORA-31626: job does not exist
ORA-31637: cannot create job GFSPROD112 for user GFS_PROD1
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1193
ORA-39062: error creating master process DM00
ORA-31613: Master process DM00 failed during startup.



oracle@virqts4ora001{Primary}:vsukprod:/home/oracle
$
oracle@virqts4ora001{Primary}:vsukprod:/home/oracle
$
oracle@virqts4ora001{Primary}:vsukprod:/home/oracle
$
Please help me how to solve this problem.

Thanks & Regards,
Poorna Prasad.S
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2012
Added on Jan 19 2012
#general-database-discussions
15 comments
691 views