环境:windows 2000 server ,oracle8.05故障:oracle突然连接不上,提示:oracle not available ora-01034 查看oracle的安装目录没有缺少文件,控制面板中服务中关于oracle的一切启动正常.
因含有大量有用而且没有备份的数据,十分着急. 请专家帮助,是丢失文件造成的吗?还是系统环境造成的.
请问如何才能排除故障?
因含有大量有用而且没有备份的数据,十分着急. 请专家帮助,是丢失文件造成的吗?还是系统环境造成的.
请问如何才能排除故障?
可能只是参数设错了呢先备份数据文件,控制文件和日志文件
1.备份好数据文件、控制文件和日志文件
2.查看alert_sid.log文件最后面的记录数据,应该就知道问题在哪里了
1,先去指定目录copy备份好控制文件、日志文件、数据文件;
2,去现有日志里面,看下报啥错误?
3,启动数据库到onmount或者到open状态,去日志里面看报啥错误?
ora-01110:????4?'d:\orant\database\Tmp1orcl.ora请各位高手帮忙分析一下.
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 followingC:\>sqlplus /nolog
SQL>connect / as sysdba
SQL>startupIf 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 connectSQL>connect as sysdba
Provide internal as username.
SQL>connect internal/oracleMake 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.
change the startup files STRxxx.CMD in the C:\ORANT\DATABASE folder to reflect the change