Xref: alice comp.databases.oracle.server:39610
Path: alice!news-feed.fnsi.net!WCG!news.pbi.net!131.119.28.147!su-news-hub1.bbnplanet.com!su-news-feed1.bbnplanet.com!news.gtei.net!inet16.us.oracle.com!not-for-mail
From: Peter Sharman <psharman@us.oracle.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: (O8/NT) OEM & running jobs
Date: Tue, 02 Feb 1999 13:06:06 -0800
Organization: Oracle Corporation
Lines: 81
Message-ID: <36B768BE.C6C0A1D9@us.oracle.com>
References: <36B7189C.245D2FB6@cadvision.com> <36B7330D.C662FFDF@us.oracle.com> <36B74825.4B049F4B@cadvision.com> <36B7529F.3DC2708E@us.oracle.com> <36B75FDC.CC3EC64D@cadvision.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.5 [en] (WinNT; U)
X-Accept-Language: en

Ken

I'm not sure where you're based, but if you can give me a call and I can walk you
through this.

The alert log is located in a platform specific location.  From memory you're on NT, so
the alert log will be located under %ORACLE_HOME%\rdsbms80\trace (again, going from
memory) and it will be called something like alertorcl.log, where orcl is your database
sid.  This file is opened when the instance is started, and contains general information
about what's happening in the database.  It's a good starting point to look for errors,
which you then may need to track through other trace files as well.

HTH.

Pete

Ken Rachynski wrote:

> Peter,
>
> Please pardon my ignorance, but I haven't discovered the location of the alert logs.
> (Trying to learn Oracle, manage the database and program my applications doesn't
> really give me much time for free reading)
>
> As far as OEM errors, the only one is associated with the failed job in OEM: cannot
> start an already running instance.
>
> Peter Sharman wrote:
>
> > Ken
> >
> > Do you have any errors reported, either via OEM or in the alert logs?  If you do,
> > we may be able to debug further for you.
> >
> > Pete
> >
> > --
> >
> > Regards
> >
> > Pete
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Peter Sharman                              Email: psharman@us.oracle.com
> > WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
> > Worldwide Internal Services Education               (650)607 0109 (local)
> > San Francisco
> >
> > "Controlling application developers is like herding cats."
> > Kevin Loney, ORACLE DBA Handbook
> > "Oh no it's not!  It's much harder than that!"
> > Bruce Pihlamae, long term ORACLE DBA
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> --
> Ken Rachynski
> Database Analyst
> krachyn@cadvision.com
> <http://www.cadvision.com/krachyn>
> ICQ: 3113514

--


Regards

Pete

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Peter Sharman                              Email: psharman@us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)
San Francisco

"Controlling application developers is like herding cats."
Kevin Loney, ORACLE DBA Handbook
"Oh no it's not!  It's much harder than that!"
Bruce Pihlamae, long term ORACLE DBA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~