Re: Queries don'twork any more

From: kev <kevin.porter_at_fast.no>
Date: 2000/06/06
Message-ID: <393CFB7D.723BC738@fast.no>

Here's the entire contents of that file:

Tue Feb 22 13:11:28 2000
Shutting down instance (abort)
Wed May 17 11:26:42 2000
Errors in file
/usr/local/oracle/8i/u01/app/oracle/product/8.1.5/rdbms/log/ora_7339.trc: ORA-07445: exception encountered: core dump [11] [0] [] [] [] []

I'm fairly certain none of that could be relevant (too old), but here's the contents of the ora_7339.trc file anyway:

/usr/local/oracle/8i/u01/app/oracle/product/8.1.5/rdbms/log/ora_7339.trc Oracle8i Release 8.1.5.0.2 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
ORACLE_HOME = /usr/local/oracle/8i/u01/app/oracle/product/8.1.5 System name: Linux
Node name: blackadder

Release:    2.2.12-20
Version:    #1 Mon Sep 27 10:40:35 EDT 1999
Machine:    i686

Instance name: MEGSOC
Redo thread mounted by this instance: 0 <none> Oracle process number: 0
*** 2000.05.17.11.26.39.869
Exception signal: 11, code = 0
ORA-07445: exception encountered: core dump [11] [0] [] [] [] [] ----- Call Stack Trace -----
Failed to allocate memory for symbol table

calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- --------------------
----------------------------
08406A8A             CALL     0813D4C4             11 ? 400 ?
40347520             CALLr    00000000             BFFFB278 ? BFFFB210 ?
                                                   BFFFB1E8 ? BFFFB278 ? 11 ?
                                                   0 ? 9200B20 ? E ? 6 ?
                                                   8993A3F ? 23 ? 10246 ?
                                                   BFFFB1E8 ? 2B ? 0 ?
                                                   BE7BFA17 ? 0 ? BFFFB278 ?
                                                   BFFFB278 ? 9 ? 4034E6C0 ?
                                                   BFFFBA80 ? BFFFB210 ?
4036F408             CALLs    084069A8
08150C15             CALL     08993A10             BFFFB278 ? 11 ? 0 ?
                                                   BFFFB2A8 ? 8E28E4B ? 0 ?
                                                   BFFFB278 ? 30 ? 8 ? 0 ?
                                                   BFFFB95A ? 8E28EF8 ? 0 ?
                                                   BFFFB2C4 ? BFFFB3D8 ?
08150FCF             CALL     08150970             BFFFB554 ?
08150906             CALL     08150DCC
08406A55             CALL     081508F8
40347520             CALLr    00000000             924D84C ? BFFFBB8C ?
                                                   BFFFBB78 ? BFFFBBC8 ?
                                                   924C2C0 ? 0 ? 0 ? E ? 4 ?
                                                   8CC2FCC ? 23 ? 10286 ?
                                                   BFFFBB78 ? 2B ? 0 ?
                                                   80000000 ? 0 ? BFFFBBC8 ?
                                                   924D84C ? 924D9EC ?
                                                   4034E6C0 ? 0 ? BFFFBB8C ?
4036F408             CALLs    084069A8
08CB945B             CALL     08CC2FC0             55 ? BFFFBBC8 ? BFFFBC08 ?
                                                   2 ? 0 ? 0 ? BFFFBD24 ? 0 ?
08CB56F8             CALL     08CB9410
08CB5272             CALL     08CB5620
08C47B96             CALL     08CB51E0
08C4DA12             CALL     08C47B20
08B9D14E             CALL     08C4D910             3C ? BFFFFC31 ? 0 ? 0 ? 0 ?

08B9F776             CALL     08B9CE20
08435E38             CALL     08B9F2D0
08051945             CALLr    00000000             FFFFFFFF ? FFFFFFFF ?
                                                   FFFFFFFF ?
0804FBDF             CALL     08051400
0804EF46             CALL     0804F834
0804ED84             CALL     0804EF30
403691E9             CALLr    00000000
0804EBFC             CALL     0804E5C0

----- Argument/Register Address Dump ----- Argument/Register addr=bfffb278. Dump of memory from 0xBFFFB238 to 0xBFFFB378

BFFFB220                                                       ********


********BFFFB240 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFB360 ******** ******** ******** ******** ******** ******** Argument/Register addr=bfffb210. Dump of memory from 0xBFFFB1D0 to 0xBFFFB310

BFFFB1C0                                     ******** ******** ********


********BFFFB1E0 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFB300 ******** ******** ******** ******** Argument/Register addr=bfffb1e8. Dump of memory from 0xBFFFB1A8 to 0xBFFFB2E8

BFFFB1A0                   ******** ******** ******** ******** ********


********BFFFB1C0 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFB2E0 ******** ********
Argument/Register addr=9200b20. Dump of memory from 0x9200AE0 to 0x9200C20 9200AE0 ******** ******** ******** ******** ******** ******** ********

Repeat 9 times
Argument/Register addr=8993a3f. Dump of memory from 0x89939FF to 0x8993B3F 89939E0

8993A00 ******** ******** ******** ******** ******** ******** ********

Repeat 9 times
Argument/Register addr=4034e6c0. Dump of memory from 0x4034E680 to 0x4034E7C0

4034E680 ******** ******** ******** ******** ******** ******** ********
******** Repeat 9 times

Argument/Register addr=bfffba80. Dump of memory from 0xBFFFBA40 to 0xBFFFBB80

BFFFBA40 ******** ******** ******** ******** ******** ******** ********
******** Repeat 9 times

Argument/Register addr=8e28e4b. Dump of memory from 0x8E28E0B to 0x8E28F4B

8E28E00                   ******** ******** ******** ******** ********

8E28E20 ******** ******** ******** ******** ******** ******** ********

Repeat 8 times
8E28F40 ******** ******** ********
Argument/Register addr=bfffb95a. Dump of memory from 0xBFFFB91A to 0xBFFFBA5A

BFFFB900                                                       ********


********BFFFB920 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFBA40 ******** ******** ******** ******** ******** ******** ******** Argument/Register addr=8e28ef8. Dump of memory from 0x8E28EB8 to 0x8E28FF8

8E28EA0                                                       ********

8E28EC0 ******** ******** ******** ******** ******** ******** ********

Repeat 8 times
8E28FE0 ******** ******** ******** ******** ******** ******** Argument/Register addr=bfffb2c4. Dump of memory from 0xBFFFB284 to 0xBFFFB3C4

BFFFB280 ******** ******** ******** ******** ******** ********
********BFFFB2A0 ******** ******** ******** ******** ******** ********

******** Repeat 8 times BFFFB3C0 ******** Argument/Register addr=bfffb3d8. Dump of memory from 0xBFFFB398 to 0xBFFFB4D8

BFFFB380                                                       ********


********BFFFB3A0 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFB4C0 ******** ******** ******** ******** ******** ******** Argument/Register addr=bfffb554. Dump of memory from 0xBFFFB514 to 0xBFFFB654

BFFFB500                                              ******** ********


********BFFFB520 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFB640 ******** ******** ******** ******** ******** Argument/Register addr=924d84c. Dump of memory from 0x924D80C to 0x924D94C

924D800                            ******** ******** ******** ********

924D820 ******** ******** ******** ******** ******** ******** ********

Repeat 8 times
924D940 ******** ******** ********
Argument/Register addr=bfffbb8c. Dump of memory from 0xBFFFBB4C to 0xBFFFBC8C

BFFFBB40                            ******** ******** ******** ********


********BFFFBB60 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFBC80 ******** ******** ********
Argument/Register addr=bfffbb78. Dump of memory from 0xBFFFBB38 to 0xBFFFBC78

BFFFBB20                                                       ********


********BFFFBB40 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFBC60 ******** ******** ******** ******** ******** ******** Argument/Register addr=924c2c0. Dump of memory from 0x924C280 to 0x924C3C0 924C280 ******** ******** ******** ******** ******** ******** ********

Repeat 9 times
Argument/Register addr=8cc2fcc. Dump of memory from 0x8CC2F8C to 0x8CC30CC

8CC2F80                            ******** ******** ******** ********

8CC2FA0 ******** ******** ******** ******** ******** ******** ********

Repeat 8 times
8CC30C0 ******** ******** ********
Argument/Register addr=924d9ec. Dump of memory from 0x924D9AC to 0x924DAEC

924D9A0                            ******** ******** ******** ********

924D9C0 ******** ******** ******** ******** ******** ******** ********

Repeat 8 times
924DAE0 ******** ******** ********
Argument/Register addr=bfffbc08. Dump of memory from 0xBFFFBBC8 to 0xBFFFBD08

BFFFBBC0                   ******** ******** ******** ******** ********


********BFFFBBE0 ******** ******** ******** ******** ******** ********

******** ********        Repeat 8 times

BFFFBD00 ******** ********
Argument/Register addr=bfffbd24. Dump of memory from 0xBFFFBCE4 to 0xBFFFBE24

BFFFBCE0 ******** ******** ******** ******** ******** ***

DUMP FILE SIZE IS LIMITED TO 10000 BYTES ***

Does all that mean anything to anyone?

thanks,

Sybrand Bakker wrote:

> In the directory pointed to by the background_dump_dest init<sid>.ora
> parameter (in svrmgrl do show parameter dump). By default if you didn't
> change it in $ORACLE_HOME/rdbms/log
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> kev <kev_at_markandlard.com> schreef in berichtnieuws
> 393C5519.81647B7C_at_markandlard.com...
> > OK thanks. Sorry to be so dumb, but where do I find the alert log?
> >
> > - Kev
> >
> > Sybrand Bakker wrote:
> >
> > > Comment embedded.
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > > kev <kev_at_markandlard.com> schreef in berichtnieuws
> > > 393B01EE.140F053B_at_markandlard.com...
> > > > Hi,
> > > >
> > > > I'm using 8.1.5 on Red Hat 6.1.
> > > >
> > > > Certain (similar) queries have stopped returning any results. They

were

> > > > working fine, and then suddenly stopped. I'm 99% certain I have done
> > > > nothing which may have caused this.
> > > >
> > > > Where the hell do I start to find out what's wrong?
> > >
> > > As usual in the alert log.
> > >
> > > > I'm at home and so don't have Oracle Support's 24/7 support phone

number

> > > > (England) with me. If anyone could remind me of it (mail me direct) I
> > > > can ring them.
> > > >
> > > > thanks,
> > > >
> > > > - Kev
> > > >
> >

Received on Tue Jun 06 2000 - 00:00:00 CDT

Re: Queries don'twork any more - urgent!