Sample output
Tue Nov 27 13:05:19 2001
-------------------------------------------------------------------
Logfile: o:\oracle\ora81\admin\bdump\trn4\trn4alrt.log
-----
60222 Mon Nov 26 05:00:25 2001
60222 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP0.TRC:
60222 ORA-12012: error on auto execute of job 120413
60223 ORA-12543: TNS:destination host unreachable
60224 ORA-06512: at "ASPERIN.ENROLLMENT", line 24
60225 ORA-06512: at "ASPERIN.ENROLLMENT", line 41
60226 ORA-06512: at line 1
-----
60329 Mon Nov 26 19:47:36 2001
60329 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP1.TRC:
60329 ORA-12012: error on auto execute of job 88341
60330 ORA-12543: TNS:destination host unreachable
60331 ORA-06512: at "BULKLOAD.REGISTRAR", line 21
60332 ORA-06512: at "BULKLOAD.REGISTRAR", line 45
60333 ORA-06512: at line 1
-----
60675 Tue Nov 27 05:00:32 2001
60675 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP0.TRC:
60675 ORA-12012: error on auto execute of job 120413
60676 ORA-12535: TNS:operation timed out
60677 ORA-06512: at "ASPERIN.ENROLLMENT", line 24
60678 ORA-06512: at "ASPERIN.ENROLLMENT", line 41
60679 ORA-06512: at line 1
-----
60685 Tue Nov 27 07:00:38 2001
60685 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP1.TRC:
60685 ORA-12012: error on auto execute of job 14999
60686 ORA-12535: TNS:operation timed out
60687 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 46
60688 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 162
60689 ORA-06512: at line 1
-----
60693 Tue Nov 27 07:03:04 2001
60693 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP1.TRC:
60693 ORA-12012: error on auto execute of job 14999
60694 ORA-12535: TNS:operation timed out
60695 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 46
60696 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 162
60697 ORA-06512: at line 1
-----
60701 Tue Nov 27 07:07:33 2001
60701 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP1.TRC:
60701 ORA-12012: error on auto execute of job 14999
60702 ORA-12535: TNS:operation timed out
60703 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 46
60704 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 162
60705 ORA-06512: at line 1
-----
60709 Tue Nov 27 07:16:07 2001
60709 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP1.TRC:
60709 ORA-12012: error on auto execute of job 14999
60710 ORA-12535: TNS:operation timed out
60711 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 46
60712 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 162
60713 ORA-06512: at line 1
-----
60717 Tue Nov 27 07:32:33 2001
60717 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP0.TRC:
60717 ORA-12012: error on auto execute of job 14999
60718 ORA-12535: TNS:operation timed out
60719 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 46
60720 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 162
60721 ORA-06512: at line 1
-----
60725 Tue Nov 27 08:05:10 2001
60725 Errors in file C:\oracle\ora81\admin\bdump\trn4\trn4SNP1.TRC:
60725 ORA-12012: error on auto execute of job 14999
60726 ORA-12535: TNS:operation timed out
60727 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 46
60728 ORA-06512: at "FIN_DATA.UPDATE_FINDATA", line 162
60729 ORA-06512: at line 1
-------------------------------------------------------------------------
Logfile: e:\oracle\ora81\admin\trn3\bdump\trn3alrt.log
-----
23508 Mon Nov 26 05:00:43 2001
23508 Errors in file d:\oracle\ora81\admin\trn3\bdump\trn3SNP0.TRC:
23508 ORA-12012: error on auto execute of job 59896
23509 ORA-12543: TNS:destination host unreachable
23510 ORA-06512: at "ASPERIN.ENROLLMENT", line 24
23511 ORA-06512: at "ASPERIN.ENROLLMENT", line 41
23512 ORA-06512: at line 1
-----
23657 Tue Nov 27 05:00:45 2001
23657 Errors in file d:\oracle\ora81\admin\trn3\bdump\trn3SNP1.TRC:
23657 ORA-12012: error on auto execute of job 59896
23658 ORA-12543: TNS:destination host unreachable
23659 ORA-06512: at "ASPERIN.ENROLLMENT", line 24
23660 ORA-06512: at "ASPERIN.ENROLLMENT", line 41
23661 ORA-06512: at line 1
-------------------------------------------------------------------------
Logfile: f:\orant\admin\trn2\bdump\trn2alrt.log
-----
5450 alter tablespace DRSYS begin backup
5450
5450 ORA-959 signalled during: alter tablespace DRSYS begin backup
5451 ...
5452 Mon Nov 26 03:07:35 2001
5453 alter tablespace DRSYS end backup
-----
5455 alter tablespace DRSYS end backup
5455
5455 ORA-959 signalled during: alter tablespace DRSYS end backup
5456 ...
5457 Mon Nov 26 03:07:35 2001
5458 alter tablespace SPAR_INDICES begin backup
-----
5492 Mon Nov 26 05:01:06 2001
5492 Errors in file C:\ORANT\admin\trn2\bdump\trn2SNP1.TRC:
5492 ORA-12012: error on auto execute of job 59896
5493 ORA-12543: TNS:destination host unreachable
5494 ORA-06512: at "ASPERIN.ENROLLMENT", line 24
5495 ORA-06512: at "ASPERIN.ENROLLMENT", line 41
5496 ORA-06512: at line 1
-----
5651 alter tablespace DRSYS begin backup
5651
5651 ORA-959 signalled during: alter tablespace DRSYS begin backup
5652 ...
5653 Tue Nov 27 03:09:13 2001
5654 alter tablespace DRSYS end backup
-----
5656 alter tablespace DRSYS end backup
5656
5656 ORA-959 signalled during: alter tablespace DRSYS end backup
5657 ...
5658 Tue Nov 27 03:09:15 2001
5659 alter tablespace SPAR_INDICES begin backup
-----
5693 Tue Nov 27 05:01:21 2001
5693 Errors in file C:\ORANT\admin\trn2\bdump\trn2SNP1.TRC:
5693 ORA-12012: error on auto execute of job 59896
5694 ORA-12535: TNS:operation timed out
5695 ORA-06512: at "ASPERIN.ENROLLMENT", line 24
5696 ORA-06512: at "ASPERIN.ENROLLMENT", line 41
5697 ORA-06512: at line 1
-----
5701 Tue Nov 27 07:01:02 2001
5701 Errors in file C:\ORANT\admin\trn2\bdump\trn2SNP1.TRC:
5701 ORA-12012: error on auto execute of job 14999
5702 ORA-04045: errors during recompilation/revalidation of FIN_DATA.
UPDATE_FINDATA
5703 ORA-04052: error occurred when looking up remote object
HUDW.DWGL_RF_CODE_COMBINATIONS@FINPROD.HARVARD.EDU
5704 ORA-00604: error occurred at recursive SQL level 3
5705 ORA-12535: TNS:operation timed out
5706
5707 Tue Nov 27 07:03:54 2001
5708 Errors in file C:\ORANT\admin\trn2\bdump\trn2SNP1.TRC:
-----
5709 Tue Nov 27 07:03:54 2001
5709 Errors in file C:\ORANT\admin\trn2\bdump\trn2SNP1.TRC:
5709 ORA-12012: error on auto execute of job 14999
5710 ORA-04045: errors during recompilation/revalidation of FIN_DATA.
UPDATE_FINDATA
5711 ORA-04052: error occurred when looking up remote object
HUDW.DWGL_RF_CODE_COMBINATIONS@FINPROD.HARVARD.EDU
5712 ORA-00604: error occurred at recursive SQL level 3
5713 ORA-12535: TNS:operation timed out
5714
5715 Tue Nov 27 07:08:49 2001
5716 Errors in file C:\ORANT\admin\trn2\bdump\trn2SNP1.TRC:
-----
5717 Tue Nov 27 07:08:49 2001
5717 Errors in file C:\ORANT\admin\trn2\bdump\trn2SNP1.TRC:
5717 ORA-12012: error on auto execute of job 14999
5718 ORA-04045: errors during recompilation/revalidation of FIN_DATA.
UPDATE_FINDATA
5719 ORA-04052: error occurred when looking up remote object
HUDW.DWGL_RF_CODE_COMBINATIONS@FINPROD.HARVARD.EDU
5720 ORA-00604: error occurred at recursive SQL level 3
5721 ORA-12535: TNS:operation timed out
5722
-------------------------------------------------------------------------
Note: Proofread any scripts before using. Always try scripts on a test
instance
first. I'm not responsible for any damage, even if you somehow manage to make my
scripts corrupt every last byte of your data, set your server on fire and serve you
personally with an eviction notice from your landlord!
All scripts and tips © Natalka Roshak 2001-2005.
Enjoy the FREE tips folks...