Ok..Chiappa.. Analisarei as suas recomendações..E trarei novos resultados.
Att, Emerson Martins DBA Oracle Oracle 11g Certified Associate *Contatos:* + 55 82 91235504 / + 55 82 96681283 2013/4/1 J. Laurindo Chiappa <jlchia...@yahoo.com.br> > ** > > > Colega, erros internos do tipo a gente *** SEMPRE *** recomenda que sejam > verificados com o Suporte Oracle que, entre outras coisas, vai ver a > Aplicabilidade no seu cenário dos bugs que possam existir, MAS algo que vc > pode fazer já, até como preparativo para o Chamado, é : > > a) checar a Configuração do seu SO, vendo se ela está PELO MENOS atendendo > ao mínimo citado no manual de Instalação para Windows > > b) checar se a configuração do seu database está razoável, ie : vc não > está com SGA nem absurdamente pequena nem tolamente gigantesca, se vc não > está querendo usar gerenciamento de memóriua automático num ambiente > ultra-mega-dinâmico e exigente, e coisas do gênero > > c) checar a CARGA/CAPACIDADE/UTILIZAÇÃO do seu ambiente e dos seus > recursos : a msg de erro Claramente diz que o RDBMS solicitou para o SO a > criação de um processo/task no sistema e o SO demorou mais que o timeout > estabelecido para essa criação, tipicamente isso acontece quando algum > recurso do ambiente (memória RAM, rede, espaço em disco, I/O throughput, > capacidade de CPU, etc) está sendo tão intensamente consumido que não sobra > para o SO poder criar novas tasks.... Veja nos Eventos do Windows se há > algum registro de consumo atípicode qquer coiusa nesse período em que o > erro aconteceu, e se não houver (é BEM provável de não haver se vc tem tudo > instalado next-next-finish, o Windows não faz muita monitoração de recursos > por default) instale e deixe rodando periodicamente algum software de > Monitoração de recursos , que cubra/registre Pelo Menos a utilização dos > principais recursos, ie : RAM, CPU, I/O e Rede ... > > []s > > Chiappa > > --- Em oracle_br@yahoogrupos.com.br, Emerson Martins <emersonmartins8@...> > escreveu > > > > > Olá pessoal. > > > > Dando uma olhada no alert.log identifiquei um um incidente com as > seguintes > > informações.As mesmas estão sendo informadas resumidamente também no OEM. > > > > Se alguém puder ajudar identificar a causa..Analisando no OEM o alerta > nao > > foi mais dado depois do dia 29/03. > > > > Ambiente > > Windows Server 2008 Standard > > 36G Memoria > > Oracle 11gR2 11.2.0.2 > > > > > > > > *Alert.log* > > > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\*prod_cjq0_6260.trc* > > > (incident=41457): > > ORA-00445: background process "J000" did not start after 120 seconds > > Incident details in: > C:\ORACLE\diag\rdbms\prod\prod\incident\incdir_41457\* > > prod_cjq0_6260_i41457.trc* > > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 11:56:25 2013 > > Dumping diagnostic data in directory=[cdmp_20130329115625], requested by > > (instance=1, osid=6260 (CJQ0)), summary=[incident=41457]. > > Fri Mar 29 11:58:28 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=47521): > > ORA-00445: background process "W000" did not start after 120 seconds > > Incident details in: > > > C:\ORACLE\diag\rdbms\prod\prod\incident\incdir_47521\prod_smco_11052_i47521.trc > > Fri Mar 29 11:58:30 2013 > > Dumping diagnostic data in directory=[cdmp_20130329115830], requested by > > (instance=1, osid=11052 (SMCO)), summary=[incident=47521]. > > Fri Mar 29 12:00:34 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=41458): > > ORA-00445: background process "J000" did not start after 120 seconds > > Incident details in: > > > C:\ORACLE\diag\rdbms\prod\prod\incident\incdir_41458\prod_cjq0_6260_i41458.trc > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:00:36 2013 > > Dumping diagnostic data in directory=[cdmp_20130329120036], requested by > > (instance=1, osid=6260 (CJQ0)), summary=[incident=41458]. > > Fri Mar 29 12:01:34 2013 > > Timed out trying to start process m000. > > Fri Mar 29 12:03:39 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=41459): > > ORA-00445: background process "J000" did not start after 120 seconds > > Incident details in: > > > C:\ORACLE\diag\rdbms\prod\prod\incident\incdir_41459\prod_cjq0_6260_i41459.trc > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:03:42 2013 > > Dumping diagnostic data in directory=[cdmp_20130329120342], requested by > > (instance=1, osid=6260 (CJQ0)), summary=[incident=41459]. > > Fri Mar 29 12:05:45 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=47522): > > ORA-00445: background process "W000" did not start after 120 seconds > > Incident details in: > > > C:\ORACLE\diag\rdbms\prod\prod\incident\incdir_47522\prod_smco_11052_i47522.trc > > Fri Mar 29 12:05:48 2013 > > Dumping diagnostic data in directory=[cdmp_20130329120548], requested by > > (instance=1, osid=11052 (SMCO)), summary=[incident=47522]. > > Fri Mar 29 12:07:51 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=41460): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:09:56 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=47523): > > ORA-00445: background process "W000" did not start after 120 seconds > > Fri Mar 29 12:12:02 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=41461): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:14:07 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=47524): > > ORA-00445: background process "W000" did not start after 120 seconds > > Fri Mar 29 12:16:13 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=41462): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:16:49 2013 > > Timed out trying to start process m000. > > Fri Mar 29 12:18:55 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=41463): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:21:00 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=47525): > > ORA-00445: background process "W000" did not start after 120 seconds > > Fri Mar 29 12:23:06 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=41464): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:25:11 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=47526): > > ORA-00445: background process "W000" did not start after 120 seconds > > Fri Mar 29 12:27:17 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=65201): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:29:23 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=47527): > > ORA-00445: background process "W000" did not start after 120 seconds > > Fri Mar 29 12:31:28 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=65202): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:32:08 2013 > > Timed out trying to start process m000. > > Fri Mar 29 12:34:14 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=65203): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:36:19 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=47528): > > ORA-00445: background process "W000" did not start after 120 seconds > > Fri Mar 29 12:38:25 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=65204): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc: > > Fri Mar 29 12:40:31 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_smco_11052.trc > > (incident=65209): > > ORA-00445: background process "W000" did not start after 120 seconds > > Fri Mar 29 12:42:36 2013 > > Errors in file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > (incident=65205): > > ORA-00445: background process "J000" did not start after 120 seconds > > kkjcre1p: unable to spawn jobq slave process > > > > > > Conteudo do arquivo de trace *prod_cjq0_6260_i41457.trc* > > * > > > * > > Trace file C:\ORACLE\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > Oracle Database 11g Release 11.2.0.2.0 - 64bit Production > > Windows NT Version V6.0 Service Pack 1 > > CPU : 12 - type 8664, 6 Physical Cores > > Process Affinity : 0x0x0000000000000000 > > Memory (Avail/Total): Ph:21664M/32721M, Ph+PgF:54897M/65672M > > Instance name: prod > > Redo thread mounted by this instance: 1 > > Oracle process number: 32 > > Windows thread id: 6260, image: ORACLE.EXE (CJQ0) > > > > > > *** 2013-03-23 06:38:45.063 > > *** SESSION ID:(3339.11) 2013-03-23 06:38:45.063 > > *** CLIENT ID:() 2013-03-23 06:38:45.063 > > *** SERVICE NAME:(SYS$BACKGROUND) 2013-03-23 06:38:45.063 > > *** MODULE NAME:() 2013-03-23 06:38:45.063 > > *** ACTION NAME:() 2013-03-23 06:38:45.063 > > > > Setting Resource Manager plan SCHEDULER[0x310C]:DEFAULT_MAINTENANCE_PLAN > > via scheduler window > > Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter > > Closing scheduler window > > > > *** 2013-03-24 02:00:00.024 > > Closing Resource Manager plan via scheduler window > > Clearing Resource Manager plan via parameter > > Setting Resource Manager plan SCHEDULER[0x310D]:DEFAULT_MAINTENANCE_PLAN > > via scheduler window > > > > *** 2013-03-24 06:00:00.008 > > Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter > > Closing scheduler window > > > > *** 2013-03-25 02:00:00.008 > > Closing Resource Manager plan via scheduler window > > Clearing Resource Manager plan via parameter > > Setting Resource Manager plan SCHEDULER[0x3107]:DEFAULT_MAINTENANCE_PLAN > > via scheduler window > > > > *** 2013-03-25 22:00:00.024 > > Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter > > Closing scheduler window > > > > *** 2013-03-26 02:00:00.008 > > Closing Resource Manager plan via scheduler window > > Clearing Resource Manager plan via parameter > > Setting Resource Manager plan SCHEDULER[0x3108]:DEFAULT_MAINTENANCE_PLAN > > via scheduler window > > > > *** 2013-03-26 22:00:00.038 > > Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter > > Closing scheduler window > > > > *** 2013-03-27 02:00:00.023 > > Closing Resource Manager plan via scheduler window > > Clearing Resource Manager plan via parameter > > Setting Resource Manager plan SCHEDULER[0x3109]:DEFAULT_MAINTENANCE_PLAN > > via scheduler window > > > > *** 2013-03-27 22:00:00.022 > > Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter > > Closing scheduler window > > > > *** 2013-03-28 02:00:00.022 > > Closing Resource Manager plan via scheduler window > > Clearing Resource Manager plan via parameter > > Setting Resource Manager plan SCHEDULER[0x310A]:DEFAULT_MAINTENANCE_PLAN > > via scheduler window > > > > *** 2013-03-28 22:00:00.022 > > Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter > > Closing scheduler window > > > > *** 2013-03-29 02:00:00.022 > > Closing Resource Manager plan via scheduler window > > Clearing Resource Manager plan via parameter > > Waited for process J000 to initialize for 60 seconds > > > > *** 2013-03-29 11:55:18.104 > > Process diagnostic dump for J000, OS id=9448 > > ---------------------------------------------------------- > > os thread scheduling delay history: (sampling every 1.000000 secs) > > 0.000000 secs at [ 11:55:17 ] > > NOTE: scheduling delay has not been sampled for 1.076948 secs 0.000000 > > secs from [ 11:55:13 - 11:55:18 ], 5 sec avg > > 0.000000 secs from [ 11:54:18 - 11:55:18 ], 1 min avg > > 0.000000 secs from [ 11:50:18 - 11:55:18 ], 5 min avg > > Memory (Avail/Total): Ph:20786M/32721M, Ph+PgF:53854M/65672M > > > > > > > > *** 2013-03-29 11:55:18.369 > > Stack: > > ------------------- Call Stack Trace --------------------- > > calling location entry > > point arg #1 > > arg #2 arg #3 arg #4 > > ------------------------------------------- > > ------------------------------------------- > > ---------------- ---------------- ---------------- ---------------- > > 000000007768504A > > 0000000000000000 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > 000000007746C350 > > 0000000077685040 > > 0000000000cb1626 0000000000023558 000000005ea1f808 000000007ffffff6 > > sskgmfindrealm()+37 > > 000000007746C2B0 > > 00000000000001c0 00005b1e00000000 0000000000000000 00000000000001c0 > > skgmattach()+261 > > sskgmfindrealm() > > 0001cc7101d1108b 000004a70001e565 07c2ce5900000000 000927e200000000 > > ksmlsge_phaseone()+388 > > skgmattach()+253 > > 000000004b9500e0 0000000000000000 000000004b950088 0000000000000049 > > opimai_init()+151 > > ksmlsge_phaseone() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > opimai_real()+247 > > opimai_init() > > 01ce2c8d49550806 0000000000000000 000b001d000307dd 0005010800110036 > > opimai()+191 > > opimai_real() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > BackgroundThreadStart()+646 opimai() > > 000000005ea1fe68 > > 000000000000000d 0000000000000000 0000000000000000 > > 00000000774643BD > > BackgroundThreadStart() > > 0000000015d64210 0000000000000000 0000000000000000 0000000000000000 > > 00000000776681D1 > > 00000000774643B0 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > ---------------- End of Call Stack Trace ----------------- > > Call stack acquisition performance stats: > > setup time (lock acquis., memory alloc.): 0 ms > > frame get time (time the target proc was suspended): 78 ms > > symbol translation time: 78 ms > > total time: 156 ms > > > > ---------------------------------------------------------- > > Process diagnostic dump actual duration=0.265000 sec > > (max dump time=30.000000 sec) > > > > *** 2013-03-29 11:55:18.369 > > > > *** 2013-03-29 11:55:33.580 > > Waited for process J000 to initialize for 76 seconds > > > > *** 2013-03-29 11:55:33.580 > > Process diagnostic dump for J000, OS id=9448 > > ---------------------------------------------------------- > > os thread scheduling delay history: (sampling every 1.000000 secs) > > 0.000000 secs at [ 11:55:33 ] > > NOTE: scheduling delay has not been sampled for 0.406102 secs 0.000000 > > secs from [ 11:55:28 - 11:55:34 ], 5 sec avg > > 0.000000 secs from [ 11:54:33 - 11:55:34 ], 1 min avg > > 0.000000 secs from [ 11:50:33 - 11:55:34 ], 5 min avg > > Memory (Avail/Total): Ph:20784M/32721M, Ph+PgF:53851M/65672M > > > > > > Stack: > > ------------------- Call Stack Trace --------------------- > > calling location entry > > point arg #1 > > arg #2 arg #3 arg #4 > > ------------------------------------------- > > ------------------------------------------- > > ---------------- ---------------- ---------------- ---------------- > > 000000007768504A > > 0000000000000000 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > 000000007746C350 > > 0000000077685040 > > 0000000000cb1626 0000000000023558 000000005ea1f808 000000007ffffff6 > > sskgmfindrealm()+37 > > 000000007746C2B0 > > 00000000000001c0 00005b1e00000000 0000000000000000 00000000000001c0 > > skgmattach()+261 > > sskgmfindrealm() > > 0001cc7101d1108b 000004a70001e565 07c2ce5900000000 000927e200000000 > > ksmlsge_phaseone()+388 > > skgmattach()+253 > > 000000004b9500e0 0000000000000000 000000004b950088 0000000000000049 > > opimai_init()+151 > > ksmlsge_phaseone() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > opimai_real()+247 > > opimai_init() > > 01ce2c8d49550806 0000000000000000 000b001d000307dd 0005010800110036 > > opimai()+191 > > opimai_real() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > BackgroundThreadStart()+646 opimai() > > 000000005ea1fe68 > > 000000000000000d 0000000000000000 0000000000000000 > > 00000000774643BD > > BackgroundThreadStart() > > 0000000015d64210 0000000000000000 0000000000000000 0000000000000000 > > 00000000776681D1 > > 00000000774643B0 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > ---------------- End of Call Stack Trace ----------------- > > Call stack acquisition performance stats: > > setup time (lock acquis., memory alloc.): 0 ms > > frame get time (time the target proc was suspended): 47 ms > > symbol translation time: 0 ms > > total time: 47 ms > > > > ---------------------------------------------------------- > > Process diagnostic dump actual duration=0.156000 sec > > (max dump time=30.000000 sec) > > > > *** 2013-03-29 11:55:33.736 > > > > *** 2013-03-29 11:55:48.946 > > Waited for process J000 to initialize for 91 seconds > > > > *** 2013-03-29 11:55:48.946 > > Process diagnostic dump for J000, OS id=9448 > > ---------------------------------------------------------- > > os thread scheduling delay history: (sampling every 1.000000 secs) > > 0.000000 secs at [ 11:55:48 ] > > NOTE: scheduling delay has not been sampled for 0.702367 secs 0.000000 > > secs from [ 11:55:45 - 11:55:49 ], 5 sec avg > > 0.000000 secs from [ 11:54:49 - 11:55:49 ], 1 min avg > > 0.000000 secs from [ 11:50:49 - 11:55:49 ], 5 min avg > > Memory (Avail/Total): Ph:20794M/32721M, Ph+PgF:53864M/65672M > > > > > > Stack: > > ------------------- Call Stack Trace --------------------- > > calling location entry > > point arg #1 > > arg #2 arg #3 arg #4 > > ------------------------------------------- > > ------------------------------------------- > > ---------------- ---------------- ---------------- ---------------- > > 000000007768504A > > 0000000000000000 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > 000000007746C350 > > 0000000077685040 > > 0000000000cb1626 0000000000023558 000000005ea1f808 000000007ffffff6 > > sskgmfindrealm()+37 > > 000000007746C2B0 > > 00000000000001c0 00005b1e00000000 0000000000000000 00000000000001c0 > > skgmattach()+261 > > sskgmfindrealm() > > 0001cc7101d1108b 000004a70001e565 07c2ce5900000000 000927e200000000 > > ksmlsge_phaseone()+388 > > skgmattach()+253 > > 000000004b9500e0 0000000000000000 000000004b950088 0000000000000049 > > opimai_init()+151 > > ksmlsge_phaseone() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > opimai_real()+247 > > opimai_init() > > 01ce2c8d49550806 0000000000000000 000b001d000307dd 0005010800110036 > > opimai()+191 > > opimai_real() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > BackgroundThreadStart()+646 opimai() > > 000000005ea1fe68 > > 000000000000000d 0000000000000000 0000000000000000 > > 00000000774643BD > > BackgroundThreadStart() > > 0000000015d64210 0000000000000000 0000000000000000 0000000000000000 > > 00000000776681D1 > > 00000000774643B0 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > ---------------- End of Call Stack Trace ----------------- > > Call stack acquisition performance stats: > > setup time (lock acquis., memory alloc.): 0 ms > > frame get time (time the target proc was suspended): 16 ms > > symbol translation time: 16 ms > > total time: 32 ms > > > > ---------------------------------------------------------- > > Process diagnostic dump actual duration=0.141000 sec > > (max dump time=30.000000 sec) > > > > *** 2013-03-29 11:55:49.086 > > > > *** 2013-03-29 11:56:04.296 > > Waited for process J000 to initialize for 107 seconds > > > > *** 2013-03-29 11:56:04.296 > > Process diagnostic dump for J000, OS id=9448 > > ---------------------------------------------------------- > > os thread scheduling delay history: (sampling every 1.000000 secs) > > 0.000000 secs at [ 11:56:03 ] > > NOTE: scheduling delay has not been sampled for 0.983239 secs 0.000000 > > secs from [ 11:56:00 - 11:56:04 ], 5 sec avg > > 0.000000 secs from [ 11:55:05 - 11:56:04 ], 1 min avg > > 0.000000 secs from [ 11:51:05 - 11:56:04 ], 5 min avg > > Memory (Avail/Total): Ph:20792M/32721M, Ph+PgF:53863M/65672M > > > > > > Stack: > > ------------------- Call Stack Trace --------------------- > > calling location entry > > point arg #1 > > arg #2 arg #3 arg #4 > > ------------------------------------------- > > ------------------------------------------- > > ---------------- ---------------- ---------------- ---------------- > > 000000007768504A > > 0000000000000000 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > 000000007746C350 > > 0000000077685040 > > 0000000000cb1626 0000000000023558 000000005ea1f808 000000007ffffff6 > > sskgmfindrealm()+37 > > 000000007746C2B0 > > 00000000000001c0 00005b1e00000000 0000000000000000 00000000000001c0 > > skgmattach()+261 > > sskgmfindrealm() > > 0001cc7101d1108b 000004a70001e565 07c2ce5900000000 000927e200000000 > > ksmlsge_phaseone()+388 > > skgmattach()+253 > > 000000004b9500e0 0000000000000000 000000004b950088 0000000000000049 > > opimai_init()+151 > > ksmlsge_phaseone() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > opimai_real()+247 > > opimai_init() > > 01ce2c8d49550806 0000000000000000 000b001d000307dd 0005010800110036 > > opimai()+191 > > opimai_real() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > BackgroundThreadStart()+646 opimai() > > 000000005ea1fe68 > > 000000000000000d 0000000000000000 0000000000000000 > > 00000000774643BD > > BackgroundThreadStart() > > 0000000015d64210 0000000000000000 0000000000000000 0000000000000000 > > 00000000776681D1 > > 00000000774643B0 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > ---------------- End of Call Stack Trace ----------------- > > Call stack acquisition performance stats: > > setup time (lock acquis., memory alloc.): 0 ms > > frame get time (time the target proc was suspended): 47 ms > > symbol translation time: 0 ms > > total time: 47 ms > > > > ---------------------------------------------------------- > > Process diagnostic dump actual duration=0.156000 sec > > (max dump time=30.000000 sec) > > > > *** 2013-03-29 11:56:04.452 > > > > *** 2013-03-29 11:56:17.275 > > Killing process (ospid 9448): (reason=KSOREQ_WAIT_CANCELLED error=0) > > Dump file c:\oracle\diag\rdbms\prod\prod\trace\prod_cjq0_6260.trc > > Fri Mar 29 11:56:22 2013 > > ORACLE V11.2.0.2.0 - 64bit Production vsnsta=0 > > vsnsql=16 vsnxtr=3 > > *** 2013-03-29 11:56:22.751 ssthreadkillsafe: about to forcefully > terminate > > tid=9448, dumping call stack: > > ------------------- Call Stack Trace --------------------- > > > > *** 2013-03-29 11:56:22.782 > > calling location entry > > point arg #1 > > arg #2 arg #3 arg #4 > > ------------------------------------------- > > ------------------------------------------- > > ---------------- ---------------- ---------------- ---------------- > > 000000007768504A > > 0000000000000000 > > 3130320000000004 0000000000000033 0000000000000000 0000000000000032 > > 000000007746C350 > > 0000000077685040 > > 0000000000cb1626 0000000000023558 000000005ea1f808 000000007ffffff6 > > sskgmfindrealm()+37 > > 000000007746C2B0 > > 00000000000001c0 00005b1e00000000 0000000000000000 00000000000001c0 > > skgmattach()+261 > > sskgmfindrealm() > > 0001cc7101d1108b 000004a70001e565 07c2ce5900000000 000927e200000000 > > ksmlsge_phaseone()+388 > > skgmattach()+253 > > 000000004b9500e0 0000000000000000 000000004b950088 0000000000000049 > > opimai_init()+151 > > ksmlsge_phaseone() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > opimai_real()+247 > > opimai_init() > > 01ce2c8d49550806 0000000000000000 000b001d000307dd 0005010800110036 > > opimai()+191 > > opimai_real() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > BackgroundThreadStart()+646 opimai() > > 000000005ea1fe68 > > 000000000000000d 0000000000000000 0000000000000000 > > 00000000774643BD > > BackgroundThreadStart() > > 0000000015d64210 0000000000000000 0000000000000000 0000000000000000 > > 00000000776681D1 > > 00000000774643B0 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > ---------------- End of Call Stack Trace ----------------- > > Call stack acquisition performance stats: > > setup time (lock acquis., memory alloc.): 0 ms > > frame get time (time the target proc was suspended): 16 ms > > symbol translation time: 0 ms > > total time: 16 ms > > Incident 41457 created, dump file: > > > C:\ORACLE\diag\rdbms\prod\prod\incident\incdir_41457\prod_cjq0_6260_i41457.trc > > ORA-00445: background process "J000" did not start after 120 seconds > > > > > > *** 2013-03-29 11:59:29.219 > > Waited for process J000 to initialize for 60 seconds > > > > *** 2013-03-29 11:59:29.219 > > Process diagnostic dump for J000, OS id=6540 > > ---------------------------------------------------------- > > os thread scheduling delay history: (sampling every 1.000000 secs) > > 0.000000 secs at [ 11:59:28 ] > > NOTE: scheduling delay has not been sampled for 0.468394 secs 0.000000 > > secs from [ 11:59:24 - 11:59:29 ], 5 sec avg > > 0.000000 secs from [ 11:58:29 - 11:59:29 ], 1 min avg > > 0.000000 secs from [ 11:54:29 - 11:59:29 ], 5 min avg > > Memory (Avail/Total): Ph:20722M/32721M, Ph+PgF:53707M/65672M > > > > > > Stack: > > ------------------- Call Stack Trace --------------------- > > calling location entry > > point arg #1 > > arg #2 arg #3 arg #4 > > ------------------------------------------- > > ------------------------------------------- > > ---------------- ---------------- ---------------- ---------------- > > 000000007768504A > > 0000000000000000 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > 000000007746C350 > > 0000000077685040 > > 0000000000cb1626 0000000000023558 000000005ea1f808 000000007ffffff6 > > sskgmfindrealm()+37 > > 000000007746C2B0 > > 00000000000001c0 00005b1f00000000 0000000000000000 00000000000001c0 > > skgmattach()+261 > > sskgmfindrealm() > > 00019e8c01d090e8 000004a70001edb2 07c315be00000000 000928bb00000000 > > ksmlsge_phaseone()+388 > > skgmattach()+253 > > 00000000376800e0 0000000000000000 0000000037680088 0000000000000049 > > opimai_init()+151 > > ksmlsge_phaseone() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > opimai_real()+247 > > opimai_init() > > 01ce2c8ddf19ea11 0000000000000000 000b001d000307dd 00050217001c003a > > opimai()+191 > > opimai_real() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > BackgroundThreadStart()+646 opimai() > > 000000005ea1fe68 > > 000000000000000d 0000000000000000 0000000000000000 > > 00000000774643BD > > BackgroundThreadStart() > > 00000000b920f540 0000000000000000 0000000000000000 0000000000000000 > > 00000000776681D1 > > 00000000774643B0 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > ---------------- End of Call Stack Trace ----------------- > > Call stack acquisition performance stats: > > setup time (lock acquis., memory alloc.): 0 ms > > frame get time (time the target proc was suspended): 47 ms > > symbol translation time: 0 ms > > total time: 47 ms > > > > ---------------------------------------------------------- > > Process diagnostic dump actual duration=0.156000 sec > > (max dump time=30.000000 sec) > > > > *** 2013-03-29 11:59:29.375 > > > > *** 2013-03-29 11:59:44.585 > > Waited for process J000 to initialize for 76 seconds > > > > *** 2013-03-29 11:59:44.585 > > Process diagnostic dump for J000, OS id=6540 > > ---------------------------------------------------------- > > os thread scheduling delay history: (sampling every 1.000000 secs) > > 0.000000 secs at [ 11:59:43 ] > > NOTE: scheduling delay has not been sampled for 0.764675 secs 0.000000 > > secs from [ 11:59:40 - 11:59:44 ], 5 sec avg > > 0.000000 secs from [ 11:58:44 - 11:59:44 ], 1 min avg > > 0.000000 secs from [ 11:54:44 - 11:59:44 ], 5 min avg > > Memory (Avail/Total): Ph:20716M/32721M, Ph+PgF:53707M/65672M > > > > > > Stack: > > ------------------- Call Stack Trace --------------------- > > calling location entry > > point arg #1 > > arg #2 arg #3 arg #4 > > ------------------------------------------- > > ------------------------------------------- > > ---------------- ---------------- ---------------- ---------------- > > 000000007768504A > > 0000000000000000 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > 000000007746C350 > > 0000000077685040 > > 0000000000cb1626 0000000000023558 000000005ea1f808 000000007ffffff6 > > sskgmfindrealm()+37 > > 000000007746C2B0 > > 00000000000001c0 00005b1f00000000 0000000000000000 00000000000001c0 > > skgmattach()+261 > > sskgmfindrealm() > > 00019e8c01d090e8 000004a70001edb2 07c315be00000000 000928bb00000000 > > ksmlsge_phaseone()+388 > > skgmattach()+253 > > 00000000376800e0 0000000000000000 0000000037680088 0000000000000049 > > opimai_init()+151 > > ksmlsge_phaseone() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > opimai_real()+247 > > opimai_init() > > 01ce2c8ddf19ea11 0000000000000000 000b001d000307dd 00050217001c003a > > opimai()+191 > > opimai_real() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > BackgroundThreadStart()+646 opimai() > > 000000005ea1fe68 > > 000000000000000d 0000000000000000 0000000000000000 > > 00000000774643BD > > BackgroundThreadStart() > > 00000000b920f540 0000000000000000 0000000000000000 0000000000000000 > > 00000000776681D1 > > 00000000774643B0 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > ---------------- End of Call Stack Trace ----------------- > > Call stack acquisition performance stats: > > setup time (lock acquis., memory alloc.): 0 ms > > frame get time (time the target proc was suspended): 47 ms > > symbol translation time: 0 ms > > total time: 47 ms > > > > ---------------------------------------------------------- > > Process diagnostic dump actual duration=0.156000 sec > > (max dump time=30.000000 sec) > > > > *** 2013-03-29 11:59:44.741 > > > > *** 2013-03-29 11:59:59.951 > > Waited for process J000 to initialize for 91 seconds > > > > *** 2013-03-29 11:59:59.951 > > Process diagnostic dump for J000, OS id=6540 > > ---------------------------------------------------------- > > os thread scheduling delay history: (sampling every 1.000000 secs) > > 0.000000 secs at [ 11:59:58 ] > > NOTE: scheduling delay has not been sampled for 1.061053 secs 0.000000 > > secs from [ 11:59:55 - 11:59:59 ], 5 sec avg > > 0.000000 secs from [ 11:59:00 - 11:59:59 ], 1 min avg > > 0.000000 secs from [ 11:55:00 - 11:59:59 ], 5 min avg > > Memory (Avail/Total): Ph:20688M/32721M, Ph+PgF:53708M/65672M > > > > > > > > *** 2013-03-29 12:00:00.123 > > Stack: > > ------------------- Call Stack Trace --------------------- > > calling location entry > > point arg #1 > > arg #2 arg #3 arg #4 > > ------------------------------------------- > > ------------------------------------------- > > ---------------- ---------------- ---------------- ---------------- > > 000000007768504A > > 0000000000000000 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > 000000007746C350 > > 0000000077685040 > > 0000000000cb1626 0000000000023558 000000005ea1f808 000000007ffffff6 > > sskgmfindrealm()+37 > > 000000007746C2B0 > > 00000000000001c0 00005b1f00000000 0000000000000000 00000000000001c0 > > skgmattach()+261 > > sskgmfindrealm() > > 00019e8c01d090e8 000004a70001edb2 07c315be00000000 000928bb00000000 > > ksmlsge_phaseone()+388 > > skgmattach()+253 > > 00000000376800e0 0000000000000000 0000000037680088 0000000000000049 > > opimai_init()+151 > > ksmlsge_phaseone() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > opimai_real()+247 > > opimai_init() > > 01ce2c8ddf19ea11 0000000000000000 000b001d000307dd 00050217001c003a > > opimai()+191 > > opimai_real() > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > BackgroundThreadStart()+646 opimai() > > 000000005ea1fe68 > > 000000000000000d 0000000000000000 0000000000000000 > > 00000000774643BD > > BackgroundThreadStart() > > 00000000b920f540 0000000000000000 0000000000000000 0000000000000000 > > 00000000776681D1 > > 00000000774643B0 > > 0000000000000000 0000000000000000 0000000000000000 0000000000000000 > > ---------------- End of Call Stack Trace ----------------- > > Call stack acquisition performance stats: > > setup time (lock acquis., memory alloc.): 0 ms > > frame get time (time the target proc was suspended): 62 ms > > symbol translation time: 0 ms > > total time: 62 ms > > > > ---------------------------------------------------------- > > Process diagnostic dump actual duration=0.171000 sec > > (max dump time=30.000000 sec) > > > > *** 2013-03-29 12:00:00.123 > > > > *** 2013-03-29 12:00:15.333 > > Waited for process J000 to initialize for 106 seconds > > .... > > > > Att, > > > > Emerson Martins > > DBA Oracle > > Oracle 11g Certified Associate > > *Contatos:* > > + 55 82 91235504 / > > + 55 82 96681283 > > > > > > [As partes desta mensagem que não continham texto foram removidas] > > > > > [As partes desta mensagem que não continham texto foram removidas] ------------------------------------ -------------------------------------------------------------------------------------------------------------------------- >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira >responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ -------------------------------------------------------------------------------------------------------------------------- >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » Procedure » >Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE: >http://www.oraclebr.com.br/ ------------------------------------------------------------------------------------------------------------------------ Links do Yahoo! Grupos <*> Para visitar o site do seu grupo na web, acesse: http://br.groups.yahoo.com/group/oracle_br/ <*> Para sair deste grupo, envie um e-mail para: oracle_br-unsubscr...@yahoogrupos.com.br <*> O uso que você faz do Yahoo! Grupos está sujeito aos: http://br.yahoo.com/info/utos.html
