This discussion is archived
3 Replies Latest reply: Apr 10, 2013 5:48 AM by Hussein Sawwan-Oracle RSS

Standard Manager dying

Abbu Newbie
Currently Being Moderated
Hi All/Hussen,

Submitted the request which generates report and it doesn't go into a running status.
Also, it will show the standard manager has having 0 Actual processes. Processes will be in defunct state.

Kindly help me out what to do

Regards,
Abdullah.
  • 1. Re: Standard Manager dying
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please do the following:

    - Stop the CM
    - Run cmclean.sql script -- Concurrent Processing - CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]
    - Start the CM

    If you still have the same issue, please post the details of the application release, database version and OS. Also, please post the contents of the CM log file.

    Please make sure you have no errors in the database log file.

    Thanks,
    Hussein
  • 2. Re: Standard Manager dying
    Abbu Newbie
    Currently Being Moderated
    Hi Hussein,

    ran cmclean.sql and bounced CM but no luck.

    We could see some below errors in alert log and conc log file has been generated as the request has not been run.


    Sat Apr 06 23:22:06 2013
    Incremental checkpoint up to RBA [0x8b4.20736.0], current log tail at RBA [0x8b4.2414d.0]
    Sat Apr 06 23:52:15 2013
    Incremental checkpoint up to RBA [0x8b4.32369.0], current log tail at RBA [0x8b4.34c12.0]
    Sun Apr 07 00:00:06 2013
    Errors in file /d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_j002_20215.trc:
    ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
    ORA-06502: PL/SQL: numeric or value error
    ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
    ORA-06512: at line 1
    Sun Apr 07 00:22:23 2013
    Incremental checkpoint up to RBA [0x8b4.180622.0], current log tail at RBA [0x8b4.183ab0.0]
    Sun Apr 07 00:34:42 2013
    Thread 1 cannot allocate new log, sequence 2229
    Private strand flush not complete
    Current log# 39 seq# 2228 mem# 0: /d03/oracle/oracledata/log39.dbf
    Beginning log switch checkpoint up to RBA [0x8b5.2.10], SCN: 8627040316444
    Thread 1 advanced to log sequence 2229 (LGWR switch)
    Current log# 40 seq# 2229 mem# 0: /d03/oracle/oracledata/log40.dbf
    Sun Apr 07 00:39:47 2013



    Sun Apr 07 20:27:26 2013
    Completed checkpoint up to RBA [0x8c4.2.10], SCN: 8627042954343
    Sun Apr 07 20:35:20 2013
    Incremental checkpoint up to RBA [0x8c4.15be7.0], current log tail at RBA [0x8c4.1977f.0]
    Sun Apr 07 21:05:40 2013
    Incremental checkpoint up to RBA [0x8c4.2717f.0], current log tail at RBA [0x8c4.2b755.0]
    Sun Apr 07 21:07:16 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_21794.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Sun Apr 07 21:11:11 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_21888.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Sun Apr 07 21:11:13 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_21906.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Sun Apr 07 21:12:22 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_21926.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Sun Apr 07 21:13:34 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_21916.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Sun Apr 07 21:15:56 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_21924.trc"




    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Tue Apr 09 21:11:22 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_2347.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Tue Apr 09 21:13:18 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_2353.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Tue Apr 09 21:19:33 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_2359.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Tue Apr 09 21:20:48 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_2355.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Tue Apr 09 21:20:55 2013
    Incremental checkpoint up to RBA [0x8e0.5dc8b.0], current log tail at RBA [0x8e0.67181.0]
    Tue Apr 09 21:21:00 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_2369.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Tue Apr 09 21:21:09 2013
    Non critical error ORA-48913 caught while writing to trace file "/d02/oracle/oracledb/diag/rdbms/oracle/oracle/trace/oracle_ora_2357.trc"
    Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
    Writing to the above trace file is disabled for now on...
    Tue Apr 09 21:51:04 2013
    Incremental checkpoint up to RBA [0x8e0.7a922.0], current log tail at RBA [0x8e0.7e055.0]
    Tue Apr 09 22:04:21 2013
    Thread 1 cannot allocate new log, sequence 2273
    Private strand flush not complete
    Current log# 35 seq# 2272 mem# 0: /d03/oracle/oracledata/log35.dbf
    Beginning log switch checkpoint up to RBA [0x8e1.2.10], SCN: 8627047522822
    Thread 1 advanced to log sequence 2273 (LGWR switch)
    Current log# 36 seq# 2273 mem# 0: /d03/oracle/oracledata/log36.dbf
    Tue Apr 09 22:09:27 2013
    Completed checkpoint up to RBA [0x8e1.2.10], SCN: 8627047522822
    Tue Apr 09 22:21:13 2013
    Incremental checkpoint up to RBA [0x8e1.8cec.0], current log tail at RBA [0x8e1.c4be.0]
    Tue Apr 09 22:51:19 2013
    Incremental checkpoint up to RBA [0x8e1.5bd5c.0], current log tail at RBA [0x8e1.654e5.0]
    Wed Apr 10 00:51:51 2013
    Incremental checkpoint up to RBA [0x8e2.8e36e.0], current log tail at RBA [0x8e2.98c1e.0]
    Wed Apr 10 01:21:58 2013
    Incremental checkpoint up to RBA [0x8e2.e06fb.0], current log tail at RBA [0x8e2.e3e1b.0]
    Wed Apr 10 01:52:04 2013
    Incremental checkpoint up to RBA [0x8e2.111f80.0], current log tail at RBA [0x8e2.1225ae.0]
    Wed Apr 10 02:03:55 2013
    Thread 1 cannot allocate new log, sequence 2275
    Private strand flush not complete
    Current log# 37 seq# 2274 mem# 0: /d03/oracle/oracledata/log37.dbf
    Beginning log switch checkpoint up to RBA [0x8e3.2.10], SCN: 8627047970390
    Thread 1 advanced to log sequence 2275 (LGWR switch)
    Current log# 38 seq# 2275 mem# 0: /d03/oracle/oracledata/log38.dbf
    Wed Apr 10 02:09:09 2013
    Completed checkpoint up to RBA [0x8e3.2.10], SCN: 8627047970390
    Wed Apr 10 02:22:12 2013
    Incremental checkpoint up to RBA [0x8e3.7d05a.0], current log tail at RBA [0x8e3.7f9a7.0]
    Wed Apr 10 02:52:18 2013
    Incremental checkpoint up to RBA [0x8e3.8f8a8.0], current log tail at RBA [0x8e3.92180.0]
    Wed Apr 10 03:22:24 2013
    Incremental checkpoint up to RBA [0x8e3.13013d.0], current log tail at RBA [0x8e3.132956.0]
    Wed Apr 10 03:52:31 2013
    Incremental checkpoint up to RBA [0x8e3.15e193.0], current log tail at RBA [0x8e3.16091e.0]
    Wed Apr 10 04:03:21 2013
    Thread 1 cannot allocate new log, sequence 2276
    Private strand flush not complete
    Current log# 38 seq# 2275 mem# 0: /d03/oracle/oracledata/log38.dbf
    Beginning log switch checkpoint up to RBA [0x8e4.2.10], SCN: 8627048160531
    Thread 1 advanced to log sequence 2276 (LGWR switch)
    Current log# 39 seq# 2276 mem# 0: /d03/oracle/oracledata/log39.dbf
    Wed Apr 10 04:08:33 2013
    Completed checkpoint up to RBA [0x8e4.2.10], SCN: 8627048160531
    Wed Apr 10 04:22:38 2013
    Incremental checkpoint up to RBA [0x8e4.f59bf.0], current log tail at RBA [0x8e4.f9aad.0]
    Wed Apr 10 04:52:44 2013
    Incremental checkpoint up to RBA [0x8e4.108410.0], current log tail at RBA [0x8e4.10bc26.0]

    Thanks,
    Abdullah
  • 3. Re: Standard Manager dying
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please see the following docs.

    ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" [ID 1413756.1]
    ORA-12012 and ORA-1403 Occurred on Auto Execute of JOB [ID 1416056.1]

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points