關(guān)閉RAC中一個實例卡死
朝陽網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián),朝陽網(wǎng)站設(shè)計制作,有大型網(wǎng)站制作公司豐富經(jīng)驗。已為朝陽近1000家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\外貿(mào)網(wǎng)站建設(shè)要多少錢,請找那個售后服務(wù)好的朝陽做網(wǎng)站的公司定做!
SQL>shutdown immediate
后臺日志顯示:
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.
此時,數(shù)據(jù)庫實例關(guān)閉夯住。下面KILL 所有上面顯示的PID號;
# 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
殺完進程后,后臺日志繼續(xù)執(zhí)行關(guān)閉操作,直至成功關(guān)閉,解決。