Home » Infrastructure » Windows » Unable to delete SMON trace file (Oracle Database 10g Release 10.2.0.3.0 - Production,Microsoft Windows 2003)
Unable to delete SMON trace file [message #567667] Thu, 04 October 2012 03:13 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear All,

In my database smon tracefile was huge,now we want to delete the same,I also tried with ordebug operation but no use,Kindly help me regarding this and advice to delete tracfile which Smon generates.

Thanks,
Anil
Re: Unable to delete SMON trace file [message #567670 is a reply to message #567667] Thu, 04 October 2012 03:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can delete the trace file if it does not belong to the current instance.
If it does you have to first stop the instance to be able to delete the file.

Regards
Michel
Re: Unable to delete SMON trace file [message #567679 is a reply to message #567670] Thu, 04 October 2012 04:32 Go to previous messageGo to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear Michel,

Trace is for current instance,we dont want to stop the instance as this is production.Kindly advice for any possible ways to stop trace.

Thanks,
Anil
Re: Unable to delete SMON trace file [message #567681 is a reply to message #567679] Thu, 04 October 2012 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not possible unless you ask Microsoft to change its file locking management policy.
Not that in Unix you could "rm" the file but the space is not released until the last process holding a handle on it close it.

Regards
Michel
Re: Unable to delete SMON trace file [message #567684 is a reply to message #567679] Thu, 04 October 2012 06:28 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I think you may be able to use the ocopy utility in %ORACLE_HOME%\bin to copy a small file (anything will do) over the large smon trace file while it is open, and so free up the space. I haven't tested this, but it will cost you nothing to try.
Re: Unable to delete SMON trace file [message #567690 is a reply to message #567684] Thu, 04 October 2012 06:45 Go to previous message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

Dear John,

I tried using this but no use.
C:\Documents and Settings\webserver>ocopy E:\admin\tunise\bdump\tunise_lgwr_3296.trc E:\admin\tunise\bdump\tunise_smon_3304.TRC
E:\ADMIN\TUNISE\BDUMP\TUNISE_SMON_3304.TRC
OCOPY - Unable to open output file E:\ADMIN\TUNISE\BDUMP\TUNISE_SMON_3304.TRC.

Only thing we need to do now get downtime and remove that trace.Thanks for your usefull advice.

Regards,
Anil
Previous Topic: Oracle Service doesn't start
Next Topic: How to get the password post installation of Oracle
Goto Forum:
  


Current Time: Thu Mar 28 15:56:12 CDT 2024