查看oracle 是否正常
# 登录到安装oracle的服务器,进入入oracle 用户su - oracle# 进入sql 命令行模式sqlplus / as sysdba# 查看oracle 运行状态select status from v$instance; 如果status = open 就说明oracle服务正常# 通过 设置 状态看能否成功alter database mount;alter database open;
重启oracle进程
1.su - oracle ---切换到oracle用户2.lsnrctl stop ----停监听3.sqlplus / as sysdba4 .SQL>shutdown immediate ---停止oracle5.SQL> startup; ----启服务6.SQL>exit;7.lsnrctl start ----启监听8.emctl start dbconsole9.isqlplusctl start
