Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where's the alert file for remote database stopped/started using OEM?
-- "Hans Forbrich" <forbrich_at_telus_spam.net> wrote in message news:3FFF00E1.623C918D_at_telus_spam.net...Received on Sun Jan 11 2004 - 16:16:19 CST
> Shirley Taylor wrote:
> >
> > This morning using the OEM I modified some parameters for a remote
> > version 8.1.7 database on Windows 2000 then stopped and restarted the
> > database to put them into effect. I later went, on the db server, to
> > look for something in the alert.log but can't find a current alert.log
> > where there should be one. I then searched all disks to no avail. When
> > using the OEM to start databases remotely what happens to the alert
> > log? Thanks, Shirley
>
> The alert.log is managed by the database instance and must be on the
> same server that is running the instabce. It has absolutely nothing to
> do with the fact that you started the instance using OEM.
>
> Look at the instance parameters for the BACKGROUND_DUMP_DEST to
> determine the most likely location for the log file. If that directory
> does not exist, it is possible the alert.log is being dumped to the bit
> bucket.
If that parameter is not set, is set incorrectly, or the disk it points to is full, it seems more likely the alert.log is being dumped under the "Oracle software" directory in a "default" location. If the software disk location is full, then it is possible it is going to the bit bucket. Making some assumptions where your "Oracle software" (for the Server) is installed, try this DOS search command: C:\dir alert*.log /s
![]() |
![]() |