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
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
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 vert
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
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
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 physical
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
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
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
[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 careful of grepping for ^ORA-, I occasionally getORA- (spaces)
when I use this. Anjo
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
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
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 another
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
never
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 the db over
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
Sinardy
Sinardy,
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 should
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
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
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. I would
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 [mailto:[EMAIL
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 recipients of list
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's
: 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 PROTECTED
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
ry
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 addition
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 thisI am
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 (exceptLM SYSTEM and UNDO tablespaces in 9.2 , for which
"SYSTEM" allocation type is shown),
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
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 Remote client
Nirmal,
Perhaps
Someone posted this the otherday somewhere...
http://oit.ucsb.edu/~eta/swatch/
Personally I would throw Connor McDonald's alert script on each system.
Very simple and elegant.
http://www.oracledba.co.uk/tips/alert_log_checker.htm
- Ethan
- http://www.geocities.com/epost1
-Original
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 Kumaran [mailto
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, 2001
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 spool
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 through the
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
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
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
week
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
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
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 2001 00:18
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
DBAs
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,
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 check
53 matches
Mail list logo