Home » RDBMS Server » Server Administration » connection hang (10.2.0.4 , sun spark 64 bits)
connection hang [message #431145] Sun, 15 November 2009 22:57 Go to next message
halim
Messages: 100
Registered: September 2008
Senior Member

Dears
yesterday our client cannot connect to system because when they
are trying to connect its become hang.
we also try to connect with that database user from sqlplus
it also hang. but we can connect with sys user.
some alert log entry here....
Any help please..

Regards
Halim

Current log# 3 seq# 36771 mem# 0: /d01/oracle/oradata/stlbas/redo03.log
Sun Nov 15 01:02:59 2009
Errors in file /d04/admin/stlbas/bdump/stlbas_j000_28421.trc:
ORA-07445: exception encountered: core dump [ksuklms()+672] [SIGSEGV] [Address not mapped to object] [0x000000062] [] []
Sun Nov 15 01:03:38 2009
Thread 1 advanced to log sequence 36772 (LGWR switch)
  Current log# 4 seq# 36772 mem# 0: /d01/oracle/oradata/stlbas/redo04.log
Sun Nov 15 01:06:10 2009
Thread 1 advanced to log sequence 36773 (LGWR switch)
  Current log# 5 seq# 36773 mem# 0: /d01/oracle/oradata/stlbas/redo05.log
Sun Nov 15 01:08:25 2009
ORA-1688: unable to extend table SYS.WRH$_LATCH_CHILDREN partition WRH$_LATCH__2432247821_10332 by 128 in                 tablespace SYSAUX 
Sun Nov 15 01:09:14 2009
MMON Flush encountered SYSAUX out of space error(1688).
Sun Nov 15 01:09:15 2009
Thread 1 advanced to log sequence 36774 (LGWR switch)
  Current log# 6 seq# 36774 mem# 0: /d01/oracle/oradata/stlbas/redo06.log
Sun Nov 15 01:09:31 2009
MMON (emergency) purge of WR snapshots (10194) and older
Sun Nov 15 01:22:21 2009
Thread 1 advanced to log sequence 36775 (LGWR switch)
  Current log# 7 seq# 36775 mem# 0: /d01/oracle/oradata/stlbas/redo07.log
Sun Nov 15 01:25:20 2009
Errors in file /d04/admin/stlbas/bdump/stlbas_j000_29320.trc:
ORA-07445: exception encountered: core dump [ksuklms()+672] [SIGSEGV] [Address not mapped to object] [0x000000062] [] []
Sun Nov 15 01:27:22 2009
Errors in file /d04/admin/stlbas/bdump/stlbas_j000_29461.trc:
ORA-07445: exception encountered: core dump [ksuklms()+672] [SIGSEGV] [Address not mapped to object] [0x000000062] [] []
Sun Nov 15 01:29:13 2009
Errors in file /d04/admin/stlbas/bdump/stlbas_j000_29549.trc:
ORA-07445: exception encountered: core dump [ksuklms()+672] [SIGSEGV] [Address not mapped to object] [0x000000062] [] []
Sun Nov 15 01:31:07 2009
Errors in file /d04/admin/stlbas/bdump/stlbas_j002_29625.trc:
ORA-07445: exception encountered: core dump [ksuklms()+672] [SIGSEGV] [Address not mapped to object] [0x000000062] [] []
Sun Nov 15 01:31:51 2009
Thread 1 advanced to log sequence 36776 (LGWR switch)
  Current log# 8 seq# 36776 mem# 0: /d01/oracle/oradata/stlbas/redo08.log
Sun Nov 15 01:32:53 2009
Errors in file /d04/admin/stlbas/bdump/stlbas_j000_29709.trc:
ORA-07445: exception encountered: core dump [ksuklms()+672] [SIGSEGV] [Address not mapped to object] [0x000000062] [] []
Sun Nov 15 01:34:46 2009
Thread 1 advanced to log sequence 36777 (LGWR switch)
  Current log# 1 seq# 36777 mem# 0: /d01/oracle/oradata/stlbas/redo01.log
Sun Nov 15 01:37:37 2009
Thread 1 advanced to log sequence 36778 (LGWR switch)
  Current log# 2 seq# 36778 mem# 0: /d01/oracle/oradata/stlbas/redo02.log
Sun Nov 15 01:40:29 2009
-----------------------------
---------------------------
-----------------------
Sun Nov 15 07:48:46 2009
Thread 1 advanced to log sequence 36845 (LGWR switch)
  Current log# 5 seq# 36845 mem# 0: /d01/oracle/oradata/stlbas/redo05.log
Sun Nov 15 08:03:11 2009
Thread 1 advanced to log sequence 36846 (LGWR switch)
  Current log# 6 seq# 36846 mem# 0: /d01/oracle/oradata/stlbas/redo06.log
Sun Nov 15 09:01:58 2009
Thread 1 advanced to log sequence 36847 (LGWR switch)
  Current log# 7 seq# 36847 mem# 0: /d01/oracle/oradata/stlbas/redo07.log
Sun Nov 15 09:03:46 2009
Thread 1 advanced to log sequence 36848 (LGWR switch)
  Current log# 8 seq# 36848 mem# 0: /d01/oracle/oradata/stlbas/redo08.log
Sun Nov 15 09:46:25 2009
Thread 1 advanced to log sequence 36849 (LGWR switch)
  Current log# 1 seq# 36849 mem# 0: /d01/oracle/oradata/stlbas/redo01.log
Sun Nov 15 09:51:46 2009
Timed out trying to start process PC54.
Sun Nov 15 10:05:55 2009
Thread 1 advanced to log sequence 36850 (LGWR switch)
  Current log# 2 seq# 36850 mem# 0: /d01/oracle/oradata/stlbas/redo02.log
Sun Nov 15 10:09:00 2009
Error occured while spawning process PD45; error = 3135
Sun Nov 15 10:09:23 2009
Timed out trying to start process PD88.
Sun Nov 15 10:10:35 2009
Thread 1 advanced to log sequence 36851 (LGWR switch)
  Current log# 3 seq# 36851 mem# 0: /d01/oracle/oradata/stlbas/redo03.log
Sun Nov 15 10:10:51 2009
Timed out trying to start process PH75.
Sun Nov 15 10:11:17 2009
Timed out trying to start process PJ07.
Sun Nov 15 10:11:39 2009
Timed out trying to start process PK13.
Sun Nov 15 10:12:06 2009
Error occured while spawning process PL85; error = 3135
Sun Nov 15 10:12:16 2009
Error occured while spawning process PM56; error = 3135
Sun Nov 15 10:12:41 2009
Timed out trying to start process PO12.
Sun Nov 15 10:12:49 2009
Timed out trying to start process PO57.
Sun Nov 15 10:12:51 2009
Timed out trying to start process PO66.
Sun Nov 15 10:12:52 2009
Timed out trying to start process PO70.
Sun Nov 15 10:12:53 2009
Error occured while spawning process PO78; error = 3135
Sun Nov 15 10:13:08 2009
Error occured while spawning process PB27; error = 3135
Sun Nov 15 10:30:45 2009
Timed out trying to start process PC49.
Sun Nov 15 10:51:04 2009
Thread 1 advanced to log sequence 36852 (LGWR switch)
  Current log# 4 seq# 36852 mem# 0: /d01/oracle/oradata/stlbas/redo04.log
Sun Nov 15 10:52:01 2009
Error occured while spawning process PB34; error = 3135
Sun Nov 15 10:53:09 2009
Error occured while spawning process PC52; error = 3135
Sun Nov 15 10:55:02 2009
Error occured while spawning process PE21; error = 3135
Sun Nov 15 10:55:39 2009
Error occured while spawning process PE71; error = 3135
Sun Nov 15 10:56:56 2009
Error occured while spawning process PG01; error = 3135
Sun Nov 15 10:57:51 2009
Timed out trying to start process PH40.
Sun Nov 15 10:57:59 2009
Timed out trying to start process PH70.
Sun Nov 15 10:58:02 2009
Timed out trying to start process PH76.
Sun Nov 15 10:58:05 2009
Error occured while spawning process PH93; error = 3135
Sun Nov 15 10:59:10 2009
Error occured while spawning process PJ20; error = 3135
Sun Nov 15 10:59:20 2009
Timed out trying to start process PJ30.
Sun Nov 15 10:59:26 2009
Error occured while spawning process PJ38; error = 3135
Sun Nov 15 10:59:35 2009
Error occured while spawning process PJ46; error = 3135
Sun Nov 15 10:59:52 2009
Error occured while spawning process PJ62; error = 3135
Sun Nov 15 11:00:00 2009
Error occured while spawning process PJ76; error = 3135
Sun Nov 15 11:00:10 2009
Error occured while spawning process PB85; error = 3135
Sun Nov 15 11:00:46 2009
Timed out trying to start process PL14.
Sun Nov 15 11:00:47 2009
Error occured while spawning process PL18; error = 3135
Sun Nov 15 11:00:48 2009
Timed out trying to start process PL25.
Sun Nov 15 11:01:47 2009
Error occured while spawning process PN71; error = 3135
Sun Nov 15 11:01:52 2009
Timed out trying to start process PO09.
Sun Nov 15 11:02:27 2009
Timed out trying to start process PP48.
Sun Nov 15 11:02:45 2009
Thread 1 advanced to log sequence 36853 (LGWR switch)
  Current log# 5 seq# 36853 mem# 0: /d01/oracle/oradata/stlbas/redo05.log
Sun Nov 15 11:11:18 2009
Thread 1 advanced to log sequence 36854 (LGWR switch)
  Current log# 6 seq# 36854 mem# 0: /d01/oracle/oradata/stlbas/redo06.log
----------------------
------------------------
WARNING: inbound connection timed out (ORA-3136)
Sun Nov 15 17:12:27 2009
Timed out trying to start process PL54.
Sun Nov 15 17:14:54 2009
Thread 1 advanced to log sequence 36865 (LGWR switch)
  Current log# 1 seq# 36865 mem# 0: /d01/oracle/oradata/stlbas/redo01.log
Sun Nov 15 17:25:22 2009
DEBUG: Replaying xcb 0x7dce08b38, pmd 0x5695b7dd8 for failed op 8
Reconstructing  Uhdr 0x2801791 for xcb 0x7dce08b38, pmd 0x5695b7dd8
Doing block recovery for file 10 block 6033
Block recovery from logseq 36865, block 42893 to scn 2207348598
Sun Nov 15 17:25:26 2009
Recovery of Online Redo Log: Thread 1 Group 1 Seq 36865 Reading mem 0
  Mem# 0: /d01/oracle/oradata/stlbas/redo01.log
Block recovery completed at rba 36865.42914.16, scn 0.2207348599
DEBUG: Restoring block headers for xcb 0x7dce08b38, pmd 0x5695b7dd8
DEBUG: Finished replay for xcb 0x7dce08b38, pmd 0x5695b7dd8 for failed op 8
Sun Nov 15 17:26:36 2009
Error occured while spawning process PF17; error = 3135
Sun Nov 15 17:32:51 2009
Thread 1 advanced to log sequence 36866 (LGWR switch)
  Current log# 2 seq# 36866 mem# 0: /d01/oracle/oradata/stlbas/redo02.log
Sun Nov 15 17:42:44 2009
Errors in file /d04/admin/stlbas/udump/stlbas_ora_17465.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Sun Nov 15 17:47:17 2009
Errors in file /d04/admin/stlbas/udump/stlbas_ora_19710.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Sun Nov 15 17:47:38 2009
Thread 1 advanced to log sequence 36867 (LGWR switch)
  Current log# 3 seq# 36867 mem# 0: /d01/oracle/oradata/stlbas/redo03.log
Sun Nov 15 17:55:08 2009
Errors in file /d04/admin/stlbas/udump/stlbas_ora_20478.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Sun Nov 15 18:03:56 2009
Thread 1 advanced to log sequence 36868 (LGWR switch)
  Current log# 4 seq# 36868 mem# 0: /d01/oracle/oradata/stlbas/redo04.log
Sun Nov 15 18:16:50 2009
Timed out trying to start process PD04.
Sun Nov 15 18:16:56 2009
Error occured while spawning process PD20; error = 3135
Sun Nov 15 18:17:10 2009
Error occured while spawning process PD52; error = 3135
Sun Nov 15 18:24:06 2009
Error occured while spawning process PI36; error = 3135
Sun Nov 15 18:25:27 2009
Error occured while spawning process PL85; error = 3135
Sun Nov 15 18:26:41 2009

Re: connection hang [message #431153 is a reply to message #431145] Sun, 15 November 2009 23:19 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>ORA-1688: unable to extend table SYS.WRH$_LATCH_CHILDREN partition WRH$_LATCH__2432247821_10332 by 128 in tablespace SYSAUX

it appears SYSAUX is full

Re: connection hang [message #431160 is a reply to message #431145] Sun, 15 November 2009 23:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: connection hang [message #431169 is a reply to message #431153] Sun, 15 November 2009 23:57 Go to previous messageGo to next message
halim
Messages: 100
Registered: September 2008
Senior Member

Dear BlackSwan

yes we find that sysaux is approximately full but now I increase the SYSAUX and decrease the retention period of snapshots.

Is it possible to hang the connection for SYSAUX Full?

After the restart Database is working but very slow.

Regards
Halim


Re: connection hang [message #431174 is a reply to message #431160] Mon, 16 November 2009 00:10 Go to previous messageGo to next message
halim
Messages: 100
Registered: September 2008
Senior Member

Dear Michel
Our Database was runing very fine. but from yesterday it showing
this error. I cannot change anything in database level. but we
have included an another application before 7 days ago in the
same database.
is it possible to find out whats the problem?

regards
Halim


Re: connection hang [message #431176 is a reply to message #431174] Mon, 16 November 2009 00:48 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anything can be the reason until you determine the root of the error.
Michel Cadot wrote on Mon, 16 November 2009 06:30
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel

Previous Topic: how to upgrade Oracle SES underlying database
Next Topic: Database Instance down
Goto Forum:
  


Current Time: Sat Dec 03 18:05:29 CST 2016

Total time taken to generate the page: 0.14561 seconds