oracle实例无法启动也无法关闭

在做IMP 导入时,突然停止了导入,DOS窗口停止,于是强制关闭了DOS窗口,

cd>sqlplus

请输入用户名:test/test@orac

ora-01089:immediate shutdown in process  -no operations are permittede;

请输入用户名:sys/***@orac as sysdba

sql>shutdown immediate

ora-01089:immediate shutdown in process  -no operations are permittede;

sql>startup

ora-01081:cannot start already--running OEACLE ---shut it down first

sql>shutdown abort

ora-03113:通信通道的文件结束

sql>

sql>

sqL
sql>select * from dual;

ora-03114:未连接到ORACLE

sql>shutdown immediate

ora-12500:TNS:监听程序无法启动

sql>exit

cd> net start OracleServiceOrac

OracleServiceOrac 服务正在启动。。。。。。。。

OracleServiceOrac 服务已经启动成功

cd>sqlplus

请输入用户名:test/test@orac

已连接

sql>select * from dual

D

X

oracle shutdown immediate 关闭较慢而不是 immediate

 

 

 

 

 

posted @ 2010-09-07 19:17  居后不争  阅读(878)  评论(0编辑  收藏  举报