LogMiner

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

why you have two \\
oracle is not up when one of parameters is incorrectly set

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

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

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.

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?

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!