请教:
启动数库时显示:Total System Global Area138412032 bytes
Fixed Size 1218124 bytes
Variable Size 79694260 bytes
Database Buffers 50331648 bytes
Redo Buffers 7168000 bytes
ORA-00205: error in identifying control file, check alert log for more info
日文件里:
ORA-00202: control file: '/home/oracle/ora10/product/10.1.10/db_1/dbs/cntrlzxj_data.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
但cntrlzxj_data.dbf这个文件没有
请问怎么解决?
ORA-00202
这个错误应该是控制文件出了问题。 home/oracle/ora10/product/10.1.10/db_1/dbs/cntrlzxj_data.dbf
它要找的这个文件不存在。
看一下你的spfile是否正常。 spfilezxjdata.ora,这个文件吗? 查看一下内容。 6.zxjdata.__db_cache_size=398458880
zxjdata.__java_pool_size=4194304
zxjdata.__large_pool_size=4194304
zxjdata.__shared_pool_size=150994944
zxjdata.__streams_pool_size=0
*.audit_file_dest='/opt/oracle/admin/zxj_data/adump'
*.background_dump_dest='/opt/oracle/admin/zxj_data/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/opt/oracle/oradata/zxj_data/control01.ctl','/opt/oracle/oradata/zxj_data/control02.ctl','/opt/oracle/oradata/zxj_data/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/zxj_data/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='zxj_data'
*.db_recovery_file_dest='/home/oracle/ora10/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=zxjdataXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=187695104
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=563085312
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/zxj_data/udump' 再查看一下controlfile的内容 $ cat initzxj_data.ora
large_pool_size=4194304
shared_pool_size=48265318
core_dump_dest='/opt/zxj_data/admin/zxj_data/cdump'
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=16
db_name='zxj_data'
db_recovery_file_dest='/home/oracle/ora10/flash_recovery_area'
db_recovery_file_dest_size=2147483648
dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
job_queue_processes=10
open_cursors=300
pga_aggregate_target=12777216
processes=150
undo_management='auto'
undo_tablespace='undotbs1'
user_dump_dest='/opt/oracle/admin/zxj_data/udump'
NLS_DATE_FORMAT="Mon DD YYYY HH24:MI:SS"
NLS_DATE_LANGUAGE=AMERICAN
是这个文件吗? 看看文件在不在啊。