Re: Urgently need help on: "Cannot Open Oracle DB when startup"

"Pearapon S." wrote:

> Hi All,
>
> I need help on recovery Data from Oracle DB on SUN Solaris.
> Recently,there are some problems with our Oracle DB. Here is the situation:
>
> While we were batch inserting Data into Oracle DB, there was a core dump
> on the system that force to Oracle DB down. When I shutdowned the system and
> up again. The Oracle can be startup and can mount DB. But It cannot OPEN DB
> and got out of the script to Unix prompt. After that I checked the
> "alert.log" file and found out that there was "core dump" while the Oracle
> was trying to recover "redo log" file. Please help us. We need to bring up
> Oracle back to normal as soon as possible. Please......
> Thank you very much in advance
>
> Best Regards,
> Pearapon Saerekul
> pearapon_at_ksc.th.com
>
> Here are some lines I got from the "alert.log" file:
>
> ========================
> Wed Jun 20 12:45:39 2001
> Beginning crash recovery of 1 threads
> Recovery of Online Redo Log: Thread 1 Group 1 Seq 9301 Reading mem 0
> Mem# 0 errs 0: /usr3/rd41/dbs/log1rd41.dbf
> Wed Jun 20 12:45:52 2001
> Errors in file
> /usr1/oracle74/app/oracle/product/7.3.4/rdbms/log/rd41_ora_4248.trc:
> ORA-00600: internal error code, arguments: [4555], [], [], [], [], [], [],
> []
> Wed Jun 20 12:45:54 2001
> Errors in file
> /usr1/oracle74/app/oracle/product/7.3.4/rdbms/log/rd41_ora_4248.trc:
> ORA-07445: exception encountered: core dump [] [SIGBUS] [Invalid address
> alignment] [2803944365] [] []
> ORA-00600: internal error code, arguments: [4555], [], [], [], [], [], [],
> []
> Wed Jun 20 12:51:22 2001
> Starting ORACLE instance (normal)
> Wed Jun 20 12:51:48 2001
> Shutting down instance (immediate)
> License high water mark = 2
> Wed Jun 20 12:51:48 2001
> ALTER DATABASE CLOSE NORMAL
> ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
> Wed Jun 20 12:51:48 2001
> ALTER DATABASE DISMOUNT
> Completed: ALTER DATABASE DISMOUNT
>
> ===========================

Justfor fun ... post the complete error message(s) you are getting when you try to start it up. And are you starting it up for recovery or just doing a normal startup? Seems to me recovery would be appropriate.

Daniel A. Morgan Received on Wed Jun 20 2001 - 13:45:01 CDT