Re: Queries don'twork any more

From: <ddf_dba_at_my-deja.com>
Date: 2000/06/06
Message-ID: <8hjdgm$b6s$1@nnrp1.deja.com>

Kevin,

If the Oracle error number is to be believed (ORA-7445) this is an operating system error and should have created a core file that can be examined with adb, dbx or gdb. Has anything occurred that could cause any of the Oracle executables (sqlplus, oracle) to become corrupted? There may be memory problems as well on your server, but without seeing the debugger output for the core file I really cannot tell you what is creating this problem. Neither can Oracle, at least in the Oracle error file. The recommendation from the oerr utility is to contact Customer Support. I would try to find the core file and run it through a debugger to discover why the query terminated. Then contact Oracle support and send them the alert.log and the core file.

David Fitzjarrell
In article <393CFB7D.723BC738_at_fast.no>,
kev <kevin.porter_at_fast.no> wrote:
> 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,
>
> - Kev
>
> 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
> > > > >
> > >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jun 06 2000 - 00:00:00 CDT

Re: Queries don'twork any more - urgent!