OraFAQ Forum: Server Administration » Problem starting logminer

Home » RDBMS Server » Server Administration » Problem starting logminer (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem starting logminer [message #268046]

Mon, 17 September 2007 05:39

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

Frank Naude
Messages: 4581
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.

Report message to a moderator

Re: Problem starting logminer [message #268077 is a reply to message #268071]

Mon, 17 September 2007 08:09

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?

Report message to a moderator

Re: Problem starting logminer [message #268079 is a reply to message #268077]

Mon, 17 September 2007 08:15

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

See http://www.orafaq.com/wiki/Alert.log

Report message to a moderator

Re: Problem starting logminer [message #268080 is a reply to message #268046]

Mon, 17 September 2007 08:25

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

Report message to a moderator

Re: Problem starting logminer [message #268082 is a reply to message #268080]

Mon, 17 September 2007 08:36

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

DOn't you see any problems w.r.t. file 16?

Report message to a moderator

Re: Problem starting logminer [message #268086 is a reply to message #268082]

Mon, 17 September 2007 08:48

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.

Attachment: alertlog17092007.log
(Size: 8.88KB, Downloaded 1217 times)

Report message to a moderator

Re: Problem starting logminer [message #268094 is a reply to message #268086]

Mon, 17 September 2007 09:01

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Nope, I cannot see anything either. Your best bet is to log a TAR/SR on Metalink.

Report message to a moderator

Re: Problem starting logminer [message #268098 is a reply to message #268094]

Mon, 17 September 2007 09:06

Frank Naude
Messages: 4581
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.

Report message to a moderator

Re: Problem starting logminer [message #268258 is a reply to message #268098]

Tue, 18 September 2007 01:36

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.

Report message to a moderator

Re: Problem starting logminer [message #268350 is a reply to message #268258]

Tue, 18 September 2007 05:14

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!

Report message to a moderator

Re: Problem starting logminer [message #268410 is a reply to message #268350]

Tue, 18 September 2007 08:27

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

select * from dba_data_files where file_id = 16;

Report message to a moderator

Re: Problem starting logminer [message #269194 is a reply to message #268410]

Fri, 21 September 2007 01:56

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.

Report message to a moderator

Re: Problem starting logminer [message #269918 is a reply to message #269194]

Tue, 25 September 2007 02:20

Kingfisher
Messages: 40
Registered: August 2007
Location: Oslo, Norway

Member

Changed from "dictfilename" to "options" and it worked again. Weird.

Report message to a moderator

Previous Topic:	Question on UTF8
Next Topic:	ABOUNT INDEX STATUS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:13:10 CST 2024