Oracle 服务突然中断处理(检查状态、重启)
检查监听状态
lsnrctl status
no listening...
启动监听
lsnrctl start
检查服务状态
[oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 24 18:33:06 2018 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> select status from v$instance; select status from v$instance * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0
启动服务
startup
重启服务
shutdown immediate时要执行完全检查点,不中断事务
shutdown abort时不执行检查点,中断所有事务,关闭数据库连接
shutdown abort / shutdown immediate
startup
防火墙原因
服务未启动原因