Ora-00205:error in identifying control file, check alert log for more info

Source: Internet
Author: User

Boundary: Oracle10gr2 SOLARIS10
Action: The following command was executed directly without creating a 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
View Alter_test.log Files
Tue June 13:37:49 CST 2012
Starting ORACLE instance (normal)
Tue June 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_count= 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 June 13:37:52 CST 2012
ALTER DATABASE MOUNT
Tue June 13:37:52 CST 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 June 13:37:55 CST 2012
ORA-205 signalled During:alter DATABASE MOUNT ...

The reason is that the database default Init.ora is invoked because SPFile was not found when the database was started, but its default value does not match the existing database information, causing the database to fail to start.
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
Ten *.db_files=80# SMALL
One *.db_name= ' TEST '
*.dispatchers= ' (protocol=tcp) (SERVICE=ORCLXDB) '
*.global_names=true
*.log_archive_dest_1= ' Location=/oradb/oracle/arch '
*.log_archive_dest_state_2= ' DEFER '
*.log_buffer=32768# SMALL
*.log_checkpoint_interval=10000
*.max_dump_file_size= ' 10240 ' # limit trace file size to 5 Meg each
*.open_cursors=300
*.parallel_max_servers=5# SMALL
*.pga_aggregate_target=81788928
*.processes=150
*.shared_pool_size=113500000# SMALL
24
25:wq
Num 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
Variable Size 142608816 bytes
One Database buffers 8388608 bytes
Redo buffers 2097152 bytes
Database mounted.
Database opened.

Note: Do the database application Pfile start the database to be aware of whether the pfile has been generated through SPFile.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.