Unable to reading Control file

[Former Member]

Dear All,

I have moved OriglogA and B from F-Drive to C-Drive, then i made settings in init<SID>.ora file as per change done, now i am trying starting database, it is giving error message ORA-00205:error oin identifying congrol file, check alert log for more info,

alertlog file having following entries.

ORA-00202:control file : 'C:\ORACLE\<SID>\ORIGLOGB\CNTRL\CNTRL<SID>.DBF'

ORA-27041:unable to open file

OSD-04002:unable to open file

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

Please help me, to up the database

Regards

Chandra

[Former Member]

Are you see this file are under this directory? If yes then you need to check permissions for this file (or direct on C:\ORACLE\<SID>\ORIGLOGB\CNTRL folder, are the SapserviceSID (or ora_dba) can read and write in folder ?

Regards.

[Former Member]

Hi Sergo,

Thanks for prompt reply, it is having ORA_DBA read/write permisions even though not getting started database.

[Former Member]

Can you post your init<SID>.ora and direct path (from browser) there you put your control file.

P.S. SYSTEM can read this files to ?

Regards.

[Former Member]

Here i am pasting init<SID>.ora file

########################################################################

1. This init.ora profile is a transparent copy of Oracle spfile. #

2. It was created by BRSPACE at 2009-03-28 09.46.04. #

3. Please do not change this file! Maintain only the spfile. #

4. You can use BRSPACE for the altering of database parameters: #

5. brspace -f dbparam #

########################################################################

*._OPTIM_PEEK_USER_BINDS=FALSE

*.background_dump_dest='E:\oracle\NWS\saptrace\background'

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='C:\oracle\NWS\origlogA\cntrl\cntlrNWS.dbf','C:\oracle\NWS\origlogB\cntrl\cntrlNWS.dbf','E:\oracle\NWS\sapdata1\cntrl\cntrlNWS.dbf'

*.core_dump_dest='E:\oracle\NWS\saptrace\background'

*.db_block_size=8192

*.db_cache_size=644245094

*.db_files=254

*.db_name='NWS'

*.dml_locks=4000

*.event='10191 trace name context forever, level 1'

*.FILESYSTEMIO_OPTIONS='setall'

*.job_queue_processes=1

*.log_archive_dest='E:\oracle\NWS\oraarch\NWSarch'

*.log_buffer=1048576

*.log_checkpoint_interval=0

*.log_checkpoints_to_alert=true

*.open_cursors=800

*.optimizer_features_enable='10.2.0.1'

*.pga_aggregate_target=629145600

*.processes=80

*.recyclebin='off'

*.remote_login_passwordfile='exclusive'

*.remote_os_authent=true

*.sessions=96

*.sga_max_size=1288490188

*.shared_pool_reserved_size=64424509

*.shared_pool_size=544245094

*.sort_area_retained_size=0

*.sort_area_size=2097152

*.statistics_level='typical'

*.undo_management='AUTO'

*.undo_retention=43200

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='E:\oracle\NWS\saptrace\usertrace'

*.workarea_size_policy='AUTO'

[Former Member]

In origlogA you have file cntlrNWS.dbf and in origlogB cntrlNWS.dbf are the same file on OS level ?

Check lr and rl more clearly.

Regards.

[Former Member]

You are correct, Thank you its working fine.