Home » RDBMS Server » Server Administration » Problem starting logminer  () 1 Vote
Problem starting logminer [message #268046] Mon, 17 September 2007 05:39 Go to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
I've recently started, stopped and started again logminer without any problems, but today this happens:

SQL> execute dbms_logmnr.START_LOGMNR(dictfilename => dbms_logmnr.dict_from_online_catalog);
BEGIN dbms_logmnr.START_LOGMNR(dictfilename => dbms_logmnr.dict_from_online_catalog); END;

*
ERROR at line 1:
ORA-01284: file 16 cannot be opened
ORA-06512: at "SYS.DBMS_LOGMNR", line 58
ORA-06512: at line 1

I've checked the docs, and it seems the logminer package cannot open the dictionary.

How can I fix this?

Config: Oracle 10g on Windows. Test installation on Windows XP.

[Updated on: Mon, 17 September 2007 05:42]

Report message to a moderator

Re: Problem starting logminer [message #268071 is a reply to message #268046] Mon, 17 September 2007 07:49 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Any errors in your ALERT.LOG file?

$ oerr ora 1284
01284, 00000, "file %s cannot be opened"
// *Cause: The file or directory may not exist or may be inaccessible.
//         Pathname exceeds 256 characters.
// *Action: Ensure that the file and the directory exist and are accessible.
Re: Problem starting logminer [message #268077 is a reply to message #268071] Mon, 17 September 2007 08:09 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Frank Naude wrote on Mon, 17 September 2007 14:49
Any errors in your ALERT.LOG file?

I can't find any such file on my system. Where would it be?
Re: Problem starting logminer [message #268079 is a reply to message #268077] Mon, 17 September 2007 08:15 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See http://www.orafaq.com/wiki/Alert.log
Re: Problem starting logminer [message #268080 is a reply to message #268046] Mon, 17 September 2007 08:25 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Found it. Thanks.

Here is the only error I found for today that seems relevant:
Ma Sep 17 12:26:17 2007
Logminer Bld: Build started
Ma Sep 17 12:26:17 2007
Logminer Bld: Catalog lockdown FAILED, status -258

Re: Problem starting logminer [message #268082 is a reply to message #268080] Mon, 17 September 2007 08:36 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
DOn't you see any problems w.r.t. file 16?
Re: Problem starting logminer [message #268086 is a reply to message #268082] Mon, 17 September 2007 08:48 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Frank Naude wrote on Mon, 17 September 2007 15:36
DOn't you see any problems w.r.t. file 16?

I can't see anything, but then I am very tired atm. I have attached the logfile contents from today.
Re: Problem starting logminer [message #268094 is a reply to message #268086] Mon, 17 September 2007 09:01 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Nope, I cannot see anything either. Your best bet is to log a TAR/SR on Metalink.
Re: Problem starting logminer [message #268098 is a reply to message #268094] Mon, 17 September 2007 09:06 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Also try to stop and restart the database and/or machine to see if the process holding file 16 will release it.
Re: Problem starting logminer [message #268258 is a reply to message #268098] Tue, 18 September 2007 01:36 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Frank Naude wrote on Mon, 17 September 2007 16:06
Also try to stop and restart the database and/or machine to see if the process holding file 16 will release it.


Thanks. I have restarted the processes several times and the server itself, but the error is still there.
Re: Problem starting logminer [message #268350 is a reply to message #268258] Tue, 18 September 2007 05:14 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
How can I find out which file the error message refers to?

'Cause now I have uninstalled Oracle, rebootet, and re-installed it, and I still get the error when trying to run logminer!
Re: Problem starting logminer [message #268410 is a reply to message #268350] Tue, 18 September 2007 08:27 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
select * from dba_data_files where file_id = 16;
Re: Problem starting logminer [message #269194 is a reply to message #268410] Fri, 21 September 2007 01:56 Go to previous messageGo to next message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Frank Naude wrote on Tue, 18 September 2007 15:27
select * from dba_data_files where file_id = 16;


no rows selected

Still get the same error.
Re: Problem starting logminer [message #269918 is a reply to message #269194] Tue, 25 September 2007 02:20 Go to previous message
Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway
Member
Changed from "dictfilename" to "options" and it worked again. Weird.
Previous Topic: Question on UTF8
Next Topic: ABOUNT INDEX STATUS
Goto Forum:
  


Current Time: Fri Dec 09 12:00:41 CST 2016

Total time taken to generate the page: 0.05185 seconds