ora-00205
SQL> startup oraCLE instance started. Total System Global Area 125829120 bytes Fixed Size 1218052 bytes Variable Size 117443068 bytes Database Buffers 4194304 bytes Redo Buffers 2973696 bytes ora-00205: error in identifying control file, check alert log for more info ora-00313: open failed for members of log group 1 of thread 1 ora-00312: ...
by qqadmini - Oracle - 2009-03-23 22:27:18 阅读（2584） 回复（7）
db1@root[/>]su - oracle db1@root[/oracle>]sqlplus '/as sysdba' SQL*Plus: Release 9.2.0.6.0 - Production on Mon Mar 16 22:02:17 2009 HACMP Event Summary Event: network_down_complete -1 net_rs232_01 Start time: Mon Mar 16 22:01:21 2009 End time: Mon Mar 16 22:01:21 2009 Action: Resource: Script Name: ------------------------------------------...
将oracle的控制文件删除掉一个，使用alter system set control_file=.....修改spfile文件，然后使用host copy 将控制文件复制一个到nfs共享目录下，启动的时候报ora-00205 错误。但是如果使用以上步骤将control复制到本地硬盘上，不会有问题。 该nfs的挂载方式为: mount -t nfs -o rw,hard,nointr,tcp,noac,timeo=600,rsize=32768,wsize=32768 ip:/app /mnt/bak nfs服务器的exports为： /app 192.168.1.4(rw,async,no_root_squash)...
为学习方便，我在自己的计算机上安装了oracle 9.2 今早启动数据库时，报ora-00205错误，提示为： ora-00205 error in identifying controlfile, check alert log for more info 我的操作系统是win2000 professional，oracle 9.2；oracle安装在d:\oracle\ora92下，数据文件在c:\oracle\oradata\，SID是MIB。 问：下文所说的initialization parameter file是否是指ora.ini？我只在d:\oracle\admin\MIB\pfile中找到类似文件：init....
用SQL>conn /as sysdba连接后，然后 SQL>startup 后报这个错误 ora-01078: failure in processing system parameters LRM-00109: could not open parameter file '/oracle/product/9.2/dbs/initora9i.ora'' 我在/opt/oracle/product/9.2/dbs 下没有找到initora9i.ora，只有init.ora和initdw.ora 我按照网上介绍 cp init.ora initora9i.ora 然后startup 报这个错误 ora-00205: error in identifying controlfile, check alert log...
SQL>; startup mount >;oraCLE instance started. >; >;Total System Global Area 127371024 bytes >;Fixed Size 743184 bytes >;Variable Size 109051904 bytes >;Database Buffers 16777216 bytes >;Redo Buffers 798720 bytes >;ora-00205: error in identifying controlfile, check alert log for more info
求救： ora-00205: error in identifying control file, check alert log for more info SQL> startup oraCLE instance started. Total System Global Area 96468992 bytes Fixed Size 1217884 bytes Variable Size 88083108 bytes Database Buffers 4194304 bytes Redo Buffers 2973696 bytes ora-00205: error in identifying control file, check alert log for ...
Sat Mar 19 09:55:05 2005 ALTER DATABASE MOUNT Sat Mar 19 09:55:05 2005 ora-00202: controlfile: 'ora_control1' ora-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 Sat Mar 19 09:55:05 2005 ora-205 signalled during: ALTER DATABASE MOUNT... Starting oraCLE instance (normal) Starting oraCLE instance (normal) Shutting down instance: further log...
