Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER DATA BASE OPEN - CREATES AN ORA-03113 ERROR

Re: ALTER DATA BASE OPEN - CREATES AN ORA-03113 ERROR

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 5 Feb 2002 19:03:56 +0100
Message-ID: <u608qg4ctq0h9f@corp.supernews.com>

"NONGLING54" <cnguyen54_at_yahoo.com> wrote in message news:377f269b.0202050817.2a68eb54_at_posting.google.com...
> I had a database problem:
>
> Oracle: 8.1.6.0
> System: Sun Solaris 8.0
>
> Here's the steps I took to get the database running:
>
> 1. svrmgrl> connect internal
>
> 2. svrmgrl>startup pfile="xyz/init.ora" nomount
> - successfull
>
> 3. svrmgrl> alter database mount
> - successfull
>
> 4. svrmgrl> recover database
> - successfull
>
> 5. svrmgrl> alter database open;
> - gives error ORA-03113
>
> I looked at the alert.log files and found the following:
>
> error message:
>
> ORA-00600: internal error code, arguments: [kcbrbr_2], [3],
> [71303170], [8], [], [], [], []
> SMON: terminating instance due to error 600
> Instance terminated by SMON, pid = 2537
>
>
> Here's a look at the stack trace files:
>
> ORA-00600: internal error code, arguments: [kcbrbr_2], [3],
> [71303170], [8], [], [], [], []
> ----- Call Stack Trace -----
> Stack trace:
> 2537: ora_smon_ZEUSDB
> ffffffff7d8a2bbc read (d, ffffffff7fffcddc, 1)
> 00000001007dba70 ssdinit (ffffffff7fffcddc, 0, 101d304c4, 0, 1, 0) +
> 270
> 00000001007da284 skdstinit (ffffffff7fffd050, 0, 101d34e80,
> ffffffff7fffcf04, a, ffffffff7fffcd51) + 4
> 00000001002a8cd4 ksedst (0, 101d2e558, 1, 1017ad458, b1,
> ffffffff7fffccfc) + 24
> 00000001002a869c ksedmp (0, 0, 3, 101afdce8, 3, ffffffff7fffd5f0) +
> f4
> 00000001010de9e4 kgerinv (101d2f568, 1000, 101d2e630, 101d0f950,
> 1017ad458, 101d95b18) + fc
> 00000001010def88 kgeasnmierr (101d2e558, 101d95b18, 101afdce8, 3, 0,
> 3) + 20
> 0000000100409050 kcbrbr (3, 0, 8, 4400002, 3, 0) + 110
> 000000010018f968 ktssdro_segment (101d30fd8, 101d308e0, 6, 382f36c48,
> 0, ffffffff7fffd9fc) + 9c0
> 0000000100190bb4 ktssdt_segs (382f36d80, 1, 101ac9150, 101d30898, 0,
> 1) + 2ac
> 0000000100b1a0bc ktmmon (38000e228, 2e5, 0, fc00, 38000e108,
> 38000e108) + 1b1c
> 0000000100305094 ksbrdp (101d308a8, 0, 1017abad8, 38000e24c,
> 38000e230, ffffffff7fffe6a0) + 3d4
> 0000000100821098 opirip (3800140b0, 101d33ae8, 101d2e09c, 101d30f58,
> 101d2e310, ffffffff7ffff1c0) + 3c0
> 00000001001164ec opidrv (32, ffffffff7ffff328, 101d2e630, 6c6f6700,
> 0, 0) + 7f4
> 0000000100114c98 sou2o (ffffffff7ffff760, 32, 0, 0, 0, 101d846a0) +
> 10
> 00000001001148cc main (0, 101d66398, 1, 0, 0, 100000000) + a4
> 000000010011480c _start (0, 0, 0, 0, 0, 0) + ec
> End of trace
> ----- End of Call Stack Trace -----
>
>
> I tried look at the METALINK notes but..nothing.
>
>
> Can someone shed some light and help be out of this predicament? I
> would be extremely greatful.
>
>
>
> Chau

ora-600 ======> CALL Oracle support

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Tue Feb 05 2002 - 12:03:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US