oracle.AQ.AQOracleSQLException: ORA-21779: duration not active ORA-21779: duration not active ORA-06512: at "SYS.DBMS_AQIN", line 571 ORA-06512: at line 1at oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1795)

Oracle Community | 510188 | 8 years ago
  1. 0

    Upgrade to RAC, now AQ is broken.

    Oracle Community | 8 years ago | 510188
    oracle.AQ.AQOracleSQLException: ORA-21779: duration not active ORA-21779: duration not active ORA-06512: at "SYS.DBMS_AQIN", line 571 ORA-06512: at line 1at oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1795)
  2. 0

    Troubleshooting and Workarounds

    oracle.com | 4 months ago
    oracle.AQ.AQOracleSQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_AQIN' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. 0

    Troubleshooting and Workarounds

    co.jp | 11 months ago
    oracle.AQ.AQOracleSQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'DBMS_AQIN' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JNDI not able to connect

    Oracle Community | 8 years ago | 493866
    oracle.AQ.AQOracleSQLException: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_AQIN", line 571 ORA-06512: at line 1at oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1795)
  6. 0

    Privilege  error.

    Oracle Community | 8 years ago | 493866
    oracle.AQ.AQOracleSQLException: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_AQIN", line 571 ORA-06512: at line 1at oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1795)

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.AQ.AQOracleSQLException

      ORA-21779: duration not active ORA-21779: duration not active ORA-06512: at "SYS.DBMS_AQIN", line 571 ORA-06512: at line 1at oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1795)

      at oracle.AQ.AQOracleQueue.dequeue()
    2. oracle.AQ
      AQOracleQueue.dequeue
      1. oracle.AQ.AQOracleQueue.dequeue(AQOracleQueue.java:1325)
      1 frame
    3. media.oracle.aq
      App.main
      1. media.oracle.aq.utlil.App.runTest(App.java:122)
      2. media.oracle.aq.utlil.App.main(App.java:43)
      2 frames