ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU613$
ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU613$ Error: ORA 1628 Text: max # of extents reached for rollback segment ———————&#
Read more分类：troubleshooting
TNS-12535: TNS:operation timed out TNS-00505: Operation timed out
公司一台Oracle备库alert.log中每隔一小时出现以下错误
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
Mon Nov 16 13:41:19 2020 ********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production Time: 16-NOV-2020 13:41:19 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12560 nt main err code: 505 TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.128.100)(PORT=20233)) |
错误原因 上述报错表示，一个会话与Oracle实例建立连接之后断开了。 断开原因可能是会话空闲，一直没有数据通信，最终连接时间是超过了防火墙设置的最大空闲时长（idle time），最终断开连接。 “nt secondary err code” 表示网络传输超时（T
Read moreOracle active standby ORA-01555
公司的一台Oracle备库ADG（11.2.0.4）alert.log中出现大量ORA-01555错误。 查看系统视图都会出现ORA-01555
|
1 2 3 4 5 6 |
SQL> select * from v$archive_gap; select * from v$archive_gap * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 3 ORA-01555: snapshot too old: rollback segment number 347 with name "_SYSSMU347_4236294198$" too small |
在网上找到了这篇mos。这个bug 影响版本是11.2.0.2到12.1（不含）。不过这个bug在11.2.0.4没有修复。只能升级解决。 问题发生原因： 当获取一个 lib
Read moreORA-16014 ORA-00312 备库没有归档路径的报错
交易系统的主库在公司机房，备库在外面的IDC机房。备库搬回到公司，service_name从trade1改为了trade3，,unique_name也从从trade1改为了trade3。 启动后无异常，不久开始报备库延迟。alert.log 日志显示没有可用的归档路径。
|
1 2 3 4 5 6 7 |
Tue Jan 07 06:53:58 2020 Archiver process freed from errors. No longer stopped Tue Jan 07 06:58:58 2020 ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance xxx - Archival Error ORA-16014: log 13 sequence# 4095 not archived, no available destinations ORA-00312: online log 13 thread 1: '/u01/app/oracle/oradata/xxxx/std_redo03.log' |
错误原因： 操作疏忽，忘记修改log_archive_dest
Read moreOracle – OSD kill succeeded for process
公司NC库这几天晚上十一点多就会发送告警，Operational error (OSD kill succee…) detected in /u01/app/oracle/diag/rdbms/ncdb3/ncdb3/alert/log.xml 查看alert.log 和log.xml 日志，都有记录，显示0x0x970a9e428进程在自动SQL调优任务（Auto SQL Tunin
Read moreORA-12012 ORA-12005: may not schedule automatic refresh for times in the past
版本：11gR2 RAC 核心库出现job失败告警，最初认为是偶发事件，没想到最近两天会规律出现。 通过查看alert，获知是job 483问题。 Mon Jan 07 11:28:15 2019
|
1 2 3 |
Errors in file /u01/app/oracle/diag/rdbms/xxdb34/xxdb3/trace/xxdb3_j003_4230.trc: ORA-12012: error on auto execute of job 483 ORA-12005: may not schedule automatic refresh for times in the past |
错误的字面意思：调度自动刷新获得的下次执行时间已经处于过去时。 查看job 483设定的interval。 [crayon-67a2e4
Read moreORA-4021 的发生原因
An Oracle instance contains a cache that holds the definitions of each different type of objects e.g. cursors, indexes, tables, views, procedures, etc. This cache is called the library cache and conta
Read moreLGWR (ospid: 40339): terminating the instance due to error 4021
www.dbhelp.net 十字螺丝钉的DBA日记 公司备库ADG意外宕机，alert日志显示LGWR进程终止了DB instance
|
1 2 3 4 |
Wed Dec 06 02:34:59 2017 Errors in file /u01/app/oracle/diag/rdbms/ivlstd3/ivlstd3/trace/ivlstd3_lgwr_40339.trc: ORA-04021: timeout occurred while waiting to lock object LGWR (ospid: 40339): terminating the instance due to error 4021 |
错误原因： 1、发生ORA-4021 错误的原因？ 获取library cache lock/pin 超时 2、为什么是 LGWR 终止了db instance？ 根据 《Bug 18242740
Read more