Shulou(Shulou.com)06/01 Report--

tail -f -500 /data/oracle/SHPBLS/admin/diag/rdbms/shpbls_sb/SHPBLS/trace/alert_SHPBLS.log

| grep 'ORA-|rror'

tail -n 1000 alert_ahjcyl.log |grep ORA-

cd /data/oracle/SHPBLS/admin/diag/rdbms/shpbls_sb/SHPBLS/trace/

tail -n 1000 alert_*.log

tail -n 1000 alert_*.log | grep ORA-

tail -n 10000 alert_*.log | grep -A 6 ORA-

tail -n 10000 alert_*.log | grep -B 6 ORA-

tail -n 10000 alert_*.log | grep -C 6 ORA-

[oracle@ahjcyl-db bdump]$ tail -n 1000 alert_ahjcyl.log |grep ORA-ORA-12012: error on auto execute of job 22ORA-00054: resource busy and acquire with NOWAIT specifiedORA-06512: at "DOCTOR.SPL_SJPT_ARCHUSAGE", line 18ORA-06512: at "DOCTOR.SPL_SJPT_DAYLY", line 34ORA-06512: at line 1---can see an error message, tail -n xx is the last number of lines sent to grep through the pipe symbol to view, but I can't figure it out, if you can display the error message line and then attach the following lines after the error, it should be better, and then look down [oracle@ahjcyl-db bdump]$ tail -n 10000 alert_ahjcyl.log| grep -A 6 ORA-WARNING: inbound connection timed out (ORA-3136)Fri Sep 9 18:01:34 2011WARNING: inbound connection timed out (ORA-3136)Fri Sep 9 18:05:29 2011Thread 1 advanced to log sequence 2566 (LGWR switch) Current log# 6 seq# 2566 mem# 0: /oracle/oradata/ahjcyl/redo06_02.log Current log# 6 seq# 2566 mem# 1: /oradata/ahjcyl/redo06_01.logFri Sep 9 20:14:54 2011Thread 1 advanced to log sequence 2567 (LGWR switch)--ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Fri Sep 9 22:18:55 2011ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Fri Sep 9 22:42:39 2011ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Sat Sep 10 01:03:00 2011Starting control autobackupControl autobackup written to DISK device handle '/oracle/flash_recovery_area/AHJCYL/autobackup/2011_09_10/o1_mf_s_761446980_76nkp55y_.bkp'Sat Sep 10 01:03:05 2011ALTER SYSTEM ARCHIVE LOG--ORA-12012: error on auto execute of job 22ORA-00054: resource busy and acquire with NOWAIT specifiedORA-06512: at "DOCTOR.SPL_SJPT_ARCHUSAGE", line 18ORA-06512: at "DOCTOR.SPL_SJPT_DAYLY", line 34ORA-06512: at line 1Wed Sep 14 13:02:18 2011Thread 1 advanced to log sequence 2711 (LGWR switch) Current log# 6 seq# 2711 mem# 0: /oracle/oradata/ahjcyl/redo06_02.log Current log# 6 seq# 2711 mem# 1: /oradata/ahjcyl/redo06_01.logWed Sep 14 13:13:49 2011Thread 1 advanced to log sequence 2712 (LGWR switch)--Is it a bit clear, if you want a few lines before the error message? [oracle@ahjcyl-db bdump]$ tail -n 10000 alert_ahjcyl.log| grep -B 6 ORA- Current log# 1 seq# 2564 mem# 1: /oradata/ahjcyl/redo01_01.logFri Sep 9 18:00:14 2011Thread 1 advanced to log sequence 2565 (LGWR switch) Current log# 2 seq# 2565 mem# 0: /oracle/oradata/ahjcyl/redo02_02.log Current log# 2 seq# 2565 mem# 1: /oradata/ahjcyl/redo02_01.logFri Sep 9 18:01:34 2011WARNING: inbound connection timed out (ORA-3136)Fri Sep 9 18:01:34 2011WARNING: inbound connection timed out (ORA-3136)-- Current log# 6 seq# 2566 mem# 1: /oradata/ahjcyl/redo06_01.logFri Sep 9 20:14:54 2011Thread 1 advanced to log sequence 2567 (LGWR switch) Current log# 4 seq# 2567 mem# 0: /oracle/oradata/ahjcyl/redo04_02.log Current log# 4 seq# 2567 mem# 1: /oradata/ahjcyl/redo04_01.logFri Sep 9 22:18:55 2011ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Fri Sep 9 22:18:55 2011ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Fri Sep 9 22:42:39 2011ORA-1652: unable to extend temp segment by 128 in tablespace TEMP --But if you look at the first\last few lines of the data a+b, then look down [oracle@ahjcyl-db bdump]$ tail -n 10000 alert_ahjcyl.log| grep -C 6 ORA-Control autobackup written to DISK device handle '/oracle/flash_recovery_area/AHJCYL/autobackup/2011_09_08/o1_mf_s_761322189_76jqtf7g_.bkp'Completed: alter database add logfile group 2 ('/oracle/oradata/ahjcyl/redo02_02.log','/oradata/ahjcyl/redo02_01.log') size 200mThu Sep 8 14:24:03 2011alter database drop logfile group 3Thu Sep 8 14:24:03 2011ORA-1624 signalled during: alter database drop logfile group 3... Thu Sep 8 14:24:50 2011alter database drop logfile group 3Thu Sep 8 14:24:50 2011Starting control autobackupControl autobackup written to DISK device handle '/oracle/flash_recovery_area/AHJCYL/autobackup/2011_09_08/o1_mf_s_761322290_76jqxljw_.bkp'-- Current log# 1 seq# 2564 mem# 1: /oradata/ahjcyl/redo01_01.logFri Sep 9 18:00:14 2011Thread 1 advanced to log sequence 2565 (LGWR switch) Current log# 2 seq# 2565 mem# 0: /oracle/oradata/ahjcyl/redo02_02.log Current log# 2 seq# 2565 mem# 1: /oradata/ahjcyl/redo02_01.logFri Sep 9 18:01:34 2011WARNING: inbound connection timed out (ORA-3136)Fri Sep 9 18:01:34 2011WARNING: inbound connection timed out (ORA-3136)Fri Sep 9 18:05:29 2011Thread 1 advanced to log sequence 2566 (LGWR switch) Current log# 6 seq# 2566 mem# 0: /oracle/oradata/ahjcyl/redo06_02.log Current log# 6 seq# 2566 mem# 1: /oradata/ahjcyl/redo06_01.logFri Sep 9 20:14:54 2011Thread 1 advanced to log sequence 2567 (LGWR switch) Current log# 4 seq# 2567 mem# 0: /oracle/oradata/ahjcyl/redo04_02.log Current log# 4 seq# 2567 mem# 1: /oradata/ahjcyl/redo04_01.logFri Sep 9 22:18:55 2011ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Fri Sep 9 22:18:55 2011ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Fri Sep 9 22:42:39 2011ORA-1652: unable to extend temp segment by 128 in tablespace TEMP Sat Sep 10 01:03:00 2011Starting control autobackupControl autobackup written to DISK device handle '/oracle/flash_recovery_area/AHJCYL/autobackup/2011_09_10/o1_mf_s_761446980_76nkp55y_.bkp'Sat Sep 10 01:03:05 2011ALTER SYSTEM ARCHIVE LOG--That's right grep -C Specific explanation Ask a man, man grep

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.