De acordo com o metalink...
APPLIES TO:Oracle Server - Enterprise Edition - Version 11.2.0.3 and later Information in this document applies to any platform. SYMPTOMS Performing shutdown immediate on a database and it hangs with a message like below in the alert log: Mon Nov 26 10:34:22 2012 SHUTDOWN: waiting for detached processes 'VKRM' to terminate. CAUSE This is actually an OS issue. Virtual sKeduler for Resource Manager Process, serves as a centralized scheduler for Resource Manager activity VKRM manages the CPU scheduling for all managed Oracle processes. The process schedules managed processes in accordance with an active resource plan. Oracle is waiting for the OS to clean up that process. 'SHUTDOWN IMMEDIATE OF 11G DATABASE HANG FOR VKTM' is reported in multiple bug reports before as shown below: Bug 8905174 <https://support.oracle.com/epmos/faces/BugDisplay?id=8905174> - SHUTDOWN IMMEDIATE OF 11G DATABASE HANG FOR VKTM status 33 Bug 9839828 <https://support.oracle.com/epmos/faces/BugDisplay?id=9839828> - VKTM TAKES A LONG TIME TO STOP status 33 Bug 14031869 <https://support.oracle.com/epmos/faces/BugDisplay?id=14031869> - SHUTDOWN IMMEDIATE HANGS WITH SHUTDOWN: WAITING FOR DETACHED PROCESSES The above bugs do not have any fix as they were confirmed not a code problem, but an OS issue. SOLUTION If this issue occurs again we suggest to open a ticket with your OS vendor to assist. Also you can take the following diagnostics: 1. A system state during the shutdown hang: sqlplus / as sysdba oradebug setmypid oradebug unlimit; oradebug dump systemstate 266 --wait 30 seconds oradebug dump systemstate 266 --wait 30 seconds oradebug dump systemstate 266 -- To get the tracefile name oradebug tracefile_name 2. Get a truss/strace of the vktm process, or other defunct process. 3. Run the shutdown immediate in a truss/strace command: strace -aefo /tmp/shutdown.txt sqlplus / as sysdba shutdown immediate 4. Get a pstack of the defunct process On 24 July 2014 09:41, Vitor Junior vitorj...@gmail.com [oracle_br] < oracle_br@yahoogrupos.com.br> wrote: > > > SHUTDOWN: Waiting For Detached Processes 'VKRM' To Terminate (Doc ID > 1511460.1) > > > > Att,/Regards, > > > Vitor Jr. > Infraestrutura / Infrastructure Team > Oracle 11g DBA Certified Professional - OCP > Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid > Infrastructure Administrator - OCE > Oracle Database 11g Performance Tuning Certified Expert - OCE > Oracle Exadata 11g Certified Implementation Specialist > Oracle Certified Associate, MySQL 5 > mail, gtalk e msn: vitorj...@gmail.com > http://certificacaobd.com.br/ > skype: vjunior1981 > https://mybizcard.co/vitor.jr.385628 > > > Em 24 de julho de 2014 09:36, 'Grupos' marcio_...@yahoo.com.br > [oracle_br] <oracle_br@yahoogrupos.com.br> escreveu: > > >> >> Bom dia! >> >> >> >> Estou tentando tirar uma instância do ar, e está parada no processo: >> SHUTDOWN: waiting for detached processes 'VKRM' to terminate. >> >> >> >> >> >> Executei o comando shutdown immediate, no oracle versão 11.2.0.3, HP-UX. >> >> >> >> Alguém passou por isso, ou tem algum link para contornar este problema? >> >> >> >> Márcio. >> >> > >
