3 Replies Latest reply: Apr 10, 2013 7:48 AM by Hussein Sawwan-Oracle RSS

    Standard Manager dying

    934200
      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
          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
            934200
            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
              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