Tag Archives: ORA-00205

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

Problem: Startup database reports an error, content ORA-00205: Error in identifying control file, check Alert log for more Info

solution:

the first step: look at the journal CD $ORACLE_BASE/diag/RDBMS/zdzrac/zdzrac1/trace; Tail – 200 alert_zdzrac1. The log

note: 200 represents the display of 200 lines

CTL ‘,’/ disk2/ control01.ctl’, ‘/disk3/control03.ctl’,’/disk3/control03.ctl’ scope=spfile; Causes the control file path to change

step 3: find the path of the original control file on another normal node

SQL> select status,name from v$controlfile;

the STATUS of the NAME

——————————————————————————–

+ DATA/zdzrac controlfile/current. 256.947408805

step 4: modify the control file path in the spfilec parameter file to solve the problem

oracle# create pfile = ‘/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0714 ora’ from spfile = ‘/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/spfilezdzrac1 ora’;

oracle# vi/u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0714 ora

zdzrac2.__db_cache_size=2801795072

zdzrac1.__db_cache_size=2801795072

zdzrac2.__java_pool_size=16777216

zdzrac1.__java_pool_size=16777216

zdzrac2.__large_pool_size=33554432

zdzrac1.__large_pool_size=33554432

zdzrac1.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment

zdzrac2.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment

zdzrac2.__pga_aggregate_target=838860800

zdzrac1.__pga_aggregate_target=838860800

zdzrac2.__sga_target=3539992576

zdzrac1.__sga_target=3539992576

zdzrac2.__shared_io_pool_size=0

zdzrac1.__shared_io_pool_size=0

zdzrac2.__shared_pool_size=654311424

zdzrac1.__shared_pool_size=654311424

zdzrac2.__streams_pool_size=0

zdzrac1.__streams_pool_size=0

*.audit_file_dest=’/u01/app/oracle/admin/zdzrac/adump’

*.audit_trail=’db’

*.cluster_database=true

*. Compatible = ‘11.2.0.4.0’

*. Control_files = ‘+ DATA/zdzrac controlfile/current 256.947408805’// change control file path

*.db_block_size=8192

*.db_create_file_dest=’+DATA’

*.db_domain=”

“/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0714 ora” 44 l, 1489 c

step 5: restart the database using the pfile file

startup pfile = ‘/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0711 ora’;

step 6: create the spfile file with the modified pfile

SQL> The create spfile from pfile = ‘/ u01/app/oracle/product/11.2.0.4/dbhome_1/DBS/init0714 ora’ ‘;

step 7: close the database and start the database

SQL> shutdown immediate

SQL> startup