快速查询最近 Oracle 告警日志下的以ORA‑开头、WARNING、ERROR 的错误信息

jiawang

[oracle@xd1dbadm01 trace]$ awk '
> /^[0-9]{4}-[0-9]{2}-[0-9]{2}/ {linebuf=$0;next}
> /^ORA-/ || /WARNING/ || /ERROR/ {print linebuf;print $0}

> ' alert_orcl1.log20260804

2026-07-28T09:22:14.771054+08:00
ORA-07445: 出现异常错误: 核心转储 [sjonsock_create_if_needed()+77] [SIGSEGV] [ADDR:0xC] [PC:0x5A4151D] [Address not mapped to object] []
2026-07-28T11:09:04.060708+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-28T14:02:45.112821+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-28T21:18:04.762428+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-28T22:13:09.003898+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-29T09:21:28.826564+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-29T09:51:53.034292+08:00
ORA-00609: could not attach to incoming connection
2026-07-29T09:51:53.034292+08:00
ORA-12547: TNS:lost contact
2026-07-29T15:19:48.759546+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-30T08:05:35.021385+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-30T08:32:15.849139+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-30T11:25:34.258867+08:00
ORA-01001: 无效的游标
2026-07-30T11:25:34.258867+08:00
ORA-06512: 在 "ZLNECHIS.F_ZYYSZ_BRLB", line 33
2026-07-30T11:25:34.258867+08:00
ORA-06548: 不再需要更多的行
2026-07-30T11:25:34.258867+08:00
ORA-03135: 连接失去联系
2026-07-30T11:25:34.258867+08:00
ORA-06512: 在 "ZLNECHIS.F_ZYYSZ_BRLB", line 442
2026-07-30T11:25:34.258867+08:00
ORA-06512: 在 "ZLNECHIS.F_ZYYSZ_BRLB", line 442
2026-07-30T12:20:38.014656+08:00
ORA-16401: archive log rejected by Remote File Server (RFS)
2026-07-30T14:27:46.221811+08:00
ORA-04022: 请求不等待, 但必须等待锁定字典对象
2026-07-30T14:27:46.221811+08:00
ORA-12152: TNS: 无法发送中断消息
2026-07-30T14:27:46.221811+08:00
ORA-01013: 用户请求取消当前的操作
2026-07-30T15:25:08.141032+08:00
ORA-07445: 出现异常错误: 核心转储 [sjonsock_create_if_needed()+77] [SIGSEGV] [ADDR:0xC] [PC:0x5A4151D] [Address not mapped to object] []
2026-07-31T04:37:20.104946+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-31T09:01:55.113059+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-31T10:25:27.927390+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-07-31T17:06:35.916256+08:00
ORA-04022: 请求不等待, 但必须等待锁定字典对象
2026-07-31T17:06:35.916256+08:00
ORA-12152: TNS: 无法发送中断消息
2026-07-31T17:06:35.916256+08:00
ORA-01013: 用户请求取消当前的操作
2026-07-31T18:15:55.471716+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-08-01T05:26:42.920624+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-08-01T08:16:46.433296+08:00
ORA-07445: 出现异常错误: 核心转储 [sjonsock_create_if_needed()+77] [SIGSEGV] [ADDR:0xC] [PC:0x5A4151D] [Address not mapped to object] []
2026-08-01T20:19:34.245776+08:00
ORA-16401: archive log rejected by Remote File Server (RFS)
2026-08-02T08:02:32.177228+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-08-02T14:31:44.188113+08:00
ORA-00235: control file read without a lock inconsistent due to concurrent update
2026-08-02T15:14:00.588846+08:00
ORA-01001: 无效的游标
2026-08-02T15:14:00.588846+08:00
ORA-06512: 在 "ZLNECHIS.F_ZYYSZ_BRLB", line 33
2026-08-02T15:14:00.588846+08:00
ORA-06548: 不再需要更多的行
2026-08-02T15:14:00.588846+08:00
ORA-06512: 在 "ZLNECHIS.F_ZYYSZ_BRLB", line 442
2026-08-02T15:14:00.588846+08:00
ORA-06512: 在 "ZLNECHIS.F_ZYYSZ_BRLB", line 442
2026-08-02T20:37:18.867473+08:00
ORA-04022: 请求不等待, 但必须等待锁定字典对象
2026-08-02T20:37:18.867473+08:00
ORA-12152: TNS: 无法发送中断消息
2026-08-02T20:37:18.867473+08:00
ORA-01013: 用户请求取消当前的操作
2026-08-02T20:37:18.867473+08:00
ORA-02063: 紧接着 line (起自 TO_SPD)
2026-08-03T00:28:52.568989+08:00
ORA-04022: 请求不等待, 但必须等待锁定字典对象
2026-08-03T00:28:52.568989+08:00
ORA-12152: TNS: 无法发送中断消息
2026-08-03T00:28:52.568989+08:00
ORA-01013: 用户请求取消当前的操作
2026-08-03T00:29:59.461728+08:00
ORA-04022: 请求不等待, 但必须等待锁定字典对象
2026-08-03T00:29:59.461728+08:00
ORA-12152: TNS: 无法发送中断消息
2026-08-03T00:29:59.461728+08:00
ORA-01013: 用户请求取消当前的操作
2026-08-03T20:44:22.374140+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-08-04T04:35:31.484252+08:00
WARNING: inbound connection timed out (ORA-3136)
2026-08-04T09:39:25.515701+08:00
ORA-00235: control file read without a lock inconsistent due to concurrent update
2026-08-04T10:47:39.145481+08:00
ORA-07445: 出现异常错误: 核心转储 [sjonsock_create_if_needed()+77] [SIGSEGV] [ADDR:0xC] [PC:0x5A4151D] [Address not mapped to object] []
2026-08-04T11:17:37.277596+08:00
ORA-07445: 出现异常错误: 核心转储 [sjonsock_create_if_needed()+77] [SIGSEGV] [ADDR:0xC] [PC:0x5A4151D] [Address not mapped to object] []
[oracle@xd1dbadm01 trace]$