ORA-00205: errorinidentifyingcontrolfile, checkalertlo-mysql tutorial

The article according to your own encountered on the ORA-00205: errorinidentifyingcontrolfile, checkalertlogformoreinfo error analysis of students in need can refer to it.

The article according to your own encountered on the ORA-00205: error in identifying control file, check alert log for more info error analysis in need of students can refer.

The article according to your own encountered on the ORA-00205: error in identifying control file, check alert log for more info error analysis in need of students can refer.

Environment: oracle10gR2 solaris10
Operation: if pfile is not created, the following command is directly executed:
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
View the alter_TEST.log file
Tue Jul 03 13:37:49 CST 2012
Starting ORACLE instance (normal)
Tue Jul 03 13:37:49 CST 2012
System parameter db_block_buffers enabled without VLM on.
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as/oradb/oracle/102/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Ksdpec: called for event 13740 prior to event group initialization
Starting 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 _ = 8
Global_names = TRUE
Parallel_max_servers = 5
Max_dump_file_size = 10240
Db_name = TEST
PMON started with pid = 2, OS id = 1406
PSP0 started with pid = 3, OS id = 1408
MMAN started with pid = 4, OS id = 1410
DBW0 started with pid = 5, OS id = 1412
LGWR started with pid = 6, OS id = 1414
CKPT started with pid = 7, OS id = 1416
SMON started with pid = 8, OS id = 1418
RECO started with pid = 9, OS id = 1420
MMON started with pid = 10, OS id = 1422
MMNL started with pid = 11, OS id = 1424
Tue Jul 03 13:37:52 CST 2012
ALTER DATABASE MOUNT
Tue Jul 03 13:37:52 CST 2012 ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oradb/oracle/102/dbs/control1'
ORA-27037: unable to obtain file status
Solaris-AMD64 Error: 2: No such file or directory
Additional information: 3
Tue Jul 03 13:37:55 CST 2012
ORA-205 signalled during: alter database mount...

The reason is that the default init. ora of the database is called if spfile is not found at startup, but its default value does not match the existing database information, resulting in the database cannot be started.
Solution:

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 = 'delete'
16 *. log_buffer = 32768 # SMALL
17 *. log_checkpoint_interval = 10000
18 *. max_dump_file_size = '000000' # limit trace file size to 5 Meg each
19 *. open_cursors = 300
20 *. parallel_max_servers = 5 # SMALL
21 *. pga_aggregate_target = 81788928
22 *. processses = 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.

Note: When pfile is used to start the database, make sure that pfile has been generated through spfile.