ORA-01033 Oracle startup or shutdown in progress Cause: An attempt was made to log on while Oracle is being started up or shut down.
Action: Wait a few minutes. Then retry the operation. 连接中断了,也许是网络的问题
Action: Wait a few minutes. Then retry the operation. 连接中断了,也许是网络的问题
Connected.
SVRMGR> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 26611712 bytes
Fixed Size 49152 bytes
Variable Size 24342528 bytes
Database Buffers 2048000 bytes
Redo Buffers 172032 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
SVRMGR>
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL>RECOVER DATABASE until time '2004-08-08:15:30:30';
SQL> alter database open resetlogs;
需要重建表空间
启动数据库方法解决方法:先让该数据文件脱机,就可以打开数据库C:\>svrmgrlsvrmgrl>connect internalsvrmgrl>shutdownsvrmgrl>startup mount--ARCHIVELOG模式命令,文件名要大写svrmgrl>alter database datafile ‘C:\TEST.ORA’offline;-NOARCHIVELOG模式命令svrmgrl>alter database datafile ‘C:\TEST.ORA’offline drop;svrmgrl>alter database open;