Oracle DB error

[Former Member]

Dear all,

I have tried to start Db but its giving error , pls check below

Note: Newly installed SAPserver ,no to upgrade 10.2.0.1 to 10.2.0.4.

SQL> startup

ORACLE instance started.

Total System Global Area 348127232 bytes

Fixed Size 1248936 bytes

Variable Size 184549720 bytes

Database Buffers 159383552 bytes

Redo Buffers 2945024 bytes

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

Pls check the Alert log (last few lines)

Fri Nov 26 11:52:38 2010

ORA-205 signalled during: ALTER DATABASE MOUNT...

Fri Nov 26 12:11:01 2010

Starting ORACLE instance (normal)

Fri Nov 26 12:11:16 2010

Shutting down instance: further logons disabled

Fri Nov 26 12:11:16 2010

Stopping background process CJQ0

Fri Nov 26 12:11:17 2010

Stopping background process MMNL

Fri Nov 26 12:11:19 2010

Stopping background process MMON

Fri Nov 26 12:11:19 2010

Shutting down instance (immediate)

License high water mark = 1

Fri Nov 26 12:11:19 2010

Stopping Job queue slave processes

Fri Nov 26 12:11:19 2010

Job queue slave processes stopped

Fri Nov 26 12:11:19 2010

ALTER DATABASE CLOSE NORMAL

ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Fri Nov 26 12:11:30 2010

Starting ORACLE instance (normal)

Fri Nov 26 12:11:30 2010

Specified value of sga_max_size is too small, bumping to 348127232

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Autotune of undo retention is turned on.

IMODE=BR

ILAT =10

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.1.0.

System parameters with non-default values:

processes = 80

sessions = 96

event = 10191 trace name context forever, level 1

sga_max_size = 348127232

shared_pool_size = 159383552

shared_pool_reserved_size= 15823011

filesystemio_options = setall

control_files = F:\ORACLE\ISO\ORIGLOGA\CNTRL\CNTLRISO.DBF, F:\ORACLE\ISO\ORIGLOGB\CNTRL\CNTRLISO.DBF, D:\ORACLE\ISO\SAPDATA1\CNTRL\CNTRLISO.DBF

control_file_record_keep_time= 30

db_block_size = 8192

db_cache_size = 159383552

compatible = 10.2.0

log_archive_dest = D:\oracle\ISO\oraarch\ISOarch

log_buffer = 2898944

log_checkpoint_interval = 0

db_files = 254

log_checkpoints_to_alert = TRUE

dml_locks = 4000

undo_management = AUTO

undo_tablespace = PSAPUNDO

undo_retention = 43200

recyclebin = off

remote_os_authent = TRUE

remote_login_passwordfile= EXCLUSIVE

job_queue_processes = 1

background_dump_dest = D:\ORACLE\ISO\SAPTRACE\BACKGROUND

user_dump_dest = D:\ORACLE\ISO\SAPTRACE\USERTRACE

core_dump_dest = D:\ORACLE\ISO\SAPTRACE\BACKGROUND

optimizer_features_enable= 10.2.0.1

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = ISO

open_cursors = 800

optimpeek_user_binds = FALSE

pga_aggregate_target = 210973491

workarea_size_policy = AUTO

statistics_level = typical

PMON started with pid=2, OS id=1256

PSP0 started with pid=3, OS id=2128

MMAN started with pid=4, OS id=2768

DBW0 started with pid=5, OS id=2760

LGWR started with pid=6, OS id=3976

CKPT started with pid=7, OS id=2508

SMON started with pid=8, OS id=3108

RECO started with pid=9, OS id=2512

CJQ0 started with pid=10, OS id=3992

MMON started with pid=11, OS id=3980

MMNL started with pid=12, OS id=2920

Fri Nov 26 12:11:30 2010

ALTER DATABASE MOUNT

Fri Nov 26 12:11:30 2010

ORA-00202: control file: 'F:\ORACLE\ISO\ORIGLOGA\CNTRL\CNTLRISO.DBF'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 3) The system cannot find the path specified.

Fri Nov 26 12:11:30 2010

ORA-205 signalled during: ALTER DATABASE MOUNT...

Edited by: satheesh0812 on Nov 26, 2010 7:53 AM

[former_member524429 · Accepted solution]

Hi,

Check that F: drive is accessible or not. Is it mounted in your system ? If its not accessible or mounted then correct it first.

If its accessible then ,

Directories are located there ?

If all control files are accessible there, then

1. First take safe backup of all the available control files as mentioned at those location

2. compare the Size of all the control files... it should be same...

3. Suppose, if only one file among those 3 control files is looking doubtful. then replace it with the one of those 2 files which are having same size...

Regards,

Bhavik G. Shroff

[Former Member]

Do you have a copy of controlfile at all these 3 places?

control_files = F:\ORACLE\ISO\ORIGLOGA\CNTRL\CNTLRISO.DBF, F:\ORACLE\ISO\ORIGLOGB\CNTRL\CNTRLISO.DBF, D:\ORACLE\ISO\SAPDATA1\CNTRL\CNTRLISO.DBF

If not, just copy the controlfile from one of the source to these 3 places and restart.

Regards,

Nick Loy