Cannot find Oracle trace file

[JtheRipper]

Hi there,

I have a bit of a strange problem. In my alert.log file I see the following message:
Errors in file /usr/app/oracle/admin/prdcdb/log/prdcdb_s000_6838.trc
But I cannot find the trace file?!

I checked my dump directories, even did a find from root to search the whole server for the file without any luck.

Any help/info pls.

Thanks,
J.

 

[alexhu]

Oracle Version Please

Alex

 

[JtheRipper]

Sorry about not giving enough info,

The oracle version is 8.1.7.4.0 64bit running on Sun Solaris 8 64bit.

Thanks,
J.

 

[alexhu]

Whats the result of

SELECT value FROM v$parameter WHERE name = 'user_dump_dest'

To test the path do the following

ALTER SESSION SET sql_trace=true

Run a SQL statement (e.g. SELECT count(*) FROM all_objects)

Do a ls again on the udump path and see if a trace file has been created.

Alex

 

[sem]

Is it possible that this file was deleted?

Regards, Dima

http://seminihin.narod.ru

 

[JtheRipper]

Hi,

The user_dump_dest is /usr/app/oracle/admin/prdcdb/log, which is the same as the background_dump_dest and core_dump_dest.
A trace file was generated when I set the sql_trace=true, prdcdb_ora_9364.trc.


My original problem was that I get ORA-600 errors that tells me I should go and look in a ....smon...trc file that does not exist. I can reproduce the ora-600 errors at will, but I cannot find the smon trace file.
What confuses me is that in the alert file the full path and file name of the trace file is given, so where does oracle get that info from?

J.

 

[dblair]

from .init file.

Can you check the file/directory permissions on
/usr/app/oracle/admin/prdcdb/log
can you create a file here as the oracle user ?

 

[alexhu]

I have the same problem with 9.0.1 - I get trace reports in the alert log but no files. However , I am going to upgrade to 9.2

Oracle creates the name of the file as it makes the file and puts it in the path specified (or not )

Alex

 

[JtheRipper]

Hi,

The file was not deleted. Strange thing is that ,as I said earlier, I can reproduce my ora-600 errors at will, and in the alert.log file it always points to the same trace file, even if I reproduce the errors days apart, it is always prdcdb_s000_6838.trc.

The permissions of the trace directory is fine, I created a file without any problems in the directory. I can also generate a trace file in the directory by setting the sql_trace parameter to true.

Really odd "problem" this...

Thanks for the replies.
J.

 

[alexhu]

The same name indicates the same process causing the problem - probably one of the Oracle core processes.

in theory if you restart the instance the number should change

Alex