Logminer giving error when using where clause
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Logminer giving error when using where clause

  1. #1
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245

    Logminer giving error when using where clause

    Hi,
    I was trying to test logminer. So i created a table added some values.commit; Then deleted some and commit. After that i went in following way
    1) Cretaed dictionary file
    2)Added logfile to Logminer.
    3) started logminer to use all the logs .

    EXECUTE Dbms_Logmnr.Start_Logmnr( -
    dictfilename =>'d:\oracle\oradata\parag.ora');
    then i queried v$logmnr_contents with
    select sql_redo,sql_undo from v$logmnr_contents where seg_name = 'LGMNRTEST1';

    for first time i got 03113-End of file on comminication channel.
    after that i again started new session and went through all the above steps but now it is giving error like :-

    SQL> select * from v$logmnr_contents where seg_name = 'LGMNRTEST1';
    SP2-0642: SQL*Plus internal error state 2133, context 0:0:0
    Unsafe to proceed

    if i do select * from v$logmnr_contents it gives me no error. Only when i am putting where clause i am getting this error...

    What am i doing wrong....

    Rgds
    Parag

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    if you searched for the error on metalink you would fine the first hit probably explains your problem

  3. #3
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Yes davey23uk
    in that note version having problem is given as 8.1 and
    fix as
    Upgrade to Oracle 9.0.1 or apply the 8.1.7.2 patchset
    . but i am already on 9.0.1.
    so i am confused....

    Rgds
    Parag

  4. #4
    Join Date
    Dec 2001
    Posts
    320
    Hi,
    you have to upgrade to 9iR2, it's a well known bug according to metalink.

    Regards.
    Anyone can hold the helm when the sea is calm.

  5. #5
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    ya was looking at list of 9i bugs there are lot many in log-miner section...

    Thanks anyways...

    Rgds
    Parag

  6. #6
    Join Date
    Dec 2001
    Posts
    320
    But you know you can always install an Oracle 9iR2 on a new box and use its logminer to extract your queries using your 9.0.1 redologs.
    Anyone can hold the helm when the sea is calm.

  7. #7
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Wow thanks i never gave thought to this thing...

    thanks it looks better option...

    Rgds
    Parag

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width