Maybe in %ORACLE_HOME%\dbs ?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
Sent: Monday, December 08, 2003 9:05 AM
To: Multiple recipients of list ORACLE-L
Hi List
My databas
Shed some light on your dump parameters? They'd look much better if they
had slashes instead of backslashes, but you probably can't help it. Now
that you've told us where are your log and trace files, please tell us
what's in them. My ESP capabilities are damaged by the snow and I need to actually
This is from the Oracle 8i Administrators Guide for Windows:
"Oracle8i for Windows NT background threads use trace files to record occurrences and
exceptions of database operations, as well as errors. Background thread trace files
are created regardless of whether the BACKGROUND_DUMP_DEST paramete
If nothing else helps, download procexp or filemon from www.sysinternals.com
and see which files are open by oracle.exe
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 5:04 PM
> Hi List
>
> My database is taking
Regardless of whether or not it works, download it and the other tools like
ntregmon, prcvire, and the almighty FileMonitor. No installs, no DLLs, no
uninstall crap. Just extract and run the .exe. Excellent debugging tools.
Rich
Rich Jesse System/Database Administrato
Be careful of grepping for "^ORA-", I occasionally get " ORA-" (spaces)
when I use this. Anjo gave me a call to make to attempt to get the line to
start at the beginning but I don't think it works. Hard to test since this
situation is not recreatable. AIX 64 bit 4.3 Oracle 8.1.4.
- E
ared
"Post, Ethan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/27/2003 03:44 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Alert log
Be care
Your archiving is TRUE instead of false
Check for log_archive_start FALSE
change this parameter to false and rebounce your database.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 11 May 2001 08:46:06 -0800
DBA
Raj,
It's new archiving tracing introduced in 8i. If
you're on 8.1.6 or later you can control the level of
tracing with the LOG_ARCHIVE_TRACE parameter.
See the following docs:
Note 94055.1 "Init.ora Parameter "LOG_ARCHIVE_TRACE"
Reference Note"
Note 104405.1 "ARCH tracefile messages VALIDATE,
Hi
I think this parameter is available from 8.1.6 where us I am in 8.1.5..Any
idea how to control it in 8.1.5?
Raj
-Original Message-
Sent: 12 May 2001 00:18
To: Multiple recipients of list ORACLE-L
Raj,
It's new archiving tracing introduced in 8i. If
you're on 8.1.6 or later you ca
Rafiq
But I want my db to be archived..
Raj
-Original Message-
Sent: 11 May 2001 21:46
To: Multiple recipients of list ORACLE-L
Your archiving is TRUE instead of false
Check for log_archive_start FALSE
change this parameter to false and rebounce your database.
Regards
Raj,
Nope, none that I know of. Yet another reason to
upgrade ;)
-- Anita
--- Raj Gopalan <[EMAIL PROTECTED]>
wrote:
> Hi
>
> I think this parameter is available from 8.1.6 where
> us I am in 8.1.5..Any
> idea how to control it in 8.1.5?
>
> Raj
>
> -Original Message-
> Sent: 12 May
It looks like that it is due to something with parallel query process.
Please check your code or degree of tables being used in your code.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 06 Feb 2001 11:00:42 -0800
Hi gurus!
I
Hi Rafiq,
The problem looks like as what you suggested.
We are working on those lines.
I thank you for your input.
Regards,
Shakeel Qureshi
[EMAIL PROTECTED]
--- Mohammad Rafiq <[EMAIL PROTECTED]> wrote:
> It looks like that it is due to something with
> parallel query process.
> Please che
The obvious question being why you are coalescing
tablespaces
--- "Markham, Richard" <[EMAIL PROTECTED]>
wrote: > Is it possible to suppress successful DDL
within the
> alter log?
> For example, I have a cron job that coalesces 300+
> tablespaces
> which creates a couple line entry for each.
Title: RE: alert log suppression
ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and
I believe that SMON requires PCTINCREASE > 0 to do routine
coalescing.perhaps you have further to add to your post.
-Original Message-
From: Connor McDonald [
Title: RE: alert log suppression
Richard,
If you are using UNIFORM extents (which is usually the best
option), you don't need to do any coalescing on LMTs.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Markham, Richard
To: Multiple recipien
Title: RE: alert log suppression
Coalescing LMTs is unnecessary !
-
Kirti
-Original Message-From: Markham, Richard
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
12:00 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: alert log suppression
ok. They are LMT
ECTED]] Sent: Monday, December 16, 2002
1:30 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: alert log suppression
Richard,
If you are using UNIFORM extents (which is usually the best
option), you don't need to do any coalescing on LMTs.
Igor Neyman, OCP DBA[EMAIL
Title: RE: alert log suppression
If it
is LMT, coalescing is ignored.
-Original Message-From: Deshpande, Kirti
[mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002
10:34 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: alert log suppression
Coalescing LMTs is
ictionary
managed tablespaces.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 2:09
PM
Subject: RE: alert log suppression
Thanks for the info Igor. In
and NEXT_EXTENT;
they should be same.
HTH.
Arup
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 2:09
PM
Subject: RE: alert log suppression
Thanks for the info Igor. In addition to this I am
recipients of list ORACLE-LSubject:
Re: alert log suppression
Richard,
I have here versions 8.1.5 and 9.2.
Both show allocation type "UNIFORM" for LMTs with uniform
extent size (except LM SYSTEM and UNDO tablespaces in 9.2 , for which
"SYSTEM" allocation type is shown),
The EXTENT_MANAGEMENT column tells you if they are
locally managed or not. If they are local, then the
ALLOCATION_TYPE will be either UNIFORM, SYSTEM or
USER. The latter means it was originally a dictionary
managed tspace that has been converted to lmt.
But in any event, the coalesce is just ext
just backup it ( cp alertDBSID.log backupalert.old) and empty it (echo
/dev/null > alertDBSID.log) no need to bounce DB
rui
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: alert
log file
for one
Title: Message
No problems, just move it. No need to shutdown, Oracle will just
create a new file next time it needs to write to it.
Moving the alert log should be something you do on a regular
basis.
Pete
"Controlling
developers is like herding cats."
Kevin
Loney, Oracle DBA Handbook
You
can rename the alert log or move it. Oracle will create a new one the next
time it has to write to it. You don't need to bounce the
DB.
Dave
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 9:54
AMTo: Multiple recipients of list ORACLE-
rename it, Oracle will create a new alert log file when it needs to
write to the alert log again
--- AK <[EMAIL PROTECTED]> wrote:
> for one of the db over here alert log is biggg .Looks like its
> never been truncated or backup .
> Is it a problem if i just move this alert log file to anoth
If you move the alert log to another directory, Oracle will create a new
one in its place. There is no need to bounce the DB.
-Scott
At 07:54 AM 3/31/03 -0800, you wrote:
for one of the
db over here alert log is biggg .Looks like its never been
truncated or backup .
Is it a problem if i
Copy the alert log to the desired location and then
CAT /dev/null into the alert log.
CAT /dev/null > alert.log
This will zero out the alert log and allow you to keep the old data.
Ron
>>> [EMAIL PROTECTED] 03/31/03 10:53AM >>>
for one of the db over here alert log is biggg .Looks like its
When I see a humungous file like that, I build a little
ksh
script that hasn't failed me yet.
suffix=`date +%y%m%d`
cp -p alertSID.log alertSID_${suffix}.log
> alertSID.log
The only thing that might happen is if Oracle is updating
the
log file at EXACTLY the moment you execute this script
Title: RE: alert log file
We compress ours which makes them much smaller for storage. Oracle will create a new alert log file and there is no need to bounce the db.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From
thanks,
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 31, 2003 8:53 AM
> rename it, Oracle will create a new alert log file when it needs to
> write to the alert log again
>
> --- AK <[EMAIL PROTECTED]> wrote:
> > for one of th
>Hi all,
>
>I am writing a script that can "grep "ORA-" from
>alert log.
>
>I think it will be good if I can grep the time of
>the error occur, can you please help me?
>
>If you are lazy to type please introduce me any
>related unix function, I will do man "the function"
>myself.
>
>
>Thanks
>
>Si
Sinardy,
I've posted a shell script called "chk_oerr.sh" on
http://www.EvDBT.com/tools.htm";. It doesn't do exactly what you ask, but it
remembers where it left off scanning in the "alert.log" file. You can run
it hourly, daily, or weekly if you like, and the timing of the emails it
sends you sh
Title: RE: Alert Log reporting question
Checkout http://www.zephyrus.com ... it is a very nice tool ...
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts
I have a script to do this (but not access to it at
the moment) but its basically egrep and awk to:
a) grep for ORA-, ^Mon, ^Tue, ... ^Sat
b) results piped through awk which does:
if $0 like ORA-, the print p, $0
if $0 like Mon,Tue,...Sat, then p=substr($0,12)
hth
connor
--- Sinardy X
I believe that a dedicated window running
tail -f 10 /alert_log_filename
will keep an eye on the last 10 lines of the
alert log in Unix/Linux.
- jeremy donson
CateredComputing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat C
Try AlertView from zephyrus.com. It is a free tool for analyzing your alert
logs.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 9:31 AM
> Last week I was bit by a corrupt block on an index. I run Analyze every
> w
Ron,
I've attached one that I also got from the list some time ago, you may need
to use something like bablefish to translate the comments :)
HTH
Mark
-Original Message-
L.
Sent: Tuesday, July 10, 2001 02:32
To: Multiple recipients of list ORACLE-L
Last week I was bit by a corrupt bl
This seems strange to me, because things are written to the alert log file when the
instance starts, even when the database is not opened.
It should have been background_dump_dest (not user_dump_dest) and sometimes stuff is
written to $ORACLE_HOME/rdbms/log.
If you have looked for the file with f
Unless they have radically changed how they handle physical standby
databases, you should have an alert log for that database.
Have you logged in as sysdba and checked the location of the
background_dump_dest in v$parameter?
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I've created a physica
Alternately check in $ORACLE_HOME/dbs directory for alertSID. log. I
observed that people are still using defaults while creating databases
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 11 Sep 2003 08:24:26 -0800
Unless th
Title: RE: Alert log from Remote client
Check out AlertView from http://www.zephyrus.com/html/products.html. It's a java utility that provides a GUI interface to remote alert.log files. I think it's still free.
Tony
-Original Message-
From: Nirmal Kumar Muthu Kumar
There is a product (free) called AlertView. It is from zephyrus software
(zephyrus.com). It runs on a pc and can monitor as many alert.logs as you
have.
Take a look!
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 200
Nirmal,
Perhaps the replies re AlertView have answered your question. AFAICR it
requires FTP service to be running. You did not specify your Operating
System. Do you simply want to view the Alert logs and Trace files for the
various databases or be alerted if an error appears in Alert Log or a
for the
various databases, as you said.
How can i?
Nirmal
> -Original Message-
> From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 26, 2001 2:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Alert log from Remot
pelling 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).
>
>
>
>
>
>
>RE: Alert log
You and Rachel are right, I meant to say background_dump_dest. I am
unfortunately on Windoze.
However--I have just realized that my standby is running under 9.2.0.4
and primary under 9.2.0.3, which is, uh, wrong! I'm going to upgrade
the primary machine and try again...
Thanks!
--- Stephane Fa
Can we setup a physical standby on a different OS (Win 2003) than the
primary db (Win 2000).
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/[EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://ww
not according to the oracle documentation. A physical standby has to be
on the same platform/same operating system (including patches)/same
database release
logical standby databases do not have to conform to that restriction
--- Murali_Pavuloori/[EMAIL PROTECTED] wrote:
>
> Can we setup a phys
You may be thinking of Sybase.
That is one neat feature about it.
>>> [EMAIL PROTECTED] 07/12/01 12:35PM
>>>Hi List,I have encountered a little strange
incident. Here is a brief:I ran a package which runs every day early
in the morning. I create a logof the process through the spo
The alert log does not capture anything it considers to
be a user error.
HTH,
John
>>> [EMAIL PROTECTED] 07/12/01 12:35PM
>>>Hi List,I have encountered a little strange incident.
Here is a brief:I ran a package which runs every day early in the
morning. I create a logof the process throu
Thank you
John.
-Original Message-From: John Carlson
[mailto:[EMAIL PROTECTED]]Sent: Thursday, July 12, 2001 5:56
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
alert log is not capturing all errors
The alert log does not capture anything it considers
to be a
54 matches
Mail list logo