查询告警日志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号 然后就可以正常关闭了。