Re: DBWR, LGWR error in ORACLE 8.0.3.0.6 on Novell 5.0

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Sun, 26 May 2002 16:37:49 GMT
Message-ID: <xb8I8.111227$UV4.203751_at_rwcrnsc54>

You are going to have to call support.
Do you have a backup?
Jim
"sudheer" <y_sudheer_at_rediffmail.com> wrote in message news:51715b1c.0205260206.3767ed84_at_posting.google.com...
> Hi all,
>
> I am working on ORACLE 8.0.3.0.6 on Novell 5.0. Presently
> iam facing the serious problem that when iam doing oraload
> and then orastart instead of starting up the oracle database
> it is showing the error
> oracle database connected.
> ora-00449 -- Background process DBWR, unexpectedly terminated
> with error ora-01092
> ora-01092 -- Oracle instance terminated. Disconnection forced
> and the database server is not getting up.
>
> when i checked the orclDBWR.trc ( my oracle sid is ORCL ) i
> found that it is showing.
>
>

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

&&
> --------------------------------------------------------------------------
---
> Dump file DATA:ORANW803\RDBMS80\trace\ORCLDBWR.TRC
> Fri May 24 15:39:09 2002 -
>
> Oracle8 Release 8.0.3.0.6 - Production (5 User Edition)
> Novell NetWare 5.00h December 11, 1999 SMP is loaded, run mode is SMP (1
CPUs)
> Server Name: EFFTRONICS
> Oracle SID: ORCL
> Instance name: ORCL
> Redo thread mounted by this instance: 1
> Oracle process number: 3
> pid: 191
>
> *** SESSION ID:(2.1) 2002.05.24.15.39.08.000
> error 470 detected in background process
> OPIRIP: Uncaught error 447. Error stack:
> ORA-00447: fatal error in background process
> ORA-00470: LGWR process terminated with error
>

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

&&
>
> And so i have checked the orclLGWR.trc file in which it has a lot of
> junk /addresses written and says internal programming error
>
>
>

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

&&
> --------------------------------------------------------------------------

> Dump file DATA:ORANW803\RDBMS80\trace\ORCLLGWR.TRC
> Sun May 26 15:02:26 2002 -
>
> Oracle8 Release 8.0.3.0.6 - Production (5 User Edition)
> Novell NetWare 5.00h December 11, 1999 SMP is loaded, run mode is SMP (1
CPUs)
> Server Name: EFFTRONICS
> Oracle SID: ORCL
>
> -------- Register Dump -------
>
> Page Fault
> CS = 0008 DS = 0010 ES = 0010 FS = 0010 GS = 0010 SS = 0010
> EAX = 98EFAE30 EBX = 98D432A0 ECX = 98EFB630 EDX = 00040C2A
> ESI = 98EFB630 EDI = 98CCE654 EBP = 98D39398 ESP = 98D39374
> EIP = 9876F75E FLAGS = 00010202
>
> ---- End of Register Dump ----
> Oracle8 Release 8.0.3.0.6 - Production (5 User Edition)
> With the Partitioning and Objects options
> PL/SQL Release 8.0.3.0.2 - Production
> Novell NetWare 5.00h December 11, 1999 SMP is loaded, run mode is SMP (1
CPUs)
> Server Name: EFFTRONICS
> Oracle SID: ORCL
> Instance name: ORCL
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 4
>
> pid: 10e
>
>
> Sun May 26 15:02:26 2002 -
>
> *** SESSION ID:(3.1) 2002.05.26.15.02.26.000
> ----- Call Stack Trace -----
> calling call entry argument values in hex
> location type point (? means dubious value)
> -------------------- -------- -------------------- -----------------------

> skds_fault_resume + 194 ? ksedst 1
> skds_fault_handler + 22 ? skds_fault_resume 9958E6E0 0
> 98185bd1 ? skds_fault_handler 9958E6E0 0
> kccrbl + 5e ? 98185b30
> kccfrd + 1a0 ? kccrbl 98D432A0 206151
98EFB630 1
> 800
> kccroc + a3 ? kccfrd 98D432A0 2E 24 0
98D39438 24
> krcpwnc + 68 ? kccroc 98D39D00 98D39438 9
> kcrrlh + 99 ? krcpwnc 98D39D00 98D39750 9
> kcrfds + 5ff ? kcrrlh 98D39D00 98D397E0
98D39BA4
> 98D399BC
> kcrfsc + 2ca ? kcrfds 1 98D3C304 98D39D00
98D39BA4
> 98D399BC 98D39980
> kcrfot + dc ? kcrfsc 98D39D00 98D39BA4
98D399BC
> 15B6CCF0 1
> kctopn + 316 ? kcrfot 98D39D00 1 98D39BA4
15B6CCF0
> kcttha + 6d ? kctopn
> ksbabs + 1e9 ? kcttha 98D39DBC 10
> ksbrdp + 1cf ? ksbabs 15B6C350
> opirip + 22a ? ksbrdp
> opidrv + 3a0 ? opirip 32 0 0
> sou2o + 9f ? opidrv 32 0 0
> ----- Argument/Register Address Dump -----
> Argument/Register addr=9958e6e0. Dump of memory from 9958E6A0 to 9958E7E0
> 9958E6A0 00000000 00000000 00000005 9958E320 D7D8B8C0 0000010A 00000000
00000000
> 9958E6C0 9861ECE0 00000000 00000000 00000000 00000000 0100190A 9958E000
C8C70F41
> 9958E6E0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00282000
> 9958E700 9876F75E 00010202 98EFAE30 98EFB630 00040C2A 98D432A0 98D39374
98D39398
> 9958E720 98EFB630 98CCE654 98D30010 00000008 00000010 00030010 FC0A0010
98D30010
> 9958E740 00000000 00000000 0000000E 00041FAF 00000003 00000000 98F3BC9E
98D39268
> 9958E760 98D39254 00000000 54464645 494E4F52 00005343 00000000 00000000
00000000
> 9958E780 00000000 00000000 00000000 00000000 00000000 00000000 001F0005
00400004
> 9958E7A0 08010207 01010100 01010100 00000000 00000000 00000000 00000000
00000000
> 9958E7C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
> ............................ and so on on on

 on...............................


> Argument/Register addr=15b6c350.  Dump of memory from 15B6C310 to 15B6C450


> 15B6C300                                     00000000 00000000 00000000

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

&&
> And now the oracle server is not starting up.
> I even tried to start it forcefully giving startup forced.
> but it gave the same problem.
>
> What should i do to solve this. ???
> I HAVE A VERY VERY VERY IMPORTANT DATA IN ORACLE.
>
> pls, some body help me.
>
> thanks in advance for solving my problem.
>
> with best regards,
> Sudheer Y,
> INDIA.
> 15:33 26/may/02 ( IST ).
Received on Sun May 26 2002 - 18:37:49 CEST

This message: [ Message body ]
Next message: Nelson Tong: "Oracle website"
In reply to sudheer: "DBWR, LGWR error in ORACLE 8.0.3.0.6 on Novell 5.0"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message