9 Replies Latest reply: Feb 28, 2013 10:07 AM by Hussein Sawwan-Oracle RSS

    Shut down the concurrent managers to terminate the process  ORA-01000

    SurinderSingh
      Dear All,

      Error As Follows

      Shut down the concurrent managers to terminate the process or use port-specific operating system commands to terminate the process.
      Job number is: 638
      Job number is: 639
      01-FEB-2013 10:46:36 - ORACLE error 1000 in get_status

      The SQL statement being executed at the time of the error was: &SQLSTMT and wJob number is: 642

      The call to function PingProcess in cartridge AQCART has failed.
      Routine FNDSM cannot terminate the concurrent process with concurrent process ID &CPID and
      operating system process ID 7537140

      The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
      01-FEB-2013 10:44:34 - ORACLE error 1000 in get_status

      Cause: get_status failed due to ORA-01000: maximum open cursors exceeded.

      Again after some time i used to get this error

      Cause: get_status failed due to ORA-01000: maximum open cursors exceeded.

      The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
      01-FEB-2013 11:12:15 - ORACLE error 1000 in get_status

      Cause: get_status failed due to ORA-01000: maximum open cursors exceeded.

      The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
      The call to function PingProcess in cartridge AQCART has failed.
      Job number is: 651

      Suggestions are welcome

      Regards
      Surinder Singh

      Edited by: Surinder Singh on Feb 1, 2013 11:16 AM