Re: ksedmp: internal or fatal error

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Tue, 06 Apr 1999 08:40:37 -0700
Message-ID: <370A2AF5.2BFBDB5E@us.oracle.com>

Calvin

Any ORA-600 error indicates Oracle has detected an internal inconsistency or a problem which it doesn't know how best to address. These are *NOT* necessarily bugs and can occur for reasons such as Operating System IO problems, running out of some resource etc..

Contact Support with more information to determine what caused the error. The most useful items are:

The alert log for the instance (and any other instances in a Parallel Server environment) These should be in BACKGROUND_DUMP_DEST.
The trace file for the failing session and any other relevant trace files.
Information on what action was being performed.
Whether the problem is reproducible or was a one off occurance.
Anything that has recently been changed in the system environment. Eg: Has the OS been upgraded, Have any database files just been restored, etc...

HTH. Pete

Calvin Cheong wrote:

> Hi
>
> platform: openvms 7.1, oracle rdbms 7.3.2.3.2
>
> Working Set Current Extent/Size/Peak: 131072/13456/10320
> ------------------------------------------------------------
> vsnsql=b vsnxtr=3
> Oracle7 Server Release 7.3.2.3.2 - Production Release With the
> distributed opti
> cpu ALPH 80000000 vms V7.1 not clustered with 0 nodes
> scsnd: DEC02 , ndname: DEC02, sys$node SYS$NODE
>
> cpuid 80 rev 052100000000000000000016 archflg 1C000
> hwmdl: 1313 hwnm: AlphaServer 4X00 5/300 2MB cpus: FFFFFFFF cpush: 0
> active: 1,
> locktbl size 2816 max 108501 resource hash size 8192
> Instance name: MMSL
> Redo thread mounted by this instance: 1
> Oracle process number: 34
> pid: a0e0, image: DEC02$DRA0:[APP.ORACLE.PRODUCT.732.RDBMS]SRV2.EXE
>
> 6-APR-1999 09:15:20.38:
> ksedmp
> 6-APR-1999 09:15:20.38:
>
> *** SESSION ID:(25.3458) 1999.04.06.09.15.20.038
> ORA-00600: internal error code, arguments: [3510], [1], [0], [], [],
> [], [], []
>
> ----- Call Stack Trace -----
> calling call entry
>
> location type point
>
> -------------------- -------- --------------------
>
> SKDS MEMORY Total: 447bf (gblsec: 1ff, routine: 445c0, line: 0)
> +^xa34ff8 (^x87b98c) CALL +^xa34ff8 (^xa35020)
>
> +^xa34ff8 (^x87afe0) CALL +^xa34ff8 (^x87b808)
>
> +^xa34ff8 (^xb3da60) CALL +^xa34ff8 (^x87aed0)
> .....
> -----
> +^xa34ff8 (^x2006c) CALL +^xa34ff8 (^x200a0)
>
> +^xa34ff8 (^x7b098dcc) CALL +^xa34ff8 (^x20000)
>
> ----- Argument/Register Address Dump -----
>
> ----- End of Call Stack Trace -----
>
> ===================================================
> Files currently opened by this process:
>
> ----- Open File Dump -----
>
> ===================================================
> PROCESS STATE
>
> Experience this error with a particular user. No impact on instance.
> using forms 4.5. checked with user and she reports all is well.
>
> any pointers to this? thanks

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Apr 06 1999 - 10:40:37 CDT