运行状态
1 | select sys_context( 'USERENV', 'SID' ) from dual; |
会话列表
1 | SELECT sess.process, sess.status, sess.username, sess.schemaname, sql.sql_text |
正在执行SQL
1 | SELECT b.sid oracleID, |
检查锁表
1 | SELECT l.session_id sid, |
启动历史
1 | select * from dba_hist_database_instance order by startup_time desc; |
检查Oracle服务是否运行
1 | ps -ef | grep pmon |
检查监听是否运行
1 | lsnrctl status |
启动服务
1 | sqlplus / as sysdba |
启动监听
1 | lsnrctl start |
没有网络导致连接超时
1 | vi /etc/resolv.conf |