oracle ora-48108,ORA-48108: invalid value given for the diagnostic_dest init.ora parameter — oracle-...

sunil907 wrote:

Hi,

I have provided diagnostic_dest folder location (physical path). Now i am getting some different kind of error on startup.

SQL> startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size                  2182592 bytes

Variable Size             616563264 bytes

Database Buffers          444596224 bytes

Redo Buffers                5595136 bytes

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

Please help

What does your own research of 'ORA-00205' indicate?

the text of the error message is pretty self explanatory .. it couldn't find the control file.

The control files are specified by the "control_files"  initialilzation paramter.  When you get this error, the instance has started but was unable to mount the control file.  since the init file (spfile) was processed and the instance started you can easily see what it thinks are the control files.

oracle:fubar$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 16 12:51:37 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  835104768 bytes

Fixed Size                  2217952 bytes

Variable Size             490735648 bytes

Database Buffers          339738624 bytes

Redo Buffers                2412544 bytes

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

SQL> show parameter control

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time        integer     7

control_files                        string      /u01/app/oracle/oradata/FUBAR/

controlfile/o1_mf_8ybx4t7w_.ct

x, /u01/app/oracle/flash_recov

ery_area/FUBAR/controlfile/o1_

mf_8ybx4tom_.ctl

control_management_pack_access       string      NONE

SQL>

So what did you do in fixing your original problem that caused your control_files parameter to go south?