Home » RDBMS Server » Performance Tuning » Script to load Trace files errors to a Table (IBM AIX)
Script to load Trace files errors to a Table [message #590030] Sat, 13 July 2013 12:50 Go to next message
user81
Messages: 2
Registered: July 2013
Junior Member
Hi,

I need to create a script which can fetch the error related details from Trace files regularly (may be twice a day ) to

a custom table in DB. If anybody has created such kind of script, please share it with me Or if someone can provide me the

logic to pick the data from Trace files, it would be a great help. My Platform is IBM AIX.

Thanks

Report message to a moderator

Re: Script to load Trace files errors to a Table [message #590048 is a reply to message #590030] Sat, 13 July 2013 13:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Which kind of error?

Regards
Michel

Report message to a moderator

Re: Script to load Trace files errors to a Table [message #590053 is a reply to message #590048] Sat, 13 July 2013 13:54 Go to previous messageGo to next message
user81
Messages: 2
Registered: July 2013
Junior Member

Hi Michel,

Thanks for your reply. All the ORA- errors that keep getting recorded in these trace files.
Please let me know if you still have any doubts.

Thanks

Report message to a moderator

Re: Script to load Trace files errors to a Table [message #590054 is a reply to message #590053] Sat, 13 July 2013 14:38 Go to previous message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
find <trace file dir> -f '*trc' -exec grep -H ORA- {} \;


Regards
Michel

Report message to a moderator

Previous Topic: How to enable AWR in oracle 10g
Next Topic: About NO_INDEX Hint
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 18:20:01 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.