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@adva To: Multiple recipients of list
nce.net> ORACLE-L <[EMAIL PROTECTED]>
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 |
> | <[EMAIL PROTECTED]> |
> | 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).