Re: column session_info appear empty on logminer
if i remember correctly(from a presentation i did like 3 years ago), its a bug. joe Mauricio Vélez wrote: Hello everybody I normally have no problems with logminer. The database es oracle 8.1.7.4.1 on Windows NT but in this case the results show me the username and session_info columns empty Here is the output: (First I created log_detalle_giros_20040124 as select * from v$logmnr_contents where seg_name = 'GIROS') SQL> select username, 2 to_char(timestamp, 'dd/mm/ hh24:mi:ss'), 3 sql_redo, 4 session_info 5 from log_detalle_giros_20040124 6 where sql_redo like '%3420653%'; USERNAME TO_CHAR(TIMESTAMP,' SQL_REDO SESSION_INFO --- -- 24/01/2004 11:48:47 update "LCA"."GIROS" set "CONS ECUTIVO" = -3420653, "REMITENT E" = 'AMINTA CAMACHO ROJAS', " BENEFICIARIO" = 'ELVIA ROJAS D E CAMACHO', "SECUENCIA" = 9304 38, "NUMERO_ORDEN" = '00930438 ', "CODIGO_CORRESPONSAL" = '00 55', "CODIGO_CIUDAD" = '0004', &nb! sp; "FECHA" = TO_DATE('23-ENE-200 4 10:24:07', 'DD-MON- HH24 :MI:SS'), "CODIGO_MONEDAR" = ' 0012', "CODIGO_MONEDAE" = '000 2', "VALORR" = 852,44, "VALORE " = 2299781, "TASA_DE_CAMBIO" = 2697,88, "MENSAJE" = 'AUTORI ZADO EL PAGO CON UN NOMBRE', " CLAVE" = NULL, "TELEFONO1" = ' &nbs! p; 4118035', "TELEFONO2" = NULL, "PAGADO" = 'S', "ACTUALIZADO" = 'N', "ACTIVADO" = 'S', "OBSE RVACIONES" = 'SE AUT PAG//NO S AVE MONT/ES CLTE 18 OPER Y CON F REMIT Y TLF SEG OF/JM.R.', " INVESTIGACION" = 'N' where ROW ID = 'AAAGHoAAOAACviHAAG'; So why do those columns appear empty on v$logmnr_contents? Thanks Mauricio Vélez Oracle DBA Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. *Try it!* <http://us.rd.yahoo.com/evt=21608/*http://webhosting.yahoo.com/ps/sb/> -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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).
column session_info appear empty on logminer
Hello everybodyI normally have no problems with logminer. The database es oracle 8.1.7.4.1 on Windows NT but in this case the results show me the username and session_info columns empty Here is the output: (First I created log_detalle_giros_20040124 as select * from v$logmnr_contents where seg_name = 'GIROS') SQL> select username, 2 to_char(timestamp, 'dd/mm/ hh24:mi:ss'), 3 sql_redo, 4 session_info 5 from log_detalle_giros_20040124 6 where sql_redo like '%3420653%'; USERNAME TO_CHAR(TIMESTAMP,' SQL_REDO SESSION_INFO --- -- 224/01/2004 11:48:47 update "LCA"."GIROS" set "CONS ECUTIVO" = -3420653, "REMITENT E" = 'AMINTA CAMACHO ROJAS', " BENEFICIARIO" = 'ELVIA ROJAS D E CAMACHO', "SECUENCIA" = 9304 38, "NUMERO_ORDEN" = '00930438 ', "CODIGO_CORRESPONSAL" = '00 55', "CODIGO_CIUDAD" = '0004', "FECHA" = TO_DATE('23-ENE-200 4 10:24:07', 'DD-MON- HH24 :MI:SS'), "CODIGO_MONEDAR" = ' 0012', "CODIGO_MONEDAE" = '000 2', "VALORR" = 852,44, "VALORE " = 2299781, "TASA_DE_CAMBIO" = 2697,88, "MENSAJE" = 'AUTORI ZADO EL PAGO CON UN NOMBRE', " CLAVE" = NULL, "TELEFONO1" = ' 4118035', "TELEFONO2" = NULL, "PAGADO" = 'S', "ACTUALIZADO" = 'N', "ACTIVADO" = 'S', "OBSE RVACIONES" = 'SE AUT PAG//NO S AVE MONT/ES CLTE 18 OPER Y CON F REMIT Y TLF SEG OF/JM.R.', " INVESTIGACION" = 'N' where ROW ID = 'AAAGHoAAOAACviHAAG'; So why do those columns appear empty on v$logmnr_contents? Thanks Mauricio Vélez Oracle DBA Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: Redos gone crazy--trying to use logminer
internal usually refers to index maintenance ... In my recent action, I did something like to get a better picture ... SELECT username, seg_owner, seg_name, seg_type ,CASE WHEN stmt LIKE 'UPDATE %' THEN SUBSTR(stmt, 1, INSTR(stmt,'"',1,4)) WHEN stmt LIKE 'INSERT %' THEN SUBSTR(stmt, 1, INSTR(stmt,'"',1,4)) END stmt_type ,CASE WHEN stmt LIKE 'UPDATE %' THEN SUBSTR(stmt, INSTR(stmt,'"',1,4)+1) WHEN stmt LIKE 'INSERT %' THEN SUBSTR(stmt, INSTR(stmt,'"',1,4)+1) END stmt_detail FROM ( SELECT UPPER(sql_redo) stmt FROM sys.tom_logmnr WHERE (sql_redo IS NOT NULL AND LOWER(sql_redo) NOT LIKE 'comm%' AND LOWER(sql_redo) NOT LIKE 'set%' AND LOWER(sql_redo) NOT LIKE 'rollba%' AND sql_redo NOT LIKE '%PERFSTAT%' AND sql_redo NOT LIKE 'Unsupported%')) / where tom_logmnr is the table I built using CTAS from v$lgmnr_contents Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, October 09, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Indeed log miner seems to be my only option for figuring this one out. Log miner is weird!! I had not used it before. interesting... I found this query on metalink, and here are the results. Is this particularly bizarre? This is for 5 redo logs, each of which filled up within 15 minutes. Shouldn't I have something populated for seg_name? Is it particularly screwed up that this field is empty?? Also the count for internal seems high. SQL> select seg_name, count(*) from v$logmnr_contents group by seg_name; SEG_NAME COUNT(*) -- 1128417 SQL> SQL> SQL> spool logminer_qry2.lis SQL> set echo on SQL> -- breakdown of transactions by table, and type SQL> SQL> select seg_name, operation, count(*) 2 from v$logmnr_contents group by seg_name, operation; SEG_NAME OPERATION COUNT(*) -- COMMIT 547 DELETE 1 INSERT 2204 INTERNAL 563760 START 548 UPDATE 561357 6 rows selected. --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > log miner should give you what you want ... why not? > On last friday > something happened and in our database which usually > averages about 100x100M > archive logs, it started throwing 41 files between > 2pm-3pm, 248 between > 3pm-4pm, 95 between 4pm-5pm. > > Of course we couldn't analyze all files, but an > analysis og a 10 minute > interval at the beginning of archive franzy shows a > clear set of 5 SQLS that > repeated about 83000 times in 10 minutes. > > Once we gave it to development, they were able to > identify the process which > was using the code in question and it became easier. > > I'd start at-least half hour before the peak time > and do a slow analysis. > > I have also found that instead of selecting from > v$lgmnr_contents, I am more > comfortable with doign a CTAS and then perform > queries at my leisure for a > detailed analysis. > > Go for log miner ... at-least it will tell you what > caused the problem. > HTH > Raj > > > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly > personal. > QOTD: Any clod can have facts, having an opinion is > an art ! > > > -Original Message- > Sent: Thursday, October 09, 2003 1:09 PM > To: Multiple recipients of list ORACLE-L > > > Hi, list. Ya, I'm still alive and kickin'. > > We have this small database that's running a weird > vendor application. (We get all the gems.) It's on > Solaris 5.8, Oracle 8.1.7.2 > > The database suddenly went from kicking out 50 meg > redo logs 2 or 3 times a day to churning them out > every 15 minutes. The entire database is only about > 6 > gigs; we now sometimes generate 2 or 3 gigs of redo > per day. > > Even tho this started when a "small" change was made > by the vendor, the vendor is claiming that (ok, hold > on to your hats) it was not their change!! > > I want to know what's in those redo logs. > > I initially thought about log miner. However, I'm > not > sure log miner will give me what I want. > > I tried these 2 audit commands. I'm not seeing much > from th
RE: Redos gone crazy--trying to use logminer
Indeed log miner seems to be my only option for figuring this one out. Log miner is weird!! I had not used it before. interesting... I found this query on metalink, and here are the results. Is this particularly bizarre? This is for 5 redo logs, each of which filled up within 15 minutes. Shouldn't I have something populated for seg_name? Is it particularly screwed up that this field is empty?? Also the count for internal seems high. SQL> select seg_name, count(*) from v$logmnr_contents group by seg_name; SEG_NAME COUNT(*) -- 1128417 SQL> SQL> SQL> spool logminer_qry2.lis SQL> set echo on SQL> -- breakdown of transactions by table, and type SQL> SQL> select seg_name, operation, count(*) 2 from v$logmnr_contents group by seg_name, operation; SEG_NAME OPERATION COUNT(*) -- COMMIT 547 DELETE 1 INSERT 2204 INTERNAL 563760 START 548 UPDATE 561357 6 rows selected. --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > log miner should give you what you want ... why not? > On last friday > something happened and in our database which usually > averages about 100x100M > archive logs, it started throwing 41 files between > 2pm-3pm, 248 between > 3pm-4pm, 95 between 4pm-5pm. > > Of course we couldn't analyze all files, but an > analysis og a 10 minute > interval at the beginning of archive franzy shows a > clear set of 5 SQLS that > repeated about 83000 times in 10 minutes. > > Once we gave it to development, they were able to > identify the process which > was using the code in question and it became easier. > > I'd start at-least half hour before the peak time > and do a slow analysis. > > I have also found that instead of selecting from > v$lgmnr_contents, I am more > comfortable with doign a CTAS and then perform > queries at my leisure for a > detailed analysis. > > Go for log miner ... at-least it will tell you what > caused the problem. > HTH > Raj > > > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly > personal. > QOTD: Any clod can have facts, having an opinion is > an art ! > > > -Original Message- > Sent: Thursday, October 09, 2003 1:09 PM > To: Multiple recipients of list ORACLE-L > > > Hi, list. Ya, I'm still alive and kickin'. > > We have this small database that's running a weird > vendor application. (We get all the gems.) It's on > Solaris 5.8, Oracle 8.1.7.2 > > The database suddenly went from kicking out 50 meg > redo logs 2 or 3 times a day to churning them out > every 15 minutes. The entire database is only about > 6 > gigs; we now sometimes generate 2 or 3 gigs of redo > per day. > > Even tho this started when a "small" change was made > by the vendor, the vendor is claiming that (ok, hold > on to your hats) it was not their change!! > > I want to know what's in those redo logs. > > I initially thought about log miner. However, I'm > not > sure log miner will give me what I want. > > I tried these 2 audit commands. I'm not seeing much > from them. Is there another audit command that > might > give me better info? There's only 1 user in the > database, so I only really need to audit 1 user. > > audit all by by access; > audit update table, insert table, delete table by > by access; > > Is there anything else that will be going to redo > that > I can capture with audit?? > > Thanks for any help. > > Barb > > 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.*2 > __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Califo
Re: trigger and LogMiner
Idea for testing: looking for redo associated with select statement(s) that are cleaning out row level locks in block(s) from previously committed DML transaction(s). Have Fun :) Tanel Poder wrote: Hi! Maybe they were thinking that if you audit select statements, you can analyze inserts on AUD$ using logminer later on Anyway, if there's any future release where selects can be in redo, I hope they aren't there by default.. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 10, 2003 2:19 PM Hi Arup and Joe When I wrote the SANS Oracle security step-by-step book I wrote in there the list of restrictions for log miner including that is didn't support selects and during the review process of my book someone in Oracle who was reviewing it informed me that selects would be in the redo in one of the 9i releases, so i changed the book to say fixed in 9i. To be honest I now agree with you, it doesn't make sense for selects to be in the redo, although i suppose they could include them if they wanted to. At least for 9iR1 I am sure they are not included as I did some tests 2 or 3 weeks ago when i was writing a paper "detecting SQL injection on Oracle" for securityfocus.com and selects were definitely not recorded by logminer. I did not also dump the archive log to trace to see if there was no select in it but at least LogMiner does not recognise selects. I copied the list i posted from a file yesterday without thinking i was perpetuating this issue even though i saw myself a few weeks ago it wasn't true. kind regards Pete In article <[EMAIL PROTECTED]>, Arup Nanda <[EMAIL PROTECTED]> writes Hi Pete, I am a little prerplexed by "selects are not recorded in redo prior to 9i ". AFAIK selects are nevere recorded in the redo, and therefore archived logs - so they are never unearthed by LogMiner, even in 9i Release2. Isn't that true? Thanks. Arup -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Chip 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: trigger and LogMiner
Hi! Maybe they were thinking that if you audit select statements, you can analyze inserts on AUD$ using logminer later on Anyway, if there's any future release where selects can be in redo, I hope they aren't there by default.. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 10, 2003 2:19 PM > Hi Arup and Joe > > When I wrote the SANS Oracle security step-by-step book I wrote in there > the list of restrictions for log miner including that is didn't support > selects and during the review process of my book someone in Oracle who > was reviewing it informed me that selects would be in the redo in one of > the 9i releases, so i changed the book to say fixed in 9i. > > To be honest I now agree with you, it doesn't make sense for selects to > be in the redo, although i suppose they could include them if they > wanted to. > > At least for 9iR1 I am sure they are not included as I did some tests 2 > or 3 weeks ago when i was writing a paper "detecting SQL injection on > Oracle" for securityfocus.com and selects were definitely not recorded > by logminer. I did not also dump the archive log to trace to see if > there was no select in it but at least LogMiner does not recognise > selects. I copied the list i posted from a file yesterday without > thinking i was perpetuating this issue even though i saw myself a few > weeks ago it wasn't true. > > kind regards > > Pete > > In article <[EMAIL PROTECTED]>, Arup Nanda > <[EMAIL PROTECTED]> writes > >Hi Pete, > > > >I am a little prerplexed by "selects are not recorded in redo prior to 9i ". > >AFAIK selects are nevere recorded in the redo, and therefore archived logs - > >so they are never unearthed by LogMiner, even in 9i Release2. Isn't that > >true? > > > >Thanks. > > > >Arup > -- > Pete Finnigan > email:[EMAIL PROTECTED] > Web site: http://www.petefinnigan.com - Oracle security audit specialists > Book:Oracle security step-by-step Guide - see http://store.sans.org for details. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pete Finnigan > 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: trigger and LogMiner
Hi Arup and Joe When I wrote the SANS Oracle security step-by-step book I wrote in there the list of restrictions for log miner including that is didn't support selects and during the review process of my book someone in Oracle who was reviewing it informed me that selects would be in the redo in one of the 9i releases, so i changed the book to say fixed in 9i. To be honest I now agree with you, it doesn't make sense for selects to be in the redo, although i suppose they could include them if they wanted to. At least for 9iR1 I am sure they are not included as I did some tests 2 or 3 weeks ago when i was writing a paper "detecting SQL injection on Oracle" for securityfocus.com and selects were definitely not recorded by logminer. I did not also dump the archive log to trace to see if there was no select in it but at least LogMiner does not recognise selects. I copied the list i posted from a file yesterday without thinking i was perpetuating this issue even though i saw myself a few weeks ago it wasn't true. kind regards Pete In article <[EMAIL PROTECTED]>, Arup Nanda <[EMAIL PROTECTED]> writes >Hi Pete, > >I am a little prerplexed by "selects are not recorded in redo prior to 9i ". >AFAIK selects are nevere recorded in the redo, and therefore archived logs - >so they are never unearthed by LogMiner, even in 9i Release2. Isn't that >true? > >Thanks. > >Arup -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: trigger and LogMiner
Arup, I kinda shook my head on that one also. So Pete, you got some inside-scoop that i've missed, i admit i've not much touched logminer in 9ir2(did alot of it and presentations back in 8i days), but have been spending my days now doing DR/RMAN implementations. joe Arup Nanda wrote: Hi Pete, I am a little prerplexed by "selects are not recorded in redo prior to 9i ". AFAIK selects are nevere recorded in the redo, and therefore archived logs - so they are never unearthed by LogMiner, even in 9i Release2. Isn't that true? Thanks. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 6:19 AM Hi Robin, LogMiner is a good tool for forensics, after the fact type work i.e to find out when your junior dba dropped that table. It shouldn't be used to do run of the mill daily work. It has a few deficiencies that are hard to work around: o - log miner user PGA memory so cannot be used in MTS environment o - it doesn't fully support objects o - doesn't support chained or migrated rows (fixed in 9i, not sure which release.) o - doesn't support analysis of clustered tables or indexes or IOT's o - selects are not recorded in redo prior to 9i (again not sure which release). creating a trigger and a history table is far far more sensible and robust. hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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). -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: trigger and LogMiner
Hi Pete, I am a little prerplexed by "selects are not recorded in redo prior to 9i ". AFAIK selects are nevere recorded in the redo, and therefore archived logs - so they are never unearthed by LogMiner, even in 9i Release2. Isn't that true? Thanks. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 6:19 AM > Hi Robin, > > LogMiner is a good tool for forensics, after the fact type work i.e to > find out when your junior dba dropped that table. It shouldn't be used > to do run of the mill daily work. It has a few deficiencies that are > hard to work around: > > o - log miner user PGA memory so cannot be used in MTS environment > o - it doesn't fully support objects > o - doesn't support chained or migrated rows (fixed in 9i, not sure > which release.) > o - doesn't support analysis of clustered tables or indexes or IOT's > o - selects are not recorded in redo prior to 9i (again not sure which > release). > > creating a trigger and a history table is far far more sensible and > robust. > > hth > > kind regards > > Pete > -- > Pete Finnigan > email:[EMAIL PROTECTED] > Web site: http://www.petefinnigan.com - Oracle security audit specialists > Book:Oracle security step-by-step Guide - see http://store.sans.org for details. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pete Finnigan > 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: Arup Nanda 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: trigger and LogMiner
Joe and Pete, Thanks for the response, that confirms my thoughts. Robin Pete Finnigan wrote: > > Hi Robin, > > LogMiner is a good tool for forensics, after the fact type work i.e to > find out when your junior dba dropped that table. It shouldn't be used > to do run of the mill daily work. It has a few deficiencies that are > hard to work around: > > o - log miner user PGA memory so cannot be used in MTS environment > o - it doesn't fully support objects > o - doesn't support chained or migrated rows (fixed in 9i, not sure > which release.) > o - doesn't support analysis of clustered tables or indexes or IOT's > o - selects are not recorded in redo prior to 9i (again not sure which > release). > > creating a trigger and a history table is far far more sensible and > robust. > > hth > > kind regards > > Pete > -- > Pete Finnigan > email:[EMAIL PROTECTED] > Web site: http://www.petefinnigan.com - Oracle security audit specialists > Book:Oracle security step-by-step Guide - see http://store.sans.org for details. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pete Finnigan > 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: Robin Li 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: trigger and LogMiner
Hi Robin, LogMiner is a good tool for forensics, after the fact type work i.e to find out when your junior dba dropped that table. It shouldn't be used to do run of the mill daily work. It has a few deficiencies that are hard to work around: o - log miner user PGA memory so cannot be used in MTS environment o - it doesn't fully support objects o - doesn't support chained or migrated rows (fixed in 9i, not sure which release.) o - doesn't support analysis of clustered tables or indexes or IOT's o - selects are not recorded in redo prior to 9i (again not sure which release). creating a trigger and a history table is far far more sensible and robust. hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: trigger and LogMiner
Robin, only in a recovery situation, but not to track changes consistently, what version of oracle, since in 8i days, logminer didn't support certain datatypes, etc and forget about chained, migrated rows. :) joe Robin Li wrote: Hi all, The users want to keep the old information on certain fields once an update occurs for one (maybe two) table. I recommend to create a history table and use trigger. And the developer says LogMiner is the idea. I played with LogMiner once a year ago. I remember I had to specified a start/end time to let the LogMiner to analyze the redo log. How can I do a constant check on the logs? What is your opinion? Has anyone done this task for tracking changes by using LogMiner? TIA Robin -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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).
trigger and LogMiner
Hi all, The users want to keep the old information on certain fields once an update occurs for one (maybe two) table. I recommend to create a history table and use trigger. And the developer says LogMiner is the idea. I played with LogMiner once a year ago. I remember I had to specified a start/end time to let the LogMiner to analyze the redo log. How can I do a constant check on the logs? What is your opinion? Has anyone done this task for tracking changes by using LogMiner? TIA Robin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robin Li 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:Can logminer be used against 7.3 databases?
Mogens, Dick is right. Metalink Note 74988.1: "LogMiner analyzes redo log files from any version 8.0 or later database that uses the same database character set and runs on the same hardware platform as the analyzing instance" Rgs, Leng. --- From: [EMAIL PROTECTED] Date: Tue, 4 Feb 2003 08:56:35 -0500 Subject: Re:Can logminer be used against 7.3 databases? I went to a seminar on Logminer about a year ago. As I remember you can only use it against 8.0 or better database logfiles due to the change in rowid's that occurred. Dick Goulet Reply Separator Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= <[EMAIL PROTECTED]> Date: 2/3/2003 6:13 PM Friends, Can logminer be used against 7.3 databases (or rather: 7.3 logfiles) like it can be used against 8.0? Best regards, Mogens -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng 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:Can logminer be used against 7.3 databases?
I went to a seminar on Logminer about a year ago. As I remember you can only use it against 8.0 or better database logfiles due to the change in rowid's that occurred. Dick Goulet Reply Separator Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= <[EMAIL PROTECTED]> Date: 2/3/2003 6:13 PM Friends, Can logminer be used against 7.3 databases (or rather: 7.3 logfiles) like it can be used against 8.0? Best regards, Mogens -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: 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: Can logminer be used against 7.3 databases?
I "recall" that the format of the redologs [and archivelogs] changed from Oracle7 to Oracle8. Hemant At 06:13 PM 03-02-03 -0800, you wrote: Friends, Can logminer be used against 7.3 databases (or rather: 7.3 logfiles) like it can be used against 8.0? Best regards, Mogens -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
Can logminer be used against 7.3 databases?
Friends, Can logminer be used against 7.3 databases (or rather: 7.3 logfiles) like it can be used against 8.0? Best regards, Mogens -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: LogMiner errors
see what happens when I listen to Joe present? :) Hey Tim, I can't email you directly to answer your message... your mail server is rejecting yahoo mail --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Rachel is right on target. You can create the package DBMS_LOGMNR_D > in the > v8.0.x database to generate the dictionary file (after stealing the > source > files from a v8.1.x database), but running DBMS_LOGMNR must be done > in a > v8.1.x database. > > If nothing else, create an extremely tiny v8.1.x database and > instance just > for running LogMiner... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, July 03, 2002 5:13 AM > > > > I believe also that you can't actually run LogMiner against an 8.0 > > database but have to generate the dictionary file (which you can > do) > > and then run the mining procedure with the dictionary file against > an > > 8.1.x database > > > > > > --- [EMAIL PROTECTED] wrote: > > > David, > > > > > > I recall that there is a limit (42 characters?) on the name of > the > > > dictionary file. > > > 2 ways round it. Create the file in the top level ie > /export/dict.ora > > > or > > > create a symbolic link with a shorter name. > > > I have a page on my web site which mentions this problem > > > (www.hcresources.co.uk). > > > Unfortunately I do not (yet) have internet access at my new site > and > > > cannot > > > recall what exactly is on the page (I do recall it is not yet > > > finished) > > > > > > HTH > > > > > > John > > > > > > -Original Message- > > > Sent: 02 July 2002 19:19 > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > I tried to run LogMiner to view transactions on Oracle8.0 using > > > LogMiner and > > > received following errors. Can someone please help me to fix > errors. > > > This > > > is HIGH priority that I am working to try to find out who messed > up > > > our > > > database per my Manager. > > > > > > SQL> begin > > > 2 sys.dbms_logmnr.start_logmnr( > > > 3 DictFileName => > '/export/home/oracle/LogMiner/dictionary.ora', > > > 4 StartTime => to_date('01-Jul-2002 08:00:00AM','DD-MON- > > > HH:MI:SSAM'), > > > 5 EndTime => to_date('02-Jul-2002 12:00:00AM','DD-MON- > > > HH:MI:SSAM')); > > > 6 end; > > > 7 / > > > begin > > > * > > > ERROR at line 1: > > > ORA-01280: Fatal LogMiner Error. > > > ORA-06512: at "SYS.DBMS_LOGMNR", line 42 > > > ORA-06512: at line 2 > > > > > > > > > Thanks, > > > David > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Nguyen, David M > > > 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: > > > 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 > sub
RE: LogMiner errors
I got the errors fixed. The reason the errors were generated because it could not find time interval between July 1 and July 2. I was able read redo log with LogMiner but now I come with another question why report display output in HEX data and why it only shows username is "SYS" only? I want to look at some transactions which were made by "DBIMPL" user that is not there. == **Redo log report: USERNAME LOG_ID TIMESTAMPSQL_REDO -- -- - CAAACtAAAT'; SYS 24036 02-JUL-02insert into UNKNOWN.Objn: 12(Col[1],Col[2],Col[3]) values (HEXTORAW('c108'), HEXTORAW('c23b20'),HEXTOR AW('c106')); SYS 24036 02-JUL-02delete from UNKNOWN.Objn: 13 where Col[1] = HEXTORA W('c20c42') and Col[2] = === In addition, my database is running in NOARCHIVE mode does it mean I can not go back to check what happened yesterday or couple days ago? Is there a really good book about LogMiner that I can purchase or a website? Thanks, David -Original Message- Sent: Wednesday, July 03, 2002 6:13 AM To: Multiple recipients of list ORACLE-L I believe also that you can't actually run LogMiner against an 8.0 database but have to generate the dictionary file (which you can do) and then run the mining procedure with the dictionary file against an 8.1.x database --- [EMAIL PROTECTED] wrote: > David, > > I recall that there is a limit (42 characters?) on the name of the > dictionary file. > 2 ways round it. Create the file in the top level ie /export/dict.ora > or > create a symbolic link with a shorter name. > I have a page on my web site which mentions this problem > (www.hcresources.co.uk). > Unfortunately I do not (yet) have internet access at my new site and > cannot > recall what exactly is on the page (I do recall it is not yet > finished) > > HTH > > John > > -Original Message- > Sent: 02 July 2002 19:19 > To: Multiple recipients of list ORACLE-L > > > I tried to run LogMiner to view transactions on Oracle8.0 using > LogMiner and > received following errors. Can someone please help me to fix errors. > This > is HIGH priority that I am working to try to find out who messed up > our > database per my Manager. > > SQL> begin > 2 sys.dbms_logmnr.start_logmnr( > 3 DictFileName => '/export/home/oracle/LogMiner/dictionary.ora', > 4 StartTime => to_date('01-Jul-2002 08:00:00AM','DD-MON- > HH:MI:SSAM'), > 5 EndTime => to_date('02-Jul-2002 12:00:00AM','DD-MON- > HH:MI:SSAM')); > 6 end; > 7 / > begin > * > ERROR at line 1: > ORA-01280: Fatal LogMiner Error. > ORA-06512: at "SYS.DBMS_LOGMNR", line 42 > ORA-06512: at line 2 > > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, David M > 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: > 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!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the officia
Re: LogMiner errors
Rachel is right on target. You can create the package DBMS_LOGMNR_D in the v8.0.x database to generate the dictionary file (after stealing the source files from a v8.1.x database), but running DBMS_LOGMNR must be done in a v8.1.x database. If nothing else, create an extremely tiny v8.1.x database and instance just for running LogMiner... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 03, 2002 5:13 AM > I believe also that you can't actually run LogMiner against an 8.0 > database but have to generate the dictionary file (which you can do) > and then run the mining procedure with the dictionary file against an > 8.1.x database > > > --- [EMAIL PROTECTED] wrote: > > David, > > > > I recall that there is a limit (42 characters?) on the name of the > > dictionary file. > > 2 ways round it. Create the file in the top level ie /export/dict.ora > > or > > create a symbolic link with a shorter name. > > I have a page on my web site which mentions this problem > > (www.hcresources.co.uk). > > Unfortunately I do not (yet) have internet access at my new site and > > cannot > > recall what exactly is on the page (I do recall it is not yet > > finished) > > > > HTH > > > > John > > > > -Original Message- > > Sent: 02 July 2002 19:19 > > To: Multiple recipients of list ORACLE-L > > > > > > I tried to run LogMiner to view transactions on Oracle8.0 using > > LogMiner and > > received following errors. Can someone please help me to fix errors. > > This > > is HIGH priority that I am working to try to find out who messed up > > our > > database per my Manager. > > > > SQL> begin > > 2 sys.dbms_logmnr.start_logmnr( > > 3 DictFileName => '/export/home/oracle/LogMiner/dictionary.ora', > > 4 StartTime => to_date('01-Jul-2002 08:00:00AM','DD-MON- > > HH:MI:SSAM'), > > 5 EndTime => to_date('02-Jul-2002 12:00:00AM','DD-MON- > > HH:MI:SSAM')); > > 6 end; > > 7 / > > begin > > * > > ERROR at line 1: > > ORA-01280: Fatal LogMiner Error. > > ORA-06512: at "SYS.DBMS_LOGMNR", line 42 > > ORA-06512: at line 2 > > > > > > Thanks, > > David > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Nguyen, David M > > 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: > > 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!? > Sign up for SBC Yahoo! Dial - First Month Free > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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).
RE: LogMiner errors
I believe also that you can't actually run LogMiner against an 8.0 database but have to generate the dictionary file (which you can do) and then run the mining procedure with the dictionary file against an 8.1.x database --- [EMAIL PROTECTED] wrote: > David, > > I recall that there is a limit (42 characters?) on the name of the > dictionary file. > 2 ways round it. Create the file in the top level ie /export/dict.ora > or > create a symbolic link with a shorter name. > I have a page on my web site which mentions this problem > (www.hcresources.co.uk). > Unfortunately I do not (yet) have internet access at my new site and > cannot > recall what exactly is on the page (I do recall it is not yet > finished) > > HTH > > John > > -Original Message- > Sent: 02 July 2002 19:19 > To: Multiple recipients of list ORACLE-L > > > I tried to run LogMiner to view transactions on Oracle8.0 using > LogMiner and > received following errors. Can someone please help me to fix errors. > This > is HIGH priority that I am working to try to find out who messed up > our > database per my Manager. > > SQL> begin > 2 sys.dbms_logmnr.start_logmnr( > 3 DictFileName => '/export/home/oracle/LogMiner/dictionary.ora', > 4 StartTime => to_date('01-Jul-2002 08:00:00AM','DD-MON- > HH:MI:SSAM'), > 5 EndTime => to_date('02-Jul-2002 12:00:00AM','DD-MON- > HH:MI:SSAM')); > 6 end; > 7 / > begin > * > ERROR at line 1: > ORA-01280: Fatal LogMiner Error. > ORA-06512: at "SYS.DBMS_LOGMNR", line 42 > ORA-06512: at line 2 > > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, David M > 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: > 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!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: LogMiner errors
David, I recall that there is a limit (42 characters?) on the name of the dictionary file. 2 ways round it. Create the file in the top level ie /export/dict.ora or create a symbolic link with a shorter name. I have a page on my web site which mentions this problem (www.hcresources.co.uk). Unfortunately I do not (yet) have internet access at my new site and cannot recall what exactly is on the page (I do recall it is not yet finished) HTH John -Original Message- Sent: 02 July 2002 19:19 To: Multiple recipients of list ORACLE-L I tried to run LogMiner to view transactions on Oracle8.0 using LogMiner and received following errors. Can someone please help me to fix errors. This is HIGH priority that I am working to try to find out who messed up our database per my Manager. SQL> begin 2 sys.dbms_logmnr.start_logmnr( 3 DictFileName => '/export/home/oracle/LogMiner/dictionary.ora', 4 StartTime => to_date('01-Jul-2002 08:00:00AM','DD-MON- HH:MI:SSAM'), 5 EndTime => to_date('02-Jul-2002 12:00:00AM','DD-MON- HH:MI:SSAM')); 6 end; 7 / begin * ERROR at line 1: ORA-01280: Fatal LogMiner Error. ORA-06512: at "SYS.DBMS_LOGMNR", line 42 ORA-06512: at line 2 Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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: 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).
LogMiner errors
I tried to run LogMiner to view transactions on Oracle8.0 using LogMiner and received following errors. Can someone please help me to fix errors. This is HIGH priority that I am working to try to find out who messed up our database per my Manager. SQL> begin 2 sys.dbms_logmnr.start_logmnr( 3 DictFileName => '/export/home/oracle/LogMiner/dictionary.ora', 4 StartTime => to_date('01-Jul-2002 08:00:00AM','DD-MON- HH:MI:SSAM'), 5 EndTime => to_date('02-Jul-2002 12:00:00AM','DD-MON- HH:MI:SSAM')); 6 end; 7 / begin * ERROR at line 1: ORA-01280: Fatal LogMiner Error. ORA-06512: at "SYS.DBMS_LOGMNR", line 42 ORA-06512: at line 2 Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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).
LogMiner - Null Username
Does anyone know why USERNAME in V$LOGMNR_CONTENTS is not always populated? I have encountered numerous instances where a select like 'Select username, sql_redo from v$logmnr_contents' shows a username for some operations and no username for others. I have also noticed that DELETE operations always have a null Username. Any ideas? Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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).
LogMiner - Null Username
Does anyone know why USERNAME in V$LOGMNR_CONTENTS is not always populated? I have encountered numerous instances where a select like 'Select username, sql_redo from v$logmnr_contents' shows a username for some operations and no username for others. I have also noticed that DELETE operations always have a null Username. Thanks. -w -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: Logminer - again
Most of the transactions in the redo log are written in this way: SQL_REDO set transaction read write; insert/update/delete something commit; 'set transaction read write' is the default setting for a transaction and that's why it's there, I quess. Commit is self explaining. The statements with username = 'SYS' are either you doing something as SYS or recursive SQL. Lyubomir Petrov --- John Dunn <[EMAIL PROTECTED]> wrote: > Logminer shows a large number of entries in redo > logs for SYS as follows : > > What generates these? > > > select timestamp,username, sql_redo from > v$logmnr_contents > -- > > 03-19-2002:12:31:24 SYS > > 03-19-2002:12:31:24 SYS > commit; > > 03-19-2002:12:31:27 SYS > set transaction read write; > > John > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: John Dunn > 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! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyubomir Petrov 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).
Logminer - again
Logminer shows a large number of entries in redo logs for SYS as follows : What generates these? select timestamp,username, sql_redo from v$logmnr_contents -- 03-19-2002:12:31:24 SYS 03-19-2002:12:31:24 SYS commit; 03-19-2002:12:31:27 SYS set transaction read write; John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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).
Logminer
Thanks That worked. Another question re logminer. I notice that must of the values in sql_redo column are simply : commit; set transaction read write; What does this mean? John > -Original Message- > From: Lyubomir Petrov [SMTP:[EMAIL PROTECTED]] > Sent: 18 March 2002 17:25 > To: Multiple recipients of list ORACLE-L > Subject: Re: Logminer > > Hi John, > > You did not mention the Oracle version, but I hope > this will help. > > In $ORACLE_HOME/rdbms/admin/dbmslmd.sql (the script > that builds DBMS_LOGMNR_D package) there is a line: > > TYPE col_desc_array IS VARRAY(513) OF col_description; > > Replace it with something like: > > TYPE col_desc_array IS VARRAY(1000) OF > col_description; > > and then rebuild the package. > > > HTH, > Lyubomir Petrov > > > --- John Dunn <[EMAIL PROTECTED]> wrote: > > I get the following error when running > > SYS.DBMS_LOGMNR_D > > > > ERROR at line 1: > > ORA-06532: Subscript outside of limit > > ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793 > > ORA-06512: at line 1 > > > > Anyone else seen this? > > > > John > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: John Dunn > > 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! Sports - live college hoops coverage > http://sports.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Lyubomir Petrov > 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: John Dunn 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: Logminer
Hi John, You did not mention the Oracle version, but I hope this will help. In $ORACLE_HOME/rdbms/admin/dbmslmd.sql (the script that builds DBMS_LOGMNR_D package) there is a line: TYPE col_desc_array IS VARRAY(513) OF col_description; Replace it with something like: TYPE col_desc_array IS VARRAY(1000) OF col_description; and then rebuild the package. HTH, Lyubomir Petrov --- John Dunn <[EMAIL PROTECTED]> wrote: > I get the following error when running > SYS.DBMS_LOGMNR_D > > ERROR at line 1: > ORA-06532: Subscript outside of limit > ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793 > ORA-06512: at line 1 > > Anyone else seen this? > > John > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: John Dunn > 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! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyubomir Petrov 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).
Logminer
I get the following error when running SYS.DBMS_LOGMNR_D ERROR at line 1: ORA-06532: Subscript outside of limit ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793 ORA-06512: at line 1 Anyone else seen this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: LogMiner and ORA-03113
Just that there have been numerous bugs in logminer with blocksizes != 2K. joe Walter K wrote: > Block size is 8k. Interesting, how is the block size > related? > > > --- Joe Testa <[EMAIL PROTECTED]> wrote: > >>whats your blocksize, anything other than 2K has >>been know to cause all >>kinds of problems. >> >>joe >> >> >>Walter K wrote: >> >> >>>I'm trying to analyze some archive logs via >>> >>LogMiner >> >>>and I keep getting the error ORA-03113 (end of >>> >>file on >> >>>communications channel) when I query the >>>V$LOGMNR_CONTENTS view. I did a "new" and "start" >>>prior to running the query. This process that I am >>>going through works on some log files but not on >>>others. The log files aren't corrupted because I >>> >>can >> >>>restore/recover the database and apply the logs >>>successfully for a roll-forward. I'm just running >>> >>a >> >>>'select count(*)' query at this point. >>> >>>Has anyone else encountered this and come up with >>> >>a >> >>>solution? >>> >>>I've checked MetaLink, Google, etc and so far have >>> >>not >> >>>come up with anything that describes what may be >>> >>the >> >>>cause. I'm running 8.1.7.2 (64bit) on Solaris 8. >>> >>>MANY thanks in advance. >>> >>>-w >>> >>>__ >>>Do You Yahoo!? >>>Send FREE video emails in Yahoo! Mail! >>>http://promo.yahoo.com/videomail/ >>> >>> >> >>-- >>Joe Testa, Oracle DBA >>Want to have a good time with a bunch of geeks? >>Check out: >> >> > http://www.geekcruises.com/standard_interface/future_cruises.html > >>I'm presenting, when registering drop my name :) >> >> >> >> >> >> >>-- >>Please see the official ORACLE-L FAQ: >>http://www.orafaq.com >>-- >>Author: Joe Testa >> 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!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: LogMiner and ORA-03113
Block size is 8k. Interesting, how is the block size related? --- Joe Testa <[EMAIL PROTECTED]> wrote: > whats your blocksize, anything other than 2K has > been know to cause all > kinds of problems. > > joe > > > Walter K wrote: > > > I'm trying to analyze some archive logs via > LogMiner > > and I keep getting the error ORA-03113 (end of > file on > > communications channel) when I query the > > V$LOGMNR_CONTENTS view. I did a "new" and "start" > > prior to running the query. This process that I am > > going through works on some log files but not on > > others. The log files aren't corrupted because I > can > > restore/recover the database and apply the logs > > successfully for a roll-forward. I'm just running > a > > 'select count(*)' query at this point. > > > > Has anyone else encountered this and come up with > a > > solution? > > > > I've checked MetaLink, Google, etc and so far have > not > > come up with anything that describes what may be > the > > cause. I'm running 8.1.7.2 (64bit) on Solaris 8. > > > > MANY thanks in advance. > > > > -w > > > > __ > > Do You Yahoo!? > > Send FREE video emails in Yahoo! Mail! > > http://promo.yahoo.com/videomail/ > > > > > -- > Joe Testa, Oracle DBA > Want to have a good time with a bunch of geeks? > Check out: > http://www.geekcruises.com/standard_interface/future_cruises.html > I'm presenting, when registering drop my name :) > > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Joe Testa > 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!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: LogMiner and ORA-03113
whats your blocksize, anything other than 2K has been know to cause all kinds of problems. joe Walter K wrote: > I'm trying to analyze some archive logs via LogMiner > and I keep getting the error ORA-03113 (end of file on > communications channel) when I query the > V$LOGMNR_CONTENTS view. I did a "new" and "start" > prior to running the query. This process that I am > going through works on some log files but not on > others. The log files aren't corrupted because I can > restore/recover the database and apply the logs > successfully for a roll-forward. I'm just running a > 'select count(*)' query at this point. > > Has anyone else encountered this and come up with a > solution? > > I've checked MetaLink, Google, etc and so far have not > come up with anything that describes what may be the > cause. I'm running 8.1.7.2 (64bit) on Solaris 8. > > MANY thanks in advance. > > -w > > __ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
LogMiner and ORA-03113
I'm trying to analyze some archive logs via LogMiner and I keep getting the error ORA-03113 (end of file on communications channel) when I query the V$LOGMNR_CONTENTS view. I did a "new" and "start" prior to running the query. This process that I am going through works on some log files but not on others. The log files aren't corrupted because I can restore/recover the database and apply the logs successfully for a roll-forward. I'm just running a 'select count(*)' query at this point. Has anyone else encountered this and come up with a solution? I've checked MetaLink, Google, etc and so far have not come up with anything that describes what may be the cause. I'm running 8.1.7.2 (64bit) on Solaris 8. MANY thanks in advance. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: Logminer in different SID
Aldi - My advice is to use Logminer on your production database. I am assuming that your DEV database is a copy or clone of your production database. However, Logminer won't have the correct file names, for example. You will have to go back to production, find the file you want, find the file_id, convert that file_id to hex, then enter that into Logminer. Even if your DEV is a clone of production. The data values will also be in hex. It can be done, but it is probably much more useful to simply build the Logminer dictionary on production. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 17, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Hi Listers, I copied the archived logfiles from production database (PROD) and trying to start logminer in development (DEV) database (same platform but different SID). execute dbms_logmnr.start_logmnr(dictfilename => '/u01/prodlog.ora'); I got the ora 01295 error. Can we analyze logfiles (start logminer) from the different SID ? Oracle 8161 on LInux. Tia, Aldi 01295, 0, "DB_ID mismatch between dictionary %s and logfiles" // *Cause: The dictionary file is produced by a database that is different // from that produced the logfiles. // *Action: Specify a compatible dictionary file. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco 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: DENNIS WILLIAMS 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).
Logminer in different SID
Hi Listers, I copied the archived logfiles from production database (PROD) and trying to start logminer in development (DEV) database (same platform but different SID). execute dbms_logmnr.start_logmnr(dictfilename => '/u01/prodlog.ora'); I got the ora 01295 error. Can we analyze logfiles (start logminer) from the different SID ? Oracle 8161 on LInux. Tia, Aldi 01295, 0, "DB_ID mismatch between dictionary %s and logfiles" // *Cause: The dictionary file is produced by a database that is different // from that produced the logfiles. // *Action: Specify a compatible dictionary file. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco 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).
Logminer in different SID
Hi Listers, I copied the archived logfiles from production database (PROD) and trying to start logminer in development (DEV) database (same platform but different SID). execute dbms_logmnr.start_logmnr(dictfilename => '/u01/prodlog.ora'); I got the ora 01295 error. Can we analyze logfiles (start logminer) from the different SID ? Oracle 8161 on LInux. Tia, Aldi 01295, 0, "DB_ID mismatch between dictionary %s and logfiles" // *Cause: The dictionary file is produced by a database that is different // from that produced the logfiles. // *Action: Specify a compatible dictionary file. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco 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).
Logminer Question
Hi, I have a process that inserts several rows into a table. Each row contains a timestamp field that shows the time it was inserted. When I interrogate Logminer looking for these rows, not all of them are shown. It stops after a certain point. A commit was done and I know I have the right redo log, but I don't see the rows from Logminer. Why would that be? Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO 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: Audit vs Logminer
I have used LogMiner once, and I was quite surprised at the Redo Log details. For example, all SQL that does not modify the database will not be captured into the Redo Log file. (eg, SELECT statement). But Auditing definitely can capture all these. Similarly if you issue the same update statement multiple nos of times, only one is updated into the Redo Log file. Auditing will record multiple nos of times as entered. Peter Teoh [EMAIL PROTECTED] http://web.singnet.com.sg/~petermag/oracle.html - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 5:45 AM > 8i Database, W2K server. Apps team looking for audit trail functionality. > I've outlined the pros and cons of Oracle Audit vs using Logminer to extract > audit info from archived redo logs as below: > > - Archiving of Redo Logs will be carried out in any case. > - All required auditing data as far as I can determine would be captured in > redo logs. > - Using Logminer to investigate them looks like it would be more difficult > than using Oracles Auditing features. > - Introducing Oracle Auditing has limited functionality and has a > performance overhead. > - Oracle auditing would require programming of triggers to capture before > and after values which in turn has another potential performance hit. > - Oracle audit data needs to be monitored and requires additional management > time. > > I've not used Oracle Auditing or Logminer so the above is based upon some > reading I've done. If I've missed any important points please give me > feedback on same. Also anyone any opinions, or better still experience, as > to which is better from performance POV. > > - > Sean O' Neill > Organon (Ireland) Ltd. > [subscribed: digest mode] > -- > 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: Peter Teoh 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).
Audit vs Logminer
8i Database, W2K server. Apps team looking for audit trail functionality. I've outlined the pros and cons of Oracle Audit vs using Logminer to extract audit info from archived redo logs as below: - Archiving of Redo Logs will be carried out in any case. - All required auditing data as far as I can determine would be captured in redo logs. - Using Logminer to investigate them looks like it would be more difficult than using Oracles Auditing features. - Introducing Oracle Auditing has limited functionality and has a performance overhead. - Oracle auditing would require programming of triggers to capture before and after values which in turn has another potential performance hit. - Oracle audit data needs to be monitored and requires additional management time. I've not used Oracle Auditing or Logminer so the above is based upon some reading I've done. If I've missed any important points please give me feedback on same. Also anyone any opinions, or better still experience, as to which is better from performance POV. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- 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: Logminer Question
Ed, in the 8i world, there is more than you want to know amount of redo/undo that goes on where the username is not available. The format of the redo logs(or oracle intentionally left out) leaves a bit to be desired in the version of lognminer for 8i. 9i its a whole lot better. some of the reasons are data dictionary allocation and deallocation of extents as well as any rows that are migrated and /or chained will not give you much to look at it the logs. hth, joe Ed Bittel wrote: > > I'm analyzing archive logs from an 8.1.6.3 database > running on Solaris. There are many entries in > v$logmnr_contents with a NULL username and DATA_OBJ# > and DATA_OBJD# values that don't match anything I can > find in sys.obj$. What would account for these > entries in v$logmnr_contents? > > Example > === > SELECT username, OPERATION, count(*) > FROM v$logmnr_contents group by username, operation > / > > USERNAME OPERATION COUNT(*) > -- -- > WANT_NUTS COMMIT 301 > WANT_NUTS DELETE4 > WANT_NUTS INSERT4 > WANT_NUTS INTERNAL884 > WANT_NUTS START 301 > WANT_NUTS UPDATE 296 > ZEDWARDS COMMIT3 > ZEDWARDS INSERT 446 > ZEDWARDS INTERNAL 15 > ZEDWARDS START 4 > OKSERVER1 COMMIT 20 > OKSERVER1 DELETE 30 > OKSERVER1 INSERT 296 > OKSERVER1 INTERNAL269 > OKSERVER1 START20 > OKSERVER1 UPDATE 163 > SYSCOMMIT 4034 > SYSDELETE 291 > SYSINSERT 71 > SYSINTERNAL 6997 > SYSSTART 4036 > SYSUPDATE 4346 > COMMIT7 > DELETE 1235 > INSERT 2242 > INTERNAL843 > START 2 > UNSUPPORTED 266 > UPDATE59002 > > 37 rows selected. > > FYI, data from this database is being replicated via > snapshot to a reporting database. Could that be > responsible for the NULL username entries? > > Solaris 7 & Oracle 8.1.6.3 > > __ > Do You Yahoo!? > Find the one for you at Yahoo! Personals > http://personals.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ed Bittel > 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) -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
Logminer Question
I'm analyzing archive logs from an 8.1.6.3 database running on Solaris. There are many entries in v$logmnr_contents with a NULL username and DATA_OBJ# and DATA_OBJD# values that don't match anything I can find in sys.obj$. What would account for these entries in v$logmnr_contents? Example === SELECT username, OPERATION, count(*) FROM v$logmnr_contents group by username, operation / USERNAME OPERATION COUNT(*) -- -- WANT_NUTS COMMIT 301 WANT_NUTS DELETE4 WANT_NUTS INSERT4 WANT_NUTS INTERNAL884 WANT_NUTS START 301 WANT_NUTS UPDATE 296 ZEDWARDS COMMIT3 ZEDWARDS INSERT 446 ZEDWARDS INTERNAL 15 ZEDWARDS START 4 OKSERVER1 COMMIT 20 OKSERVER1 DELETE 30 OKSERVER1 INSERT 296 OKSERVER1 INTERNAL269 OKSERVER1 START20 OKSERVER1 UPDATE 163 SYSCOMMIT 4034 SYSDELETE 291 SYSINSERT 71 SYSINTERNAL 6997 SYSSTART 4036 SYSUPDATE 4346 COMMIT7 DELETE 1235 INSERT 2242 INTERNAL843 START 2 UNSUPPORTED 266 UPDATE59002 37 rows selected. FYI, data from this database is being replicated via snapshot to a reporting database. Could that be responsible for the NULL username entries? Solaris 7 & Oracle 8.1.6.3 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Bittel 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).
{9i New Feature: Logminer } This one is long also
IMPORTANT NOTE: This will only cover the NEW features of logminer, this is NOT an exhaustive study on how logminer works, SO this means you need to already know how logminer works as the beginning aspects are not covered here. NOTE: the majority of this info comes from metalink doc id: 148616.1, dated Oct 11, 2001 If you want the total ins/outs of logminer, come and see me at IOUG-A, if all goes well, i'll be doing a 2 hr mini-lesson on the logminer, beginning (just what is a redo log) thru advanced(can i track DDL changes and how does it affect me for looking at old data before the table had a column added), and we'll contrast/compare the command line versus the GUI logminer viewer that comes with OEM. and now back to the show: Logminer has been enhanced quite a bit in 9i. Here are the features that will be discussed in this segment: New Dictionary options Redo log files as dictionary Online data dictionaryDDL TrackingSkipping past redo log corruptionSkip uncommited transactionsChained/Migrated rowsClustered TablesDirect Path Insert LoggingSupplemental LoggingMine_value functionColumn_present functionGUI - New Dictionary options: Back in the 8i days, there was only flat file dictionary option. This has been expanded to include: Redo log files as dictionary: This is where the current dictionary is written to the redo logs, there are restrictions: DBMS_LOGMNR_D.BUILD must be run on an Oracle9i database The database must be in archivelog mode The COMPATIBLE parameter value must be set to 9.0.X The dictionary must belong to the same database as the redo logs to be analyzed No DDL is allowed during the dictionary extraction SQL> execute DBMS_LOGMNR.START_LOGMNR(options => -> dbms_logmnr.dict_from_redo_logs); Online data dictionary: This means you will be using the current data dictionary as it exists right now in the database. To instruct LogMiner to use the database data dictionary, simply provide this option to the DBMS_LOGMNR.START_LOGMNR procedure after adding the logs to be analyzed. No dictionary build is done.SQL> execute DBMS_LOGMNR.START_LOGMNR(options => -dbms_logmnr.dict_from_online_catalog); -DDL Tracking: A. LogMiner automatically records the SQL statement used for a DDL operation as such, so that operations like a DROP/ALTER/CREATE table can be easily tracked. In Oracle8i, only the internal operations to the data dictionary are recorded and it is difficult to track these operations (A DROP table results in several DML statements against the data dictionary). B. By specifying the DBMS_LOGMNR.DDL_DICT_TRACKING option when starting LogMiner, the LogMiner internal dictionary is updated if a DDL event is found in the redo log files. This allows the SQL_REDO in V$LOGMNR_CONTENTS to accurately display information for objects that are modified by user DML statements after LogMiner dictionary is built. This option is not valid with the DICT_FROM_ONLINE_CATALOG option. 1. Build the dictionary: SQL> execute DBMS_LOGMNR_D.BUILD ('dictionary.ora', '/database/9i/logminer'); 2. Alter the table to add a column : SQL> alter table test add(c4 number); 3. Add the log which contains the ALTER statement: SQL> execute DBMS_LOGMNR.ADD_LOGFILE(logfilename => '/database/9i/arch/1_683.dbf', options => dbms_logmnr.new); 4. Start the log analysis: => Without the DDL_DICT_TRACKING option: SQL> execute DBMS_LOGMNR.START_LOGMNR(dictfilename => '/database/9i/logminer/dictionary.ora'); V$LOGMNR_CONTENTS.SQL_REDO contains: insert into "SCOTT"."TEST"("COL 1","COL 2","COL 3","COL 4") values(HEXTORAW('c102'), HEXTORAW('c103'), HEXTORAW('c104'), HEXTORAW('c105')); => With the DDL_DICT_TRACKING option: SQL> execute DBMS_LOGMNR.START_LOGMNR(dictfilename => '/database/9i/logminer/dictionary.ora', options =>dbms_logmnr.ddl_dict_tracking); V$LOGMNR_CONTENTS.SQL_REDO contains: insert into "SCOTT"."TEST"("C1","C2","C3","C4") values ('1','2','3','4'); Note: You must be sure that you have included the log which contains the DDL statement in the logs to be analyzed with DBMS_LOGMNR.ADD_LOGFILE. -
Re: logminer in the 9i world, etc
On Tue, 12 Jun 2001,Joseph S. Testa scribbled on the wall in glitter crayon: ->yes, except that i'm one of those sick pups that reads the docs. -> ->joe OK everybody remember to not tell joe RTFM because he already has.;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ New: It comes in different colors from the previous version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: logminer in the 9i world, etc
Hi H !!! -Original Message- Sent: 12 June 2001 23:05 To: Multiple recipients of list ORACLE-L Hey Joe, Will that be Logminer 102 or 103 ? Do I need to bring Miner's uniform (the hat and all) ? Cheers! - Kirti > -Original Message- > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 2:52 PM > To: Multiple recipients of list ORACLE-L > Subject: logminer in the 9i world, etc > > Well afetr reading the docs about logminer in version 9i, maybe i can get > one more year worth of presentation out of it. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: logminer in the 9i world, etc
well i'm basing my statement on the docs(which isn't much i know) but as soon as its on a platform i can use, i'll tets it out and let everyone know for sure :) joe > Nick Wagner wrote: > > Either way... I tried it with 9.0.0.0.0 beta 3 and I got the normal > DML to work just fine. However I could not get the DDL to work.. I > set the parameters just like the doc says, but all my DDL queries just > seamed to go out to lunch on me... > > My log files were very small for the testing... 5 MB files, and I > only did 3 DDL statements... > > anyone else have this problem. > > Nick > > -Original Message- > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 3:57 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: logminer in the 9i world, etc > > The question should be, "Can it undo DDL?" > > Ian MacGregor > Stanford Linear Accelerator Center > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, June 12, 2001 1:19 PM > To: Multiple recipients of list ORACLE-L > > Can it redo DDL? > > Alex Hillman > > -Original Message- > Sent: Tuesday, June 12, 2001 3:52 PM > To: Multiple recipients of list ORACLE-L > > Well afetr reading the docs about logminer in version 9i, maybe i can > get > one more year worth of presentation out of it. > > it tracks and displays DDL :) > > useless trivia question(i know the answer) :) > > So what do you get with the new datatype: timestamp > > Joe > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph Testa > 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: Hillman, Alex > 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: MacGregor, Ian A. > 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: logminer in the 9i world, etc
Title: RE: logminer in the 9i world, etc Either way... I tried it with 9.0.0.0.0 beta 3 and I got the normal DML to work just fine. However I could not get the DDL to work.. I set the parameters just like the doc says, but all my DDL queries just seamed to go out to lunch on me... My log files were very small for the testing... 5 MB files, and I only did 3 DDL statements... anyone else have this problem. Nick -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject: RE: logminer in the 9i world, etc The question should be, "Can it undo DDL?" Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 12, 2001 1:19 PM To: Multiple recipients of list ORACLE-L Can it redo DDL? Alex Hillman -Original Message- Sent: Tuesday, June 12, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Hillman, Alex 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: MacGregor, Ian A. 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: logminer in the 9i world, etc
yes according to the docs. joe "Hillman, Alex" wrote: > > Can it redo DDL? > > Alex Hillman > > -Original Message- > Sent: Tuesday, June 12, 2001 3:52 PM > To: Multiple recipients of list ORACLE-L > > Well afetr reading the docs about logminer in version 9i, maybe i can get > one more year worth of presentation out of it. > > it tracks and displays DDL :) > > useless trivia question(i know the answer) :) > > So what do you get with the new datatype: timestamp > > Joe > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph Testa > 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: Hillman, Alex > 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: logminer in the 9i world, etc
Linda, yes list admin send her a prize :) joe "Seley, Linda" wrote: > > Oh oh, wild guess milliseconds? > > -Original Message- > Sent: Tuesday, June 12, 2001 4:05 PM > To: Multiple recipients of list ORACLE-L > > yes, except that i'm one of those sick pups that reads the docs. > > joe > "Thater, William" wrote: > > > > On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: > > > > ->Well afetr reading the docs about logminer in version 9i, maybe i can > get > > ->one more year worth of presentation out of it. > > -> > > ->it tracks and displays DDL :) > > -> > > -> > > ->useless trivia question(i know the answer) :) > > -> > > -> > > ->So what do you get with the new datatype: timestamp > > > > bored?;-) > > > > -- > > Bill "Shrek" Thater Certifiable ORACLE DBA > > Telergy, Inc.[EMAIL PROTECTED] > > ~~ > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work. > > ~~ > > The Soviet Union does not exist any more in its present format. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Thater, William > > 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) > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask:) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: logminer in the 9i world, etc
Paul, it didnt get picked up for the IOUG live 2001. I've bored the local user group to death with logminer(as well as alot of other people i'm sure). I'll make sure you get you a copy of it in jul. joe Paul Drake wrote: > > Joe, > > I didn't get to see the advanced logminer presentation at IOUG-A. > - is that one 201? > - any chance of seeing it at your user group meeting in July? > - does it exist in print anywhere? > > Paul > > -Original Message- > Sent: Tuesday, June 12, 2001 6:05 PM > To: Multiple recipients of list ORACLE-L > > Hey Joe, > Will that be Logminer 102 or 103 ? > > Do I need to bring Miner's uniform (the hat and all) ? > > Cheers! > > - Kirti > > > -Original Message- > > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, June 12, 2001 2:52 PM > > To: Multiple recipients of list ORACLE-L > > Subject: logminer in the 9i world, etc > > > > Well afetr reading the docs about logminer in version 9i, maybe i can get > > one more year worth of presentation out of it. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: logminer in the 9i world, etc
The question should be, "Can it undo DDL?" Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 12, 2001 1:19 PM To: Multiple recipients of list ORACLE-L Can it redo DDL? Alex Hillman -Original Message- Sent: Tuesday, June 12, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Hillman, Alex 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: MacGregor, Ian A. 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: logminer in the 9i world, etc
good question about the logminer version, its probably logminer 9i :) bring the mining hat, batteries will be supplied :) joe "Deshpande, Kirti" wrote: > > Hey Joe, > Will that be Logminer 102 or 103 ? > > Do I need to bring Miner's uniform (the hat and all) ? > > Cheers! > > - Kirti > > > -Original Message- > > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, June 12, 2001 2:52 PM > > To: Multiple recipients of list ORACLE-L > > Subject: logminer in the 9i world, etc > > > > Well afetr reading the docs about logminer in version 9i, maybe i can get > > one more year worth of presentation out of it. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: logminer in the 9i world, etc
Oh oh, wild guess milliseconds? -Original Message- Sent: Tuesday, June 12, 2001 4:05 PM To: Multiple recipients of list ORACLE-L yes, except that i'm one of those sick pups that reads the docs. joe "Thater, William" wrote: > > On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: > > ->Well afetr reading the docs about logminer in version 9i, maybe i can get > ->one more year worth of presentation out of it. > -> > ->it tracks and displays DDL :) > -> > -> > ->useless trivia question(i know the answer) :) > -> > -> > ->So what do you get with the new datatype: timestamp > > bored?;-) > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > The Soviet Union does not exist any more in its present format. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: Seley, Linda 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: logminer in the 9i world, etc
Joe, I didn't get to see the advanced logminer presentation at IOUG-A. - is that one 201? - any chance of seeing it at your user group meeting in July? - does it exist in print anywhere? Paul -Original Message- Sent: Tuesday, June 12, 2001 6:05 PM To: Multiple recipients of list ORACLE-L Hey Joe, Will that be Logminer 102 or 103 ? Do I need to bring Miner's uniform (the hat and all) ? Cheers! - Kirti > -Original Message- > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 2:52 PM > To: Multiple recipients of list ORACLE-L > Subject: logminer in the 9i world, etc > > Well afetr reading the docs about logminer in version 9i, maybe i can get > one more year worth of presentation out of it. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Paul Drake 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: logminer in the 9i world, etc
yes, except that i'm one of those sick pups that reads the docs. joe "Thater, William" wrote: > > On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: > > ->Well afetr reading the docs about logminer in version 9i, maybe i can get > ->one more year worth of presentation out of it. > -> > ->it tracks and displays DDL :) > -> > -> > ->useless trivia question(i know the answer) :) > -> > -> > ->So what do you get with the new datatype: timestamp > > bored?;-) > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > The Soviet Union does not exist any more in its present format. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > 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) -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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: logminer in the 9i world, etc
Hey Joe, Will that be Logminer 102 or 103 ? Do I need to bring Miner's uniform (the hat and all) ? Cheers! - Kirti > -Original Message- > From: Joseph Testa [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 2:52 PM > To: Multiple recipients of list ORACLE-L > Subject: logminer in the 9i world, etc > > Well afetr reading the docs about logminer in version 9i, maybe i can get > one more year worth of presentation out of it. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: logminer in the 9i world, etc
Can it redo DDL? Alex Hillman -Original Message- Sent: Tuesday, June 12, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Hillman, Alex 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: logminer in the 9i world, etc
On Tue, 12 Jun 2001,Joseph Testa scribbled on the wall in glitter crayon: ->Well afetr reading the docs about logminer in version 9i, maybe i can get ->one more year worth of presentation out of it. -> ->it tracks and displays DDL :) -> -> ->useless trivia question(i know the answer) :) -> -> ->So what do you get with the new datatype: timestamp bored?;-) -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ The Soviet Union does not exist any more in its present format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: logminer in the 9i world, etc
Looks like you have meny more years, because they will add additional features, versions etc. It becomes like Microsoft. Only they cannot do it so well. Alex Hillman -Original Message- Sent: Tuesday, June 12, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Hillman, Alex 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).
logminer in the 9i world, etc
Well afetr reading the docs about logminer in version 9i, maybe i can get one more year worth of presentation out of it. it tracks and displays DDL :) useless trivia question(i know the answer) :) So what do you get with the new datatype: timestamp Joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Logminer Help
You should set utl_file_dir before executing dbms_logmnr_d. Regards. > -Mensaje original- > De: Yttri, Lisa [SMTP:[EMAIL PROTECTED]] > Enviado el: miércoles 24 de enero de 2001 18:12 > Para: Multiple recipients of list ORACLE-L > Asunto: Logminer Help > > Hi - > > I am trying to figure out how to use logminer. I have run the 2 scripts > to build the packages, but I am not sure what the purpose is of the > dictionary file. When I try to run the dbms_logmnr_d.build script I am > getting ORA-006510. I am passing a file name in single quotes and a > directory name in single quotes. > > Can anyone help me figure out what to do - or point me to some good > documentation? > > TIA - > Lisa > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian 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: LogMiner and Auditing
Look at the bright side: Now all you have to do is get rid of the pesky users, and life will be sweet! --Scott > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, February 15, 2001 12:46 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: LogMiner and Auditing > > > No finger pointing here. > > I have not met any duhvelopers at this company. (yet) > > Plenty at the previous job. > > This is a fictional scenario. > > Jared > > On Thu, 15 Feb 2001, Thater, William wrote: > > > [EMAIL PROTECTED] wrote: > > > > > > > > Seriously, has anyone successfully used LogMiner for auditing > > > in a production database. > > > > > > is this auditing, or just finger pointing? are your duhvelpoers just > > trying to duck the blame? > > > > > > -- > > Bill Thater Sr. ORACLE DBA > > Telergy, Inc [EMAIL PROTECTED] > > > > You gotta program like you don't need the money, > > You gotta compile like you'll never get hurt, > > You gotta run like there's nobody watching, > > It's gotta come from the heart if you want it to work! > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Thater, William > > 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: > 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: 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: LogMiner and Auditing
No finger pointing here. I have not met any duhvelopers at this company. (yet) Plenty at the previous job. This is a fictional scenario. Jared On Thu, 15 Feb 2001, Thater, William wrote: > [EMAIL PROTECTED] wrote: > > > > > Seriously, has anyone successfully used LogMiner for auditing > > in a production database. > > > is this auditing, or just finger pointing? are your duhvelpoers just > trying to duck the blame? > > > -- > Bill Thater Sr. ORACLE DBA > Telergy, Inc [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > 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: 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: LogMiner and Auditing
[EMAIL PROTECTED] wrote: > > Seriously, has anyone successfully used LogMiner for auditing > in a production database. is this auditing, or just finger pointing? are your duhvelpoers just trying to duck the blame? -- Bill Thater Sr. ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: LogMiner and Auditing
Also Logminer doesn't work with IOT and tables suffering from chaining and migrated rows. We should wait for 8.2 or 9i as they called. Regards. > -Mensaje original- > De: Joseph S. Testa [SMTP:[EMAIL PROTECTED]] > Enviado el: miércoles 14 de febrero de 2001 23:16 > Para: Multiple recipients of list ORACLE-L > Asunto: Re: LogMiner and Auditing > > Nope, not auditing as in the pure essence of auditing like oracle > auditing. > > But I've done the concept of pin pointing what user dropped a table > based on the DML of the dictionary tables, tab$, col$, etc. > > So thats an extreme subset at best. Besides with oracle auditing you > can audit select statements(if i remember correctly), where as logminer > only does DML against tables and with some serious investigative work > DDL against tables(which in reality is only DML against the data > dictionary). > > hth, joe > > > [EMAIL PROTECTED] wrote: > > > > > Seriously, has anyone successfully used LogMiner for auditing > > in a production database. > > > > Joe, your input here would be appreciated. > > > > Jared > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > 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: Trassens, Christian 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: LogMiner and Auditing
Jared... thank you, the grin was much appreciated Rachel >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: LogMiner and Auditing >Date: Wed, 14 Feb 2001 13:10:22 -0800 > > >FYI: Resent with a different subject >- > > >I've seen a few posts on the list lately suggesting the use >of LogMiner as an auditing tool. > >I have serious doubts about it's use in this capacity. Imagine >the following scenario. > >Duhveloper: 'We just discovered that someone dropped a critical > table in our system. We think some unauthorized > person has access to one of our production accounts! > We need to find out who this was!' > >( duhvelopers always speak with exclamation points ) > >DBA: 'Is this the same database that was installed by the >vendor with default passwords? The same database that >I'm not allowed to change the default passwords on?' > >Duhveloper: 'Uh, yeah, right.' >( Well, maybe not always ) > >DBA: 'OK, I may not be able to tell you who did it, but I >can pinpoint when it happened with LogMiner.' > >Duhveloper: 'Great! How soon we get an answer!' > >DBA: 'That depends on how closely you can narrow down the >window I have to look in. Approximately when did >happen?' > >Duhveloper: 'Well, we didn't find out til this morning. The > last time anyone can recall looking at the table > was 10 days ago.' > >DBA: 'This system generates a 500m log file 3 times an hour, >24x7. That means that a worst case scenario is I >process 720 Archive log files, many of which are on >tape, so I must bring those back 20 files at a time, as >the largest disk space I can spare is 10 gig. Working >fulltime I may be able to give you that answer in 30 days.' > >Duhveloper: 'Oh. Well maybe we don't need it that bad. I know > what we can do! Why don't you change the default > system passwords on that database. I don't know > why you didn't do it as soon as the vendor left!' > >( Duhveloper skulks away when DBA's face turns a lovely shade > of crimson and appears to be on the verge of burying Pompeii > in an ash flow. ) > > >Seriously, has anyone successfully used LogMiner for auditing >in a production database. > >Joe, your input here would be appreciated. > >Jared > > > >-- >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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: LogMiner and Auditing
Pretty much my take on it. LogMiner is a good specialized tool, but probably not appropriate for serious auditing. Thanks Jared On Wed, 14 Feb 2001, Joseph S. Testa wrote: > Nope, not auditing as in the pure essence of auditing like oracle > auditing. > > But I've done the concept of pin pointing what user dropped a table > based on the DML of the dictionary tables, tab$, col$, etc. > > So thats an extreme subset at best. Besides with oracle auditing you > can audit select statements(if i remember correctly), where as logminer > only does DML against tables and with some serious investigative work > DDL against tables(which in reality is only DML against the data > dictionary). > > hth, joe > > > [EMAIL PROTECTED] wrote: > > > > > Seriously, has anyone successfully used LogMiner for auditing > > in a production database. > > > > Joe, your input here would be appreciated. > > > > Jared > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- 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: LogMiner and Auditing
Nope, not auditing as in the pure essence of auditing like oracle auditing. But I've done the concept of pin pointing what user dropped a table based on the DML of the dictionary tables, tab$, col$, etc. So thats an extreme subset at best. Besides with oracle auditing you can audit select statements(if i remember correctly), where as logminer only does DML against tables and with some serious investigative work DDL against tables(which in reality is only DML against the data dictionary). hth, joe [EMAIL PROTECTED] wrote: > Seriously, has anyone successfully used LogMiner for auditing > in a production database. > > Joe, your input here would be appreciated. > > Jared -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
LogMiner and Auditing
FYI: Resent with a different subject - I've seen a few posts on the list lately suggesting the use of LogMiner as an auditing tool. I have serious doubts about it's use in this capacity. Imagine the following scenario. Duhveloper: 'We just discovered that someone dropped a critical table in our system. We think some unauthorized person has access to one of our production accounts! We need to find out who this was!' ( duhvelopers always speak with exclamation points ) DBA: 'Is this the same database that was installed by the vendor with default passwords? The same database that I'm not allowed to change the default passwords on?' Duhveloper: 'Uh, yeah, right.' ( Well, maybe not always ) DBA: 'OK, I may not be able to tell you who did it, but I can pinpoint when it happened with LogMiner.' Duhveloper: 'Great! How soon we get an answer!' DBA: 'That depends on how closely you can narrow down the window I have to look in. Approximately when did happen?' Duhveloper: 'Well, we didn't find out til this morning. The last time anyone can recall looking at the table was 10 days ago.' DBA: 'This system generates a 500m log file 3 times an hour, 24x7. That means that a worst case scenario is I process 720 Archive log files, many of which are on tape, so I must bring those back 20 files at a time, as the largest disk space I can spare is 10 gig. Working fulltime I may be able to give you that answer in 30 days.' Duhveloper: 'Oh. Well maybe we don't need it that bad. I know what we can do! Why don't you change the default system passwords on that database. I don't know why you didn't do it as soon as the vendor left!' ( Duhveloper skulks away when DBA's face turns a lovely shade of crimson and appears to be on the verge of burying Pompeii in an ash flow. ) Seriously, has anyone successfully used LogMiner for auditing in a production database. Joe, your input here would be appreciated. Jared -- 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).