Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Clone DB Created - NO alert file ?

Re: Clone DB Created - NO alert file ?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 28 Feb 2002 08:49:29 +1100
Message-ID: <a5jk9g$b0p$1@lust.ihug.co.nz>


There shouldn't be any mystery about it! Wherever your init.ora has set background_dump_dest will be where the alert log is written to. I suppose there could be permissions problems there (try a chmod 777 for starters!), and I'm not entirely sure what happens when Oracle does not have the rights to actually create or write to the alert log... I'm guessing that it fails silently.

Anyway: start with background_dump_dest and work from there.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Daniel_Bryant" <danielbryant_at_cobbk12.org> wrote in message
news:85a5053.0202271000.4f8b711a_at_posting.google.com...

> I created a clone DB from one Sun Solaris Server to another. The DB
> is up and running (in Archive mode). My question is - I cannot find
> an alert file for the new DB. The redo logs have already auto
> archived, and that should have been listed in the alert log. (Along
> with any shutdowns/startups) Anyone have any idea why I am not
> getting an alert file created. I thought that even if you deleted the
> alert log - Oracle would re-create it when it needed to write to it ?
>
> Thanks in advance !
Received on Wed Feb 27 2002 - 15:49:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US