dbTalk Databases Forums  

ORA-00205: error in identifying control file

comp.databases.oracle.server comp.databases.oracle.server


Discuss ORA-00205: error in identifying control file in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
happy
 
Posts: n/a

Default ORA-00205: error in identifying control file - 05-21-2011 , 09:24 AM






SQL> startup
ORACLE instance started.

Total System Global Area 96468992 bytes
Fixed Size 1278688 bytes
Variable Size 88083744 bytes
Database Buffers 4194304 bytes
Redo Buffers 2912256 bytes
ORA-00205: error in identifying control file, check alert log for more
info

SQL> SHOW PARAMETERS control_files

NAME TYPE VALUE
----------- control_files string /opt/oracle/102/dbs/ora_contro
l1, /opt/oracle/102/dbs/ora_co
ntrol2
SQL> SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'control_files'
/
2 3 4
VALUE
/opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2

SQL>

Reply With Quote
  #2  
Old   
Michel Cadot
 
Posts: n/a

Default Re: ORA-00205: error in identifying control file - 05-21-2011 , 09:26 AM






"happy" <ehabaziz2001 (AT) gmail (DOT) com> a écrit dans le message de news:
d169f24c-ed69-4a52-85bb-e300165820d9...oglegroups.com...
Quote:
SQL> startup
ORACLE instance started.

Total System Global Area 96468992 bytes
Fixed Size 1278688 bytes
Variable Size 88083744 bytes
Database Buffers 4194304 bytes
Redo Buffers 2912256 bytes
ORA-00205: error in identifying control file, check alert log for more
info

SQL> SHOW PARAMETERS control_files

NAME TYPE VALUE
----------- control_files string /opt/oracle/102/dbs/ora_contro
l1, /opt/oracle/102/dbs/ora_co
ntrol2
SQL> SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'control_files'
/
2 3 4
VALUE
/opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2

SQL
"check alert log for more info"

Regards
Michel

Reply With Quote
  #3  
Old   
happy
 
Posts: n/a

Default Re: ORA-00205: error in identifying control file - 05-21-2011 , 09:45 AM



On May 21, 5:26*pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
Quote:
"happy" <ehabaziz2... (AT) gmail (DOT) com> a écrit dans le message de news:
d169f24c-ed69-4a52-85bb-e30016582... (AT) 32g2000vbe (DOT) googlegroups.com...
| SQL> startup
| ORACLE instance started.
|
| Total System Global Area 96468992 bytes
| Fixed Size 1278688 bytes
| Variable Size 88083744 bytes
| Database Buffers 4194304 bytes
| Redo Buffers 2912256 bytes
| ORA-00205: error in identifying control file, check alert log for more
| info
|
| SQL> SHOW PARAMETERS control_files
|
| NAME TYPE VALUE
| ----------- control_files string /opt/oracle/102/dbs/ora_contro
| l1, /opt/oracle/102/dbs/ora_co
| ntrol2
| SQL> SELECT VALUE
| FROM V$PARAMETER
| WHERE NAME = 'control_files'
| /
| 2 3 4
| VALUE
| /opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2
|
| SQL

"check alert log for more info"

Regards
Michel
Please explain more .

Reply With Quote
  #4  
Old   
Mladen Gogala
 
Posts: n/a

Default Re: ORA-00205: error in identifying control file - 05-21-2011 , 12:19 PM



On Sat, 21 May 2011 07:45:27 -0700, happy wrote:

Quote:
Please explain more .
Very simple: check alert log for more info.



--
http://mgogala.byethost5.com

Reply With Quote
  #5  
Old   
onedbguru
 
Posts: n/a

Default Re: ORA-00205: error in identifying control file - 05-21-2011 , 04:25 PM



On May 21, 10:24*am, happy <ehabaziz2... (AT) gmail (DOT) com> wrote:
Quote:
SQL> startup
ORACLE instance started.

Total System Global Area 96468992 bytes
Fixed Size 1278688 bytes
Variable Size 88083744 bytes
Database Buffers 4194304 bytes
Redo Buffers 2912256 bytes
ORA-00205: error in identifying control file, check alert log for more
info

SQL> SHOW PARAMETERS control_files

NAME TYPE VALUE
----------- control_files string /opt/oracle/102/dbs/ora_contro
l1, /opt/oracle/102/dbs/ora_co
ntrol2
SQL> SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'control_files'
/
2 3 4
VALUE
/opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2

SQL
so, do the control files exist? What did you do before you got this
error message? Restore database/controlfiles? if they exist, are
they the correct controlfiles and does they have the correct ownership/
permissions?

Reply With Quote
  #6  
Old   
Noons
 
Posts: n/a

Default Re: ORA-00205: error in identifying control file - 05-23-2011 , 01:12 AM



On May 22, 12:24*am, happy <ehabaziz2... (AT) gmail (DOT) com> wrote:
Quote:
SQL> startup
ORACLE instance started.

Total System Global Area 96468992 bytes
Fixed Size 1278688 bytes
Variable Size 88083744 bytes
Database Buffers 4194304 bytes
Redo Buffers 2912256 bytes
ORA-00205: error in identifying control file, check alert log for more
info

SQL> SHOW PARAMETERS control_files

NAME TYPE VALUE
----------- control_files string /opt/oracle/102/dbs/ora_contro
l1, /opt/oracle/102/dbs/ora_co
ntrol2
SQL> SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'control_files'
/
2 3 4
VALUE
/opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2

SQL



Do the control files exists in that location?

Reply With Quote
  #7  
Old   
Eugene Pokopac
 
Posts: n/a

Default Re: ORA-00205: error in identifying control file - 05-23-2011 , 09:32 AM



On May 21, 10:24*am, happy <ehabaziz2... (AT) gmail (DOT) com> wrote:
Quote:
SQL> startup
ORACLE instance started.

Total System Global Area 96468992 bytes
Fixed Size 1278688 bytes
Variable Size 88083744 bytes
Database Buffers 4194304 bytes
Redo Buffers 2912256 bytes
ORA-00205: error in identifying control file, check alert log for more
info

SQL> SHOW PARAMETERS control_files

NAME TYPE VALUE
----------- control_files string /opt/oracle/102/dbs/ora_contro
l1, /opt/oracle/102/dbs/ora_co
ntrol2
SQL> SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'control_files'
/
2 3 4
VALUE
/opt/oracle/102/dbs/ora_control1, /opt/oracle/102/dbs/ora_control2

SQL
ORA-00205 error in identifying controlfile, check alert log for more
info

Cause: The system could not find a control file of the specified name
and size.

Action: One of the following:

Check that the proper control file name is referenced in the
CONTROL_FILES initialization parameter in the initialization parameter
file and try again.

When using mirrored control files, that is, more than one control file
is referenced in the initialization parameter file, remove the control
file name listed in the message from the initialization parameter file
and restart the instance. If the message does not recur, remove the
problem control file from the initialization parameter file and create
another copy of the control file with a new file name in the
initialization parameter file.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.