RE: no alert.log

Check the oratab file for correct ORACLE_HOME directory. And set the variables accordingly. And as suggested by Ruth, export those. You can also check the auto start scripts (from SA) to find out how exactly the databases were started and where your Oracle Software seems to be hiding. Secondly, verify that the permissions on these directories will allow you to 'cd' to them.

• Kirti

> -----Original Message-----
> From: Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
> Sent: Wednesday, February 14, 2001 6:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).