RE: Alert Log
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 database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- -- background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 see the messages to even be able to speculate. Things are bound to improve in the summer. In the meantime, try checking whether PRE_PAGE_SGA parameter is set to TRUE. That sometimes may increase the instance startup time. Also, was your instance shut down regularly or aborted? The instance may have been engaged in instance recovery. If my initial advice was followed (/ instead of \), I could advise you how to change /etc/init.d/oracle, but because of \, I can't help you. On 12/08/2003 10:04:33 AM, [EMAIL PROTECTED] wrote: Hi List My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- -- background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 parameter is set in the INIT.ORA initialization parameter file. If BACKGROUND_DUMP_DEST is set, the trace files are stored in the directory specified. If the parameter is not set, the trace files are stored in the ORACLE_BASE\ADMIN\DB_NAME\BDUMP directory. This is the same information from the Oracle 9i Administrators Guide for Windows: The alert file is named SIDALRT.LOG and is found in the directory specified by parameter BACKGROUND_DUMP_DEST in the initialization parameter file. If parameter BACKGROUND_DUMP_DEST is not set, then file SIDALRT.LOG is generated in ORACLE_BASE\admin\db_name\bdump. Alert files should be deleted or archived periodically. HTH -Original Message- [EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:05 AM To: Multiple recipients of list ORACLE-L Hi List My database is taking vert long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- -- background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary W. Parker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- - - background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 08, 2003 9:55 AM To: Multiple recipients of list ORACLE-L 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 long time to startup. so I just wanted to check alert log file. But I don't see Alert log in either background_dump_dest or user_dump_dest. Also I check $ORACLE_HOME/database dir and $ORACLE_HOME/admin/{SID}/* (all directory). SQL show parameter dump NAME TYPEVALUE --- - - background_core_dump string partial background_dump_dest string C:\oracle\RDBMS\trace core_dump_dest string %ORACLE_HOME%\RDBMS\TRACE max_dump_file_size string 10240 shadow_core_dump string partial user_dump_dest string C:\oracle\RDBMS\trace SQL Coudl someone shed light on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 for physical standby?
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 find (don't tell you are on Windoze), have you used -follow ? HTH SF - --- Original Message --- - From: Paul Baumgartel [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 11 Sep 2003 07:49:33 I've created a physical standby database that seems to be performing properly, but there's no alert log in user_dump_dest, nor anywhere else on the machine. Is there no alert log until/unless the standby undergoes a role transition? TIA = Paul Baumgartel Transcentive, Inc. www.transcentive.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 for physical standby?
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 standby database that seems to be performing properly, but there's no alert log in user_dump_dest, nor anywhere else on the machine. Is there no alert log until/unless the standby undergoes a role transition? TIA = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 for physical standby?
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 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 standby database that seems to be performing properly, but there's no alert log in user_dump_dest, nor anywhere else on the machine. Is there no alert log until/unless the standby undergoes a role transition? TIA = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). _ Use custom emotions -- try MSN Messenger 6.0! http://www.msnmessenger-download.com/tracking/reach_emoticon -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 for physical standby?--pilot error
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://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 for physical standby?--pilot error
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 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://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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....
Re the annoying leading whitespace: If you're doing this with shell, run it through this filter: sed -e 's/^ *//g' -e 's/^ *//g' ( those blanks are a tab and a space, respectively ) If you are doing it in perl simply use s/^\s+// eg. $line =~ s/^\s+//; HTH Jared 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 careful of grepping for ^ORA-, I occasionally getORA- (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 -Original Message- Sent: Wednesday, August 27, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Roger Xu [EMAIL PROTECTED] for the guy that asked for writing the the alert.log file: dbms_system.ksdwrt(2,'Test line...'); Will write the text to the alert log. Use 1 instead of 2 to write to the trace file Use 3 to write to both. HTH JL __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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....
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 -Original Message- Sent: Wednesday, August 27, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Roger Xu [EMAIL PROTECTED] for the guy that asked for writing the the alert.log file: dbms_system.ksdwrt(2,'Test line...'); Will write the text to the alert log. Use 1 instead of 2 to write to the trace file Use 3 to write to both. HTH JL __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 file
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 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 directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak
RE: alert log file
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 "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AKSent: Monday, March 31, 2003 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: alert log file 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 directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak
RE: alert log file
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-LSubject: alert log file 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 directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak
Re: alert log file
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 directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 file
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 just move this alert log file to another directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 **
Re: alert log file
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 been truncated or backup . Is it a problem if i just move this alert log file to another directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 file
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 then that log line may be lost. As I said, it hasn't happened - yet - that I know of - but YMMV. Cheers, Mike -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: alert log file 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 directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak
RE: alert log file
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: AK [SMTP:[EMAIL PROTECTED] 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 directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak
Re: alert log file
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 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 directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 reporting question
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, I don't think that 'grep' is the tool to use, because it operates mainly line by line (at least this is the way I use it :-)) and the timestamp appears a variable number of lines before the error message. You need some 'short-term memory' to associate the error message to the latest timestamp encountered. I would use awk instead, unless you have a familiarity with perl which I haven't. Before you reinvent the wheel, check the Internet, I think that some tools, possibly some of them free, are available. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 reporting question
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 provide some sense of the timing of the errors... Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:33 AM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 reporting question
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, having an opinion is an art !! -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 24, 2003 7:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: Alert Log reporting question 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 provide some sense of the timing of the errors... Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 24, 2003 1:33 AM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Alert Log reporting question
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 Xing [EMAIL PROTECTED] wrote: 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
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 extra work for no gain hth connor --- Markham, Richard [EMAIL PROTECTED] wrote: Thanks for the info Igor. In addition to this I am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message- Sent: Monday, December 16, 2002 1:30 PM To: Multiple recipients of list ORACLE-L 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] mailto:[EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Monday, December 16, 2002 1:00 PM 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- ] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oracledba.co.uk http://www.oaktable.net http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
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 PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
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 ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: 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 PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
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 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 PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
Title: Message Thanks for the info Igor. In addition to thisI am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] 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 PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: 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 PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
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 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 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 PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
Title: Message 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), and allocation type "USER" for dictionary 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 to thisI am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] 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 PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: 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 PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
Title: Message Rich, You just gave the answer yourself, allocation_type in dba_tablespaces should show UNIFORM for uniform extent allocation. For non-uniform allocation, it will show SYSTEM in that field. If you want to know what is the size of the uniform extent, look for INITIAL_EXTENT 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 curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] 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 PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: 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 PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 suppression
Title: Message ok good thats what I had expected, I found that the particular TS was created differently in another instance. Thanks for your time. -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:39 PMTo: Multiple 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 (exceptLM SYSTEM and UNDO tablespaces in 9.2 , for which "SYSTEM" allocation type is shown), and allocation type "USER" for dictionary 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 to thisI am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] 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 PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: 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 PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression 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 like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 from Remote client
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 new trace file is created?. Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King From: Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 12:19:57 +0300 Subject: Alert log from Remote client Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 from Remote client
Hi sean, My db is oracle816 on WinNT4. Acutally, i want to know how to access alert/trace files from the remote oracle server. Is the DBA should share access to the directory(background_dump_dest) for the remote adminstrator? In other way, i simply want to view the alert logs and trace files 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 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 new trace file is created?. Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA --- End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King From: Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED] Date: Tue, 25 Sep 2001 12:19:57 +0300 Subject: Alert log from Remote client Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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: RE: Alert log from Remote client
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 Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Alert log from Remote client Tony, Kindof a neat package, but I'd be looking for something that does not need a client to use it. I actually monitor my DB's from a program that then sends me the exceptions to it's capabilities. Oh, well, back to the drawing board!! Dick Goulet Reply Separator Author: Aponte; Tony [EMAIL PROTECTED] Date: 9/25/2001 8:15 AM 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- Sent: Tuesday, September 25, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 6.0.4712.0 TITLERE: Alert log from Remote client/TITLE /HEAD BODY !-- Converted from text/plain format -- PFONT SIZE=2Check out AlertView from A HREF=http://www.zephyrus.com/html/products.html;http://www.ze phyrus.com/html/p roducts.html/A.nbsp; It's a java utility that provides a GUI interface to remote alert.log files.nbsp; I think it's still free./FONT/P PFONT SIZE=2Tony/FONT /P PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: Nirmal Kumar Muthu Kumaran [A HREF=mailto:[EMAIL PROTECTED];mailto:[EMAIL PROTECTED]/A ]/FONT BRFONT SIZE=2Sent: Tuesday, September 25, 2001 6:15 AM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SIZE=2Subject: Alert log from Remote client/FONT /P BR PFONT SIZE=2Hi guru's/FONT /P PFONT SIZE=2Suppose that, i'm managing serveral database from a single client. /FONT /P PFONT SIZE=2In that case, how can i find out the alert log/trace files from the client./FONT /P PFONT SIZE=2Any ideas pls./FONT /P PFONT SIZE=2Regards,/FONT BRFONT SIZE=2Nirmal./FONT /P BR PFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com;http://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: Nirmal Kumarnbsp; Muthu Kumaran/FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2 /FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- This
RE: Alert log from Remote client
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:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Subject: Alert log from Remote client Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 from Remote client
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 6:15 AM Hi guru's Suppose that, i'm managing serveral database from a single client. In that case, how can i find out the alert log/trace files from the client. Any ideas pls. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 is not capturing all errors
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 command.Today my package didn't run. It had an error saying 'ERROR at line 1: ORA-04068: existing state of packages has been discarded' . Anyway, not abig deal. I think I eliminated the error.The thing that puzzles me is that error IS NOT in the alert log. I had animpression that alert log would capture ALL of the errors occurring on thesystem. Isn't it the case?Thank you for your support.Lyuda Hoska-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: alert log is not capturing all errors
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 spool command.Today my package didn't run. It had an error saying 'ERROR at line 1: ORA-04068: existing state of packages has been discarded' . Anyway, not abig deal. I think I eliminated the error.The thing that puzzles me is that error IS NOT in the alert log. I had animpression that alert log would capture ALL of the errors occurring on thesystem. Isn't it the case?Thank you for your support.Lyuda Hoska-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: alert log is not capturing all errors
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 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 spool command.Today my package didn't run. It had an error saying 'ERROR at line 1: ORA-04068: existing state of packages has been discarded' . Anyway, not abig deal. I think I eliminated the error.The thing that puzzles me is that error IS NOT in the alert log. I had animpression that alert log would capture ALL of the errors occurring on thesystem. Isn't it the case?Thank you for your support.Lyuda Hoska-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Alert log scan script
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 City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 scan script
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 which I found has been blowing up for some time due to the block corruption. Since Analyze does not create a log I did not know the Analyze was blowing up. Now I know that there are messages in the alert log that would have told me I had problems with the Analyze and the index. To make a long story short I need a good log scan script. Hopefully one that will work on Unix and NT. Mainly Unix. If anyone can help I would appreciate it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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 scan script
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 block on an index. I run Analyze every week which I found has been blowing up for some time due to the block corruption. Since Analyze does not create a log I did not know the Analyze was blowing up. Now I know that there are messages in the alert log that would have told me I had problems with the Analyze and the index. To make a long story short I need a good log scan script. Hopefully one that will work on Unix and NT. Mainly Unix. If anyone can help I would appreciate it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). alerts.sql
RE: Alert log
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 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, PREPARE, INITIALIZE, SPOOL, FINISH HTH, -- Anita --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 May 2001 08:46:06 -0800 DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 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 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, PREPARE, INITIALIZE, SPOOL, FINISH HTH, -- Anita --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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, PREPARE, INITIALIZE, SPOOL, FINISH HTH, -- Anita --- Raj Gopalan [EMAIL PROTECTED] wrote: DBAs My alert.log is clogged with following message.. ARC0: received prod ARC0: Beginning to archive log# 4 seq# 286600 ARC0: Completed archiving log# 4 seq# 286600 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:10:01 2001 ARC1: received prod Fri May 11 16:26:00 2001 LGWR: prodding the archiver Thread 1 advanced to log sequence 286602 Current log# 1 seq# 286602 mem# 0: /hcg1/datafiles/redolog_group1.log Current log# 1 seq# 286602 mem# 1: /hcg2/datafiles/redolog_group1.log Fri May 11 16:26:00 2001 ARC0: received prod ARC0: Beginning to archive log# 5 seq# 286601 ARC0: Completed archiving log# 5 seq# 286601 ARC0: re-scanning for new log files ARC0: prodding the archiver Fri May 11 16:26:03 2001 ARC1: received prod I can understand that log switch is occuring but what these ARC0 messages doing here? I dont remember of enabling any parameter or setting for this.. Could you help me in locating the cause for these messages in alert.log.. TIA Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 am receiving the following bug in my Alert Log. Oracle says it may be because of using PRO*C which we are not using all. Please review the contents and if someone has any idea about it, the input will be appreciated. Thu Jan 25 06:56:15 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:15 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:37 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:37 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:05:05 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:05:05 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:39 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:39 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:59 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:59 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Fri Jan 26 04:43:13 2001 alter database backup controlfile to trace Fri Jan 26 04:43:13 2001 __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shakeel Qureshi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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
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 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 am receiving the following bug in my Alert Log. Oracle says it may be because of using PRO*C which we are not using all. Please review the contents and if someone has any idea about it, the input will be appreciated. Thu Jan 25 06:56:15 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:15 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:37 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10055.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 06:56:37 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10057.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:05:05 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:05:05 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:39 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:39 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:59 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p000_10351.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Thu Jan 25 10:06:59 2001 Errors in file /u01/app/oracle/admin/BPNEXT/bdump/bpnext_p001_10353.trc: ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [], [] Fri Jan 26 04:43:13 2001 alter database backup controlfile to trace Fri Jan 26 04:43:13 2001 __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shakeel Qureshi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shakeel Qureshi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a