I have been getting these errors for the last 2 days. In each case the
"freeze" the database so that no new users can log on and existing
connections cannot execute sql. The database version is 9.2.0.8 and the
platform is HP-UX 11.11. Each dump file has text that looks like this:
Dump file
/d20/oracle/product/mbasdb/9.2.0/admin/mbas_mihp2/udump/mbas_ora_18508
.trc
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /d20/oracle/product/mbasdb/9.2.0
System name: HP-UX
Node name: mihp2
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: mbas
Redo thread mounted by this instance: 1
Oracle process number: 504
Unix process pid: 18508, image: oracle_at_mihp2 (TNS V1-V3)
- 2007-06-12 16:11:27.634
- SESSION ID:(620.60298) 2007-06-12 16:11:27.633
LIBRARY OBJECT HANDLE: handle=c00000009b43e750
name=APPS.LA_ENHNCMTMGR_PKG
hash=ad9ae384 timestamp=09-16-2006 20:10:16
namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0000-0000 lock=N pin=S latch#=1
lwt=c00000009b43e780[c00000009b43e780,c00000009b43e780]
ltm=c00000009b43e790[c00
000009b43e790,c00000009b43e790]
pwt=c00000009b43e7b0[c00000009b43e7b0,c00000009b43e7b0]
ptm=c00000009b43e840[c00
000009b43e840,c00000009b43e840]
ref=c00000009b43e760[c00000009b43e760, c00000009b43e760]
lnd=c00000009b43e858[c0
0000009b43e858,c00000009b43e858]
LIBRARY OBJECT: object=c00000000da25860
LOAD LOCK OWNERS:
lock process mode mask
- -------- ---- ------
c0000000d4011878 c00000008255b2a0 X 0011
LOAD LOCK WAITERS:
lock process mode mask
- -------- ---- ------
c000000093506818 c0000000825a91a0 X 0011
c000000093506350 c00000008254ebc0 X 0011
c000000087e15d98 c00000008256f520 X 0011
c0000000d400f950 c0000000825c4500 X 0011
c000000093506c08 c0000000825495c0 X 0011
c0000000d4011bd8 c000000082573b00 X 0011
c0000000d4011a70 c000000082545aa0 X 0011
c000000087e16608 c000000082578640 X 0011
c000000087e162a8 c0000000825b5320 X 0011
mbas_ora_18508.trc (0%)
Anyway to interpret this stuff without filing an SR?
Allan
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 13 2007 - 10:16:31 CDT