DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: LogMiner

  1. #1
    Join Date
    May 2001
    Posts
    41

    Angry

    Hello all,

    Oracle 8.1.6 on Win2000, the database is working just fine until I try to set up LogMiner. Open up init.ora and add
    UTIL_FILE_DIR=c:\orant\oradata\\Archive
    save it, shut down the database and restart the system, I checked on the services for the listener and the db and they are running. Now I get an error Ora-01034 Oracle not available when I try to connect using Sqlplus? Any ideas


    Thanks,
    mn

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    why you have two \\
    oracle is not up when one of parameters is incorrectly set

  3. #3
    Join Date
    Feb 2001
    Posts
    290
    Would you check the ALERT.LOG for any accompanying messages, And also check if the the ORACLE_SID and ORACLE_HOME are set properly.

    And one more thing is remove that UTL_FILE_DIR parameter and run the DB , it will find out if the problem is really with this parameter or something else.

    And as Pando says , \\ should be \.

    Thanks,
    Madhu

  4. #4
    Join Date
    May 2001
    Posts
    41

    LogMiner

    That should have been, c:\orant\oradata\redwood\archive
    whenever I comment out UTL_FILE_DIR=............
    everything back to normal, I have tried this few times so the log is very long. If you could tell me what I'm looking for? there is highwater mark setting to 5, and then 6 that is not part of other listing on the same day. The oracle_sid and home are correct.



    Thanks,
    mn

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    In your first message you've stated that you have set UTIL_FILE_DIR=.... in your init.ora. If that was not a typo only in your message and you actually spelled that parameter that way in init.ora, this would definitely prevent your database from starting up, because it can't recognise such parameter. Actual name of the parameter is UTL_FILE_DIR, not UTIL_FILE_DIR.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    May 2001
    Posts
    41

    LogMiner

    The init.ora was a typo, now my database is running
    to start using logminer from my notes I need to create the dictionay file, adding logs, and last start the logminer.
    Now when I : " SQL> EXECUTE dbms_logmnr_d.build( -
    > dictionary_filename =>'redwooddict.ora', -
    > dictionary_location => 'c:\orant\oradata\redwood\archive');"

    I get : " ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00201: identifier 'DBMS_LOGMNR_D.BUILD' must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored"

    Did the Dictionary File get created?

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Under which user are you trying to execute 'DBMS_LOGMNR_D.BUILD? If it is anything other than user SYS as an owner of that package, you probably have problems with the way you references this packaged procedure.

    By default no public synonym is created for that package. So unless you are using it logged as user SYS, you have to use full name notation, including the owner. So you should call it as:

    SQL> EXECUTE SYS.dbms_logmnr_d.build(.....)

    Or you can simply create a synonym for it and use that synonym.

    P.S. Of course the dictionary file was not created, how could it? The procedure tha supposed to create it failed!
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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