From: kev Subject: Re: Queries don'twork any more - urgent! Date: 2000/06/06 Message-ID: <393CFB7D.723BC738@fast.no> Content-Transfer-Encoding: 7bit References: <393B01EE.140F053B@markandlard.com> <960204507.21432.0.pluto.d4ee154e@news.demon.nl> <393C5519.81647B7C@markandlard.com> <960268547.23657.0.pluto.d4ee154e@news.demon.nl> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii X-Complaints-To: abuse@easynet.net X-Trace: quince.news.easynet.net 960294307 99426 212.212.161.68 (6 Jun 2000 12:25:07 GMT) Organization: FAST Web Media Ltd Mime-Version: 1.0 NNTP-Posting-Date: 6 Jun 2000 12:25:07 GMT Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server 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 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.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 schreef in berichtnieuws > 393C5519.81647B7C@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 schreef in berichtnieuws > > > 393B01EE.140F053B@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 > > > > > >