紧急求助.遇到oracle bug

枫影谁用了

Thu Nov 30 23:20:29 2006
Errors in file /opt/oracle/admin/****/udump/****_ora_3674.trc:
ORA-07445: exception encountered: core dump [lmebucp()+43] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Thu Nov 30 23:21:22 2006
Restarting dead background process QMN0

数据库可以启动,但是只有sys可以进去,其它都进去报ora:01033

现在我用昨天的RMAN的完全备份做恢复,仍然是这个错误.

请问如何解决?
操作系统:
Linux dbserver03 2.4.21-20.ELsmp #1 SMP Wed Aug 18 20:46:40 EDT 2004 i686 i686 i386 GNU/Linux
ORACLE:9.2.0.4.0

huayang_ora_3674.txt

[ 本帖最后由 枫影谁用了 于 2006-12-2 08:24 编辑 ]

donaldit

解决完了？

枫影谁用了

..........................

[ 本帖最后由 枫影谁用了 于 2006-12-2 13:01 编辑 ]

imtj

把你LINUX系统日志贴出来看看，然后你取消log_archived_dest_1看看，启动是否可以成功！

枫影谁用了

Dec 1 13:55:23 dbserver03 kernel: Type: Direct-Access ANSI SCSI revision: 03
Dec 1 13:55:23 dbserver03 kernel: blk: queue f7fcf618, I/O limit 4095Mb (mask 0xffffffff)
Dec 1 13:55:23 dbserver03 kernel: scsi0:A:0:0: Tagged Queuing enabled. Depth 32
Dec 1 13:55:23 dbserver03 kernel: scsi0:A:1:0: Tagged Queuing enabled. Depth 32
Dec 1 13:55:23 dbserver03 rc: Starting pcmcia: succeeded
Dec 1 13:55:23 dbserver03 kernel: scsi0:A:2:0: Tagged Queuing enabled. Depth 32
Dec 1 13:55:23 dbserver03 kernel: Attached scsi disk sda at scsi0, channel 0, id 0, lun 0
Dec 1 13:55:23 dbserver03 kernel: Attached scsi disk sdb at scsi0, channel 0, id 1, lun 0
Dec 1 13:55:23 dbserver03 kernel: Attached scsi disk sdc at scsi0, channel 0, id 2, lun 0
Dec 1 13:55:23 dbserver03 kernel: SCSI device sda: 143374650 512-byte hdwr sectors (73408 MB)
Dec 1 13:55:23 dbserver03 kernel: Partition check:
Dec 1 13:55:23 dbserver03 kernel: sda: sda1 sda2 sda3 sda4 < sda5 sda6 sda7 sda8 >
Dec 1 13:55:23 dbserver03 kernel: SCSI device sdb: 143374650 512-byte hdwr sectors (73408 MB)
Dec 1 13:55:23 dbserver03 kernel: sdb: sdb1
Dec 1 13:55:23 dbserver03 kernel: SCSI device sdc: 143374805 512-byte hdwr sectors (73408 MB)
Dec 1 13:55:23 dbserver03 kernel: sdc: sdc1
Dec 1 13:55:23 dbserver03 kernel: blk: queue c368b418, I/O limit 4095Mb (mask 0xffffffff)
Dec 1 13:55:23 dbserver03 kernel: ata1: SATA max UDMA/133 cmd 0xFE00 ctl 0xFE12 bmdma 0xFEA0 irq 18
Dec 1 13:55:23 dbserver03 kernel: ata2: SATA max UDMA/133 cmd 0xFE20 ctl 0xFE32 bmdma 0xFEA8 irq 18
Dec 1 13:55:23 dbserver03 kernel: ata1: SATA port has no device.
Dec 1 13:55:23 dbserver03 kernel: ata2: SATA port has no device.
Dec 1 13:55:23 dbserver03 kernel: scsi2 : ata_piix
Dec 1 13:55:23 dbserver03 kernel: scsi3 : ata_piix
Dec 1 13:55:23 dbserver03 kernel: Journalled Block Device driver loaded
Dec 1 13:55:23 dbserver03 kernel: kjournald starting. Commit interval 5 seconds
Dec 1 13:55:23 dbserver03 netfs: Mounting other filesystems: succeeded
Dec 1 13:55:23 dbserver03 kernel: EXT3-fs: mounted filesystem with ordered data mode.
Dec 1 13:55:23 dbserver03 kernel: Freeing unused kernel memory: 228k freed
Dec 1 13:55:23 dbserver03 kernel: usb.c: registered new driver usbdevfs
Dec 1 13:55:23 dbserver03 kernel: usb.c: registered new driver hub
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: $Revision: 1.275 $ time 20:55:52 Aug 18 2004
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: High bandwidth mode enabled
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: USB UHCI at I/O 0xff80, IRQ 16
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: Detected 2 ports
Dec 1 13:55:23 dbserver03 kernel: usb.c: new USB bus registered, assigned bus number 1
Dec 1 13:55:23 dbserver03 kernel: hub.c: USB hub found
Dec 1 13:55:23 dbserver03 kernel: hub.c: 2 ports detected
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: USB UHCI at I/O 0xff60, IRQ 19
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: Detected 2 ports
Dec 1 13:55:23 dbserver03 kernel: usb.c: new USB bus registered, assigned bus number 2
Dec 1 13:55:23 dbserver03 kernel: hub.c: USB hub found
Dec 1 13:55:23 dbserver03 kernel: hub.c: 2 ports detected
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: USB UHCI at I/O 0xff40, IRQ 18
Dec 1 13:55:23 dbserver03 autofs: automount startup succeeded
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: Detected 2 ports
Dec 1 13:55:23 dbserver03 kernel: usb.c: new USB bus registered, assigned bus number 3
Dec 1 13:55:23 dbserver03 kernel: hub.c: USB hub found
Dec 1 13:55:23 dbserver03 kernel: hub.c: 2 ports detected
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: USB UHCI at I/O 0xff20, IRQ 16
Dec 1 13:55:23 dbserver03 kernel: usb-uhci.c: Detected 2 ports
Dec 1 13:55:23 dbserver03 kernel: usb.c: new USB bus registered, assigned bus number 4
Dec 1 13:55:23 dbserver03 kernel: hub.c: USB hub found
Dec 1 13:55:24 dbserver03 kernel: hub.c: 2 ports detected
Dec 1 13:55:24 dbserver03 kernel: usb-uhci.c: v1.275:USB Universal Host Controller Interface driver
Dec 1 13:55:24 dbserver03 kernel: ehci-hcd 00:1d.7: Intel Corp. 82801EB USB2
Dec 1 13:55:24 dbserver03 kernel: ehci-hcd 00:1d.7: irq 23, pci mem f88d3800
Dec 1 13:55:24 dbserver03 kernel: usb.c: new USB bus registered, assigned bus number 5
Dec 1 13:55:24 dbserver03 kernel: ehci-hcd 00:1d.7: enabled 64bit PCI DMA
Dec 1 13:55:24 dbserver03 kernel: ehci-hcd 00:1d.7: USB 2.0 enabled, EHCI 1.00, driver 2003-Jan-22
Dec 1 13:55:24 dbserver03 kernel: hub.c: USB hub found
Dec 1 13:55:24 dbserver03 kernel: hub.c: 8 ports detected
Dec 1 13:55:24 dbserver03 kernel: usb.c: registered new driver hiddev
Dec 1 13:55:24 dbserver03 kernel: usb.c: registered new driver hid
Dec 1 13:55:24 dbserver03 kernel: hid-core.c: v1.8.1 Andreas Gal, Vojtech Pavlik
Dec 1 13:55:24 dbserver03 kernel: hid-core.c: USB HID support drivers
Dec 1 13:55:24 dbserver03 kernel: mice: PS/2 mouse device common for all mice
Dec 1 13:55:24 dbserver03 kernel: EXT3 FS 2.4-0.9.19, 19 August 2002 on sd(8,1), internal journal
Dec 1 13:55:24 dbserver03 kernel: Adding Swap: 2048248k swap-space (priority -1)
Dec 1 13:55:24 dbserver03 kernel: kjournald starting. Commit interval 5 seconds
Dec 1 13:55:24 dbserver03 kernel: EXT3 FS 2.4-0.9.19, 19 August 2002 on sd(8,7), internal journal
Dec 1 13:55:24 dbserver03 kernel: EXT3-fs: mounted filesystem with ordered data mode.
Dec 1 13:55:24 dbserver03 kernel: kjournald starting. Commit interval 5 seconds
Dec 1 13:55:24 dbserver03 kernel: EXT3 FS 2.4-0.9.19, 19 August 2002 on sd(8,2), internal journal
Dec 1 13:55:24 dbserver03 kernel: EXT3-fs: mounted filesystem with ordered data mode.
Dec 1 13:55:24 dbserver03 kernel: kjournald starting. Commit interval 5 seconds
Dec 1 13:55:24 dbserver03 kernel: EXT3 FS 2.4-0.9.19, 19 August 2002 on sd(8,3), internal journal
Dec 1 13:55:24 dbserver03 kernel: EXT3-fs: mounted filesystem with ordered data mode.
Dec 1 13:55:24 dbserver03 kernel: kjournald starting. Commit interval 5 seconds
Dec 1 13:55:24 dbserver03 kernel: EXT3 FS 2.4-0.9.19, 19 August 2002 on sd(8,17), internal journal
Dec 1 13:55:24 dbserver03 kernel: EXT3-fs: mounted filesystem with ordered data mode.
Dec 1 13:55:24 dbserver03 kernel: kjournald starting. Commit interval 5 seconds
Dec 1 13:55:24 dbserver03 kernel: EXT3 FS 2.4-0.9.19, 19 August 2002 on sd(8,6), internal journal
Dec 1 13:55:24 dbserver03 kernel: EXT3-fs: mounted filesystem with ordered data mode.
Dec 1 13:55:24 dbserver03 kernel: kjournald starting. Commit interval 5 seconds
Dec 1 13:55:24 dbserver03 kernel: EXT3 FS 2.4-0.9.19, 19 August 2002 on sd(8,5), internal journal
Dec 1 13:55:24 dbserver03 kernel: EXT3-fs: mounted filesystem with ordered data mode.
Dec 1 13:55:24 dbserver03 kernel: kjournald starting. Commit interval 5 seconds
Dec 1 13:55:24 dbserver03 kernel: EXT3 FS 2.4-0.9.19, 19 August 2002 on sd(8,33), internal journal
Dec 1 13:55:24 dbserver03 kernel: EXT3-fs: mounted filesystem with ordered data mode.
Dec 1 13:55:24 dbserver03 kernel: IA-32 Microcode Update Driver: v1.13
Dec 1 13:55:24 dbserver03 kernel: microcode: No suitable data for cpu 0
Dec 1 13:55:24 dbserver03 kernel: microcode: No suitable data for cpu 1
Dec 1 13:55:24 dbserver03 kernel: parport0: PC-style at 0x378 (0x77 [PCSPP,TRISTATE]
Dec 1 13:55:24 dbserver03 kernel: parport0: irq 7 detected
Dec 1 13:55:24 dbserver03 kernel: inserting floppy driver for 2.4.21-20.ELsmp
Dec 1 13:55:24 dbserver03 kernel: Floppy drive(s): fd0 is 1.44M
Dec 1 13:55:24 dbserver03 kernel: floppy0: no floppy controllers found
Dec 1 13:55:24 dbserver03 kernel: Intel(R) PRO/1000 Network Driver - version 5.2.52-k3
Dec 1 13:55:24 dbserver03 kernel: Copyright (c) 1999-2004 Intel Corporation.
Dec 1 13:55:24 dbserver03 kernel: e1000: eth0: e1000_probe: Intel(R) PRO/1000 Network Connection
Dec 1 13:55:24 dbserver03 kernel: ip_tables: (C) 2000-2002 Netfilter core team
Dec 1 13:55:24 dbserver03 kernel: Intel(R) PRO/1000 Network Driver - version 5.2.52-k3
Dec 1 13:55:24 dbserver03 kernel: Copyright (c) 1999-2004 Intel Corporation.
Dec 1 13:55:25 dbserver03 kernel: e1000: eth0: e1000_probe: Intel(R) PRO/1000 Network Connection
Dec 1 13:55:25 dbserver03 kernel: ip_tables: (C) 2000-2002 Netfilter core team
Dec 1 13:55:25 dbserver03 kernel: e1000: eth0: e1000_watchdog: NIC Link is Up 100 Mbps Full Duplex
Dec 1 13:55:25 dbserver03 kernel: audit subsystem ver 0.1 initialized
Dec 1 13:55:25 dbserver03 kernel: parport0: PC-style at 0x378 (0x77 [PCSPP,TRISTATE]
Dec 1 13:55:25 dbserver03 kernel: parport0: irq 7 detected
Dec 1 13:55:25 dbserver03 kernel: lp0: using parport0 (polling).
Dec 1 13:55:25 dbserver03 kernel: lp0: console ready
Dec 1 13:55:26 dbserver03 modprobe: modprobe: Can't locate module char-major-188
Dec 1 13:55:26 dbserver03 last message repeated 15 times
Dec 1 13:55:26 dbserver03 cups: cupsd startup succeeded
Dec 1 13:55:26 dbserver03 sshd: succeeded
Dec 1 13:55:26 dbserver03 xinetd: xinetd startup succeeded
Dec 1 13:55:27 dbserver03 vsftpd: vsftpd vsftpd succeeded
Dec 1 13:55:30 dbserver03 xinetd[5688]: xinetd Version 2.3.12 started with libwrap loadavg options compiled in.
Dec 1 13:55:30 dbserver03 xinetd[5688]: Started working: 2 available services
Dec 1 13:57:29 dbserver03 sendmail: sendmail startup succeeded
Dec 1 13:58:29 dbserver03 sendmail: sm-client startup succeeded
Dec 1 13:58:29 dbserver03 gpm: gpm startup succeeded
Dec 1 13:58:29 dbserver03 crond: crond startup succeeded
Dec 1 13:58:30 dbserver03 xfs: xfs startup succeeded
Dec 1 13:58:30 dbserver03 atd: atd startup succeeded
Dec 1 13:58:30 dbserver03 oracle: Starting Oracle Databases ...
Dec 1 13:58:30 dbserver03 su(pam_unix)[5821]: session opened for user oracle by (uid=0)
Dec 1 13:58:35 dbserver03 su(pam_unix)[5821]: session closed for user oracle
Dec 1 13:58:35 dbserver03 oracle: Done.
Dec 1 13:58:35 dbserver03 su(pam_unix)[5903]: session opened for user oracle by (uid=0)
Dec 1 13:58:35 dbserver03 oracle: Starting Oracle Listeners ...
Dec 1 13:58:36 dbserver03 su(pam_unix)[5903]: session closed for user oracle
Dec 1 13:58:36 dbserver03 oracle: Done.
Dec 1 13:58:36 dbserver03 oracle:
Dec 1 13:58:36 dbserver03 rc: Starting oracle: succeeded
Dec 1 13:58:37 dbserver03 modprobe: modprobe: Can't locate module char-major-10-134
Dec 1 13:58:56 dbserver03 sshd(pam_unix)[6013]: session opened for user oracle by (uid=501)
Dec 1 14:01:34 dbserver03 sshd(pam_unix)[6119]: check pass; user unknown
Dec 1 14:01:34 dbserver03 sshd(pam_unix)[6119]: authentication failure; logname= uid=0 euid=0 tty=NODEVssh ruser= rhost=128.3.0.159
Dec 1 14:01:45 dbserver03 sshd(pam_unix)[6123]: session opened for user oracle by (uid=501)
Dec 1 14:02:58 dbserver03 sshd(pam_unix)[6178]: session opened for user oracle by (uid=501)
Dec 1 14:03:44 dbserver03 sshd(pam_unix)[6178]: session closed for user oracle
Dec 1 14:07:53 dbserver03 sshd(pam_unix)[6205]: session opened for user oracle by (uid=501)
Dec 1 14:08:50 dbserver03 sshd(pam_unix)[6205]: session closed for user oracle
Dec 1 14:24:51 dbserver03 sshd(pam_unix)[6275]: session opened for user oracle by (uid=501)
Dec 1 14:25:08 dbserver03 sshd(pam_unix)[6319]: session opened for user oracle by (uid=501)
Dec 1 15:01:58 dbserver03 sshd(pam_unix)[6319]: session closed for user oracle
Dec 1 15:02:01 dbserver03 sshd(pam_unix)[6275]: session closed for user oracle
Dec 1 15:03:54 dbserver03 sshd(pam_unix)[6484]: session opened for user oracle by (uid=501)
Dec 1 15:27:45 dbserver03 su(pam_unix)[6569]: session opened for user root by oracle(uid=501)