Shulou(Shulou.com)06/01 Report--

Close an instance in RAC and get stuck.

SQL > shutdown immediate

The background log shows:

Fri Aug 10 14:56:16 2018

Active call for process 43909332 user 'oracle' program' oracle@scodb01 (TNS V1-V3)'

Active call for process 46006466 user 'oracle' program' oracle@scodb01 (TNS V1-V3)'

Active call for process 37224684 user 'oracle' program' oracle@scodb01 (TNS V1-V3)'

Active call for process 17760398 user 'oracle' program' oracle@scodb01 (TNS V1-V3)'

Active call for process 23855332 user 'oracle' program' oracle@scodb01 (TNS V1-V3)'

Active call for process 24248536 user 'oracle' program' oracle@scodb01 (TNS V1-V3)'

Active call for process 40566828 user 'oracle' program' oracle@scodb01 (TNS V1-V3)'

Active call for process 21168160 user 'oracle' program' oracle@scodb01 (TNS V1-V3)'

SHUTDOWN: waiting for active calls to complete.

At this point, the database instance is closed and rammed. All the PID numbers shown above in the KILL below

# su-oracle

/ home/oracle > ps-ef | grep 43909332

Oracle 43909332 1 0 Jan 20-0:24 oraclescodb1 (DESCRIPTION= (LOCAL=YES) (ADDRESS= (PROTOCOL=beq)

/ home/oracle > kill-9 43909332

/ home/oracle > kill-9 46006466

/ home/oracle > kill-9 37224684

/ home/oracle > kill-9 17760398

/ home/oracle > kill-9 23855332

/ home/oracle > kill-9 24248536

/ home/oracle > kill-9 40566828

/ home/oracle > kill-9 21168160

After killing the process, the background log continues to close until it is successfully closed and resolved.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.