关闭oracle一直等待

查询告警日志alert_orcl.log

文件位置：/opt/app/oracle/diag/rdbms/orcl/orcl/trace/  根据实际oracle部署路径查找

关闭数据库执行：shutdown immediate;

查看alert_orcl.log输出的日志信息

Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 52
Wed Jan 27 16:31:38 2021
Active call for process 65920 user 'oracle' program 'oracle@oracledb'
SHUTDOWN: waiting for active calls to complete.

 

可以看出65920的进程还在使用 导致关闭卡死 

ps aux| grep 65920 找到进程号杀掉进程就可以了 kill -9 PID号   然后就可以正常关闭了。