ORA-00205: error in identifying control file, check alert log for more info
环境：oracle10gR2 solaris10
操作：在没有创建pfile的情况下，直接执行了以下命令
1 SQL
>create pfile
from spfile;
2 SQL
>shutdown immediate
3 SQL
>startup
4 ORA
-00205: error
in identifying control
file,
check alert
log for more info
查看alter_TEST.log文件
Tue Jul 03 13:37:49 CST 2012Starting ORACLE instance (normal)Tue Jul 03 13:37:49 CST 2012System parameter db_block_buffers enabled without VLM on.LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 3Using LOG_ARCHIVE_DEST_1 parameter default value as /oradb/oracle/102/dbs/archAutotune of undo retention is turned off. LICENSE_MAX_USERS = 0SYS auditing is disabledksdpec: called for event 13740 prior to event group initializationStarting up ORACLE RDBMS Version: 10.2.0.5.0.System parameters with non-default values: processes = 50 shared_pool_size = 117440512 control_files = /oradb/oracle/102/dbs/control1, /oradb/oracle/102/dbs/control2 db_block_buffers = 1024 log_buffer = 2032640 log_checkpoint_interval = 10000 db_files = 80 db_file_multiblock_read_count= 8 global_names = TRUE parallel_max_servers = 5 max_dump_file_size = 10240 db_name = TESTPMON started with pid=2, OS id=1406PSP0 started with pid=3, OS id=1408MMAN started with pid=4, OS id=1410DBW0 started with pid=5, OS id=1412LGWR started with pid=6, OS id=1414CKPT started with pid=7, OS id=1416SMON started with pid=8, OS id=1418RECO started with pid=9, OS id=1420MMON started with pid=10, OS id=1422MMNL started with pid=11, OS id=1424Tue Jul 03 13:37:52 CST 2012ALTER DATABASE MOUNTTue Jul 03 13:37:52 CST 2012 ORA-00210: cannot open the specified control fileORA-00202: control file: '/oradb/oracle/102/dbs/control1'ORA-27037: unable to obtain file statusSolaris-AMD64 Error: 2: No such file or directoryAdditional information: 3Tue Jul 03 13:37:55 CST 2012ORA-205 signalled during: ALTER DATABASE MOUNT...
原因是因为启动数据库时未找到spfile则调用了数据库默认的init.ora，但是其默认值与现有数据库信息不匹配导致数据库不能启动。
解决方案：
1 bash
#vi /oradb/oracle/102/dbs/initTEST.ora
2 *.audit_file_dest='/oradb/oracle/admin/TEST/
adump'
3 *.background_dump_dest='/oradb/oracle/admin/TEST/
bdump'
4 *.compatible='10.2.0.5.0
'
5 *.control_files='/oradb/oracle/oradata/TEST/control01.ctl','/oradb/oracle/oradata/TEST/control02.ctl','/oradb/oracle/oradata/TEST/
control03.ctl'
6 *.core_dump_dest='/oradb/oracle/admin/TEST/
cdump'
7 *.db_block_buffers=100
# SMALL
8 *.db_block_size=8192
9 *.db_file_multiblock_read_count=16
10 *.db_files=80
# SMALL
11 *.db_name=
'TEST'
12 *.dispatchers='(PROTOCOL=TCP) (SERVICE=
orclXDB)'
13 *.global_names=
TRUE
14 *.log_archive_dest_1='location=/oradb/oracle/
arch'
15 *.log_archive_dest_state_2=
'DEFER'
16 *.log_buffer=32768
# SMALL
17 *.log_checkpoint_interval=10000
18 *.max_dump_file_size='10240'
# limit trace file size to 5 Meg each
19 *.open_cursors=300
20 *.parallel_max_servers=5
# SMALL
21 *.pga_aggregate_target=81788928
22 *.processes=150
23 *.shared_pool_size=113500000
# SMALL
24
25 :wq
26 bash
#sqlplus / as sysdba
1 SQL
> create spfile
from pfile;
2
3 File created.
4
5 SQL
> startup
6 ORACLE instance started.
7
8 Total System Global Area
155189248 bytes
9 Fixed Size
2094672 bytes
10 Variable Size
142608816 bytes
11 Database Buffers
8388608 bytes
12 Redo Buffers
2097152 bytes
13 Database mounted.
14 Database opened.
注：再做数据库应用pfile启动数据库时要注意是否已经通过spfile生成pfile。
posted on
2012-07-03 14:10
蓝红石 阅读(
...) 评论(
)
编辑
收藏
转载于:https://www.cnblogs.com/liuweihua/archive/2012/07/03/2574668.html
