Re: no alert.log

You have to export your ORACLE_HOME before you can use in like that.. You can also export you ORACLE_BASE.

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, February 13, 2001 6:13 PM

>
> 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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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