RE: no alert.log

Kris:
If the database is successfully up, there is definitely a valid oracle home directory. As a DBA, you should know where it is. If $ORACLE_HOME variable is not specified in your .profile, you can not find the directory by cd $ORACLE_HOME.

                                                                             
                    Kris Austin                                              
                    <kaustin_at_adva        To:     Multiple recipients of list 
                    nce.net>             ORACLE-L <ORACLE-L_at_fatcity.com>     
                                         cc:     (bcc: William Dong/New York 
                    02/13/01             Life Asset Management)              
                    06:13 PM             Subject:     RE: no alert.log       
                    Please                                                   
                    respond to                                               
                    ORACLE-L                                                 
                                                                             
                                                                             

thanks, but this is what i get when i try to cd to $ORACLE_HOME:

db1:PHYS:/ora1_app> cd $ORACLE_HOME
bash: cd: /ora1_app/product/8.1.6: No such file or directory
db2:CONC:/ora2_app> cd $ORACLE_HOME
bash: cd: /ora2_app/product/8.1.6: No such file or directory

or an ls on $ORACLE_BASE:

db1:PHYS:/ora1_app> ls $ORACLE_BASE
db1:PHYS:/ora1_app>

nothing!

the disks on these 2 machines: ora1_app and ora2_app have not mounted. i don't know where the alert.log is being written to, or how the init.ora was read (both are located on those disks).

i checked v$parameter and all the parameters (background_dump_dest, etc) show directories that are not mounted. i'm still trying to get an SA to find any log or trc files.

thanks,
kris

On Tue, 13 Feb 2001, William Dong wrote:

> 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: 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).