RE: no alert.log

Hi:
If the specified bdump is not accessable, oracle may write the alert_log to $ORACLE_HOME/dbms or dbs directory by default. I am sure you can find it somewhere in oracle_home.

|--------+----------------------->


|        |          Henry Poras  |

|        |          <Henry.Poras@|

|        |          ctp.com>     |

|        |                       |

|        |          02/13/01     |

|        |          02:10 PM     |

|        |          Please       |

|        |          respond to   |

|        |          ORACLE-L     |

|        |                       |

|--------+----------------------->
  >-----------------------------------------------------|
  |                                                     |
  |       To:     Multiple recipients of list ORACLE-L  |
  |       <ORACLE-L_at_fatcity.com>                        |
  |       cc:     (bcc: William Dong/New York Life Asset|
  |       Management)                                   |
  |       Subject:     RE: no alert.log                 |
  >-----------------------------------------------------|

Kris,
Try doing something to force a write to the alert log (e.g. switch logfile or backup controlfile to trace). Of course to start up the database there should also be writes to the alert log. Also, what did it use for init.ora? That should also be under $ORACLE_BASE. You can check v$parameter for bdump. If that is in $ORACLE_BASE, I would guess that the database didn't have a normal startup and it hasn't looked for those directories yet. You can also try searching the server for alertSID.log.

Henry

-----Original Message-----
Sent: Tuesday, February 13, 2001 1:21 PM To: Multiple recipients of list ORACLE-L

hi list

we had a major outage at exodus lastnight. blew up both machines with 6 production databases. SAs have brought most of the disks back up but not $ORACLE_BASE (or $ORACLE_HOME). how can our databases be up if the alert.log(s) live on the unmounted disks? doesn't an oracle database have to be able to write to alert.log in order to start?

our databases are up. i've checked all the processes which are running (ps -ef | grep ora), and i'm able to connect to all 6 remotely (just not locally since the binaries for sqlplus and svrmgrl also live on those unmounted disks). we are running 8.1.6 on solaris.

thanks,
kris

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kris Austin
  INET: kaustin_at_advance.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henry Poras
  INET: Henry.Poras_at_ctp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: William Dong
  INET: William_Dong_at_nylim.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).