ORA-01033: ORACLE initialization or shutdown in progress Cause: An attempt was made to log on while Oracle is being started up or shutdown. Action: Wait a few minutes. Then retry the operation
我是用plsqldev登陆的,只是ORA-01033: ORACLE initialization or shutdown in progress
连接之前指定一下Oracle SID 看看。 windows: set ORACLE_SID=XX
linux: export ORACLE_SID=XX还有检查下Oracle home 路径是否正确。------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
2、运行sqlplus "/as sysdba"
SQL>shutdown immediate 停止服务
SQL>startup 启动服务,观察启动时有无数据文件加载报错,并记住出错数据文件标号
SQL>shutdown immediate 再次停止服务
SQL>startup mount
SQL> recover datafile 2 恢复出错的数据文件
SQL>shutdown immediate 再次停止服务
SQL>startup 启动服务,此次正常。
这时如果连接,则会出现上述错误提示。如果关闭时间长,可以使用shutdown abort来强制关闭
然后重新启动试试
Cause: An attempt was made to log on while Oracle is being started up or shutdown.
Action: Wait a few minutes. Then retry the operation