环境:windows 2000 server ,oracle8.05
故障:oracle突然连接不上,提示:oracle not available ora-01034
查看oracle的安装目录没有缺少文件,控制面板中服务中关于oracle的一切启动正常.
因含有大量有用而且没有备份的数据,十分着急.
请专家帮助,是丢失文件造成的吗?还是系统环境造成的.
请问如何才能排除故障?
------解决方案--------------------
startup 启动看看报什么错误
------解决方案--------------------
oracle没有启动起来，赞成用一楼的方法看下什么原因
可能只是参数设错了呢
先备份数据文件，控制文件和日志文件
------解决方案--------------------
先把控制文件,日志文件,数据文件备份好,再查原因
是不是防火墙的问题?不能访问往往是防火墙不允许访问引起的
------解决方案--------------------
别急，
1.备份好数据文件、控制文件和日志文件
2.查看alert_sid.log文件最后面的记录数据，应该就知道问题在哪里了
------解决方案--------------------
看日志
------解决方案--------------------
------解决方案--------------------
Tmp1orcl.ora 是temp空间吗
参照 http://hi.baidu.com/jdsnhan/blog/item/69c8cab15968d051092302fc.html
把创建 undo 空间的语句换成创建 temp 空间。。
------解决方案--------------------
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.
On the practical side, when your server restarts, the database may not have started completely. Do the following
C:\>sqlplus /nolog
SQL>connect / as sysdba
SQL>startup
If database is already started, shut it down and start it again.
SQL>shutdown immediate or SQL>shutdown abort
You can also use the following methods to connect
SQL>connect as sysdba
Provide internal as username.
SQL>connect internal/oracle
Make sure listener and database services are running in services. If not start them. If some error, remove configurations in Net8 and try again and you will be successful. This should be done at the top actually. I sincerely hope this solves your problem.
------解决方案--------------------
or
change the startup files STRxxx.CMD in the C:\ORANT\DATABASE folder to reflect the change