RAT ORA-15507: cannot start workload replay on instance 1

来源:这里教程网 时间:2026-03-03 13:53:24 作者:

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其他节点即可

相关推荐