ORA-01034 ORACLE not available Cause Oracle was not started. Possible causes include the following: The SGA requires more space than was allocated for it. The operating-system variable pointing to the instance is improperly defined. Action Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform-specific Oracle documentation.
看你情况一定是windown下oracle 把控制面版->服务中oracle相应的服务都启动 然后你用 8i库: svrmgrl>connect internal svrmgrl>startup force 9i库: sqlplus nolog sql>conn / as sysdba; sql>startup
因非法关机,经常导致检查点不一致。 把控制面版->服务中oracle相应的服务都启动 然后你用 8i库: svrmgrl>connect internal svrmgrl>shutdown abort svrmgrl>startup mount svrmgrl>recover database until time '上次能正常启动的时间‘; 例 svrmgrl>recover database until time '2003-04-24:08:30:30’; svrmgrl>alter database open resetlogs; OK了。
已经启动了阿,还要用别的什么启动吗?
sqlplus/nolog
connect ...
startup
请输入用户名:system/manager@asia
ora-01034 oracle not available这怎么办啊,还是那个问题啊
startup
c:>svrmgrl
如果是oracle80x
c:>svrmgr30SVRMGR>connect internal/oracle
SVRMGR>startup
SVRMGR>exitC:>lsnrctl start
Action Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform-specific Oracle documentation.
就会报这个错误消息。
手工启动SVRMGRL>STARTUP 看看报什么错误信息。
把控制面版->服务中oracle相应的服务都启动
然后你用
8i库:
svrmgrl>connect internal
svrmgrl>startup force
9i库:
sqlplus nolog
sql>conn / as sysdba;
sql>startup
把控制面版->服务中oracle相应的服务都启动
然后你用
8i库:
svrmgrl>connect internal
svrmgrl>shutdown abort
svrmgrl>startup mount
svrmgrl>recover database until time '上次能正常启动的时间‘;
例
svrmgrl>recover database until time '2003-04-24:08:30:30’;
svrmgrl>alter database open resetlogs;
OK了。