E então, Marcio, como ficou essa história ? A base parou com o shutdown ou não? (Espero que não esteja parando até agora..)
On 24 July 2014 10:06, 'Grupos' [email protected] [oracle_br] < [email protected]> wrote: > > > Eu vi essa nota no metalink. > > > > Vou ver com outras instâncias que tenho nesse servidor, só para confirmar. > Mas me parece que acontece somente com uma instância específica. > > > > Abs. > > > > *De:* [email protected] [mailto:[email protected]] > *Enviada em:* quinta-feira, 24 de julho de 2014 09:56 > *Para:* [email protected] > *Assunto:* Re: [oracle_br] shutdown immediate > > > > > > 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 [email protected] [oracle_br] < > [email protected]> 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: [email protected] > http://certificacaobd.com.br/ > skype: vjunior1981 > > https://mybizcard.co/vitor.jr.385628 > > > > Em 24 de julho de 2014 09:36, 'Grupos' [email protected] > [oracle_br] <[email protected]> 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. > > > > > > >
