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

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其他節點即可