Data Mining and Real Application Testing options SQL> SQL> exec DBMS_WORKLOAD_REPLAY.START_REPLAY(); BEGIN DBMS_WORKLOAD_REPLAY.START_REPLAY(); END; * ERROR at line 1: ORA-15507: cannot start workload replay on instance 1 ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY", line 5782 ORA-06512: at line 1 *********************************************************************** Fatal NI connect error 12537, connecting to: (LOCAL=NO) TNS-12537: TNS:connection closed 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 ns secondary err code: 12560 nt main err code: 0 Time: 19-JUN-2019 09:23:31 nt secondary err code: 0 Tracing not turned on. nt OS err code: 0 Tns error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code: 12560 nt main err code: 0 opiodr aborting process unknown ospid (169962) as a result of ORA-609 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (169959) as a result of ORA-609 Wed Jun 19 09:23:31 2019 Chain 1: ------------------------------------------------------------------------------- Oracle session identified by: { instance: 1 (lvdb.lvdb1) os id: 156165 process id: 73, oracle@svjucl-rac01 session id: 5484 session serial #: 687 } is waiting for 'enq: TX - row lock contention' with wait info: { p1: 'name|mode'=0x54580006 p2: 'usn<<16 | slot'=0xf3d0021 p3: 'sequence'=0x18c6b time in wait: 1 min 42 sec timeout after: never wait id: 484 blocking: 0 sessions wait history: * time between current wait and wait #1: 0.000203 sec 1. event: 'WCR: replay client notify' time waited: 0.609489 sec wait id: 483 p1: 'who am I'=0x1 * time between wait #1 and #2: 0.000010 sec 2. event: 'WCR: replay client notify' time waited: 1.000965 sec wait id: 482 p1: 'who am I'=0x1 * time between wait #2 and #3: 0.000019 sec 3. event: 'WCR: replay client notify' time waited: 1.000992 sec wait id: 481 p1: 'who am I'=0x1 } and is blocked by => Oracle session identified by: { instance: 1 (lvdb.lvdb1) os id: 96164 process id: 59, oracle@svjucl-rac01 (TNS V1-V3) session id: 973 session serial #: 1111 } which is waiting for 'reliable message' with wait info: { p1: 'channel context'=0x1dd552da40 p2: 'channel handle'=0x1d954b10f8 p3: 'broadcast message'=0x1bc5a43138 time in wait: 2.658804 sec timeout after: 1 min 37 sec wait id: 3791527 blocking: 30 sessions wait history: * time between current wait and wait #1: 0.002981 sec 1. event: 'row cache lock' time waited: 0.000022 sec wait id: 3791526 p1: 'cache id'=0x18 p2: 'mode'=0x0 p3: 'request'=0x5 * time between wait #1 and #2: 0.003023 sec 2. event: 'row cache lock' time waited: 0.000170 sec wait id: 3791525 p1: 'cache id'=0x18 p2: 'mode'=0x0 p3: 'request'=0x5 * time between wait #2 and #3: 0.000192 sec 3. event: 'row cache lock' time waited: 0.000136 sec wait id: 3791524 p1: 'cache id'=0x18 p2: 'mode'=0x0 p3: 'request'=0x5 } Chain 1 Signature: 'reliable message'<='enq: TX - row lock contention' reliable message等待,关闭rac其他节点即可
RAT ORA-15507: cannot start workload replay on instance 1
来源:这里教程网
时间:2026-03-03 13:53:24
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- Oracle数据库不同损坏级别的恢复详解
Oracle数据库不同损坏级别的恢复详解
26-03-03 - oracle修改用户密码的方法
oracle修改用户密码的方法
26-03-03 - Oracle RAC+DG环境搭建(CentOS 7+Oracle 12C)( 十) 部署 DataGuard
- Oracle 12C单实例环境下 GoldenGate 12C的单向复制模式的搭建部署
- Debian依赖关系问题解决(新手也能轻松修复apt和dpkg依赖错误)
Debian依赖关系问题解决(新手也能轻松修复apt和dpkg依赖错误)
26-03-03 - ORACLE for windows 审计文件xml文件过多导致数据库启动报错ORA-09925
- Oracle启动两个监听
Oracle启动两个监听
26-03-03 - 11g ADG 出现FAL[client,USER]:error 12154 connect to orcl for fetching gap
- Oracle中的12C新特性-容器数据库概念-基本操作
Oracle中的12C新特性-容器数据库概念-基本操作
26-03-03 - Debian模型评估指标(在Debian系统中计算机器学习模型性能的完整指南)
