先说一下情况。我是在linux上安装oracle 11g。由于只能远程使用命令行窗口,所以没有图形界面。关于oracle 已经安装完了,实例,监听也已经安装完。但是在连接,打开oracle的时候遇到了问题
显示的是:
SQL> startup
ORACLE instance started.
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 989858148 bytes
Database Buffers 704643072 bytes
Redo Buffers 11608064 bytes
ORA-00205: error in identifying control file, check alert log for more info
看到 00205的错误 然后进入到log.xml中查看日志
发现如下:
ORA-00210: cannot open the specified control file
ORA-00202: control file:
'/opt/oracle/flash_recovery_area/orcl11g/control02.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file:
'/opt/oracle/oradata/orcl11g/control01.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
个人理解字面的意思应该是两个控制文件都找不到。但是网上找到的答案都是会有一个控制文件,但是我这里一个都没有。这怎么办?
有哪位对linux 或者 oracle比较了解的 希望帮下忙
显示的是:
SQL> startup
ORACLE instance started.
Total System Global Area 1707446272 bytes
Fixed Size 1336988 bytes
Variable Size 989858148 bytes
Database Buffers 704643072 bytes
Redo Buffers 11608064 bytes
ORA-00205: error in identifying control file, check alert log for more info
看到 00205的错误 然后进入到log.xml中查看日志
发现如下:
ORA-00210: cannot open the specified control file
ORA-00202: control file:
'/opt/oracle/flash_recovery_area/orcl11g/control02.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file:
'/opt/oracle/oradata/orcl11g/control01.ctl'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
个人理解字面的意思应该是两个控制文件都找不到。但是网上找到的答案都是会有一个控制文件,但是我这里一个都没有。这怎么办?
有哪位对linux 或者 oracle比较了解的 希望帮下忙










