ORA-27046: file size is not a multiple of logical block size

[Former Member]

Hi All,

Getting the below error while creating Control File after database restore. Permission and ownership of CONTROL.SQL file is 777 and ora<sid>:dba

ERROR -->

SQL> !pwd

/oracle/SID/sapreorg

SQL> @CONTROL.SQL

ORACLE instance started.

Total System Global Area 3539992576 bytes

Fixed Size 2088096 bytes

Variable Size 1778385760 bytes

Database Buffers 1744830464 bytes

Redo Buffers 14688256 bytes

CREATE CONTROLFILE SET DATABASE "SID" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01565: error in identifying file

'/oracle/SID/sapdata5/p11_19/p11.data19.dbf'

ORA-27046: file size is not a multiple of logical block size

Additional information: 1

Additional information: 1895833576

Additional information: 8192

Checked in target system init<SID>.ora and found the parameter db_block_size is 8192. Also checked in source system init<SID>.ora and found the parameter db_block_size is also 8192.

/oracle/SID/102_64/dbs$ grep -i block initSID.ora

Kindly look into the issue.

Regards,

Soumya

[Former Member]

Please chk the following things

1.SPfile corruption :

Startup the DB in nomount using pfile (ie init<sid>.ora) create spfile from pfile;restart the instance in nomount state

Then create the control file from the script.

2. Check Ulimit of the target server , the filesize parameter for ulimit shud be unlimited.

3. Has the db_block_size parameter been changed in init file by any chance.

Regards

Kausik

[Former Member]

Hi Kausik,

Tried Step 1. It did not work.

db_block_size parameter was not changed in initSID.ora

For step 2, let me know where to check the filesize parameter for ulimits in target server.

Regards,

Soumya

[Former Member]

Hi,

Could you go through the following SAP Note :

-

---

Note 546006 - Problems with Oracle due to operating system errors

-

---

cheers !

PRADi

[Former Member]

Issue ulimit -a for userid orasid.

U should want to see file size unlimited

If thats not the case it could be changed in u201C/etc/security/limits.confu201D file to change the limits but not sure which OS u r running ,,any confusion seek help from ur system administrator/unix admin

Regards

Kausik

[Former Member]

Hi,

My issue has got resolved

[Former Member]

Hi, What was your resolution I have a similar problem...

[markus_doehr2]

Is source and target operating system identical?

Markus