My Oracle Support Banner

ORA-01503 And (ORA-01160 ORA-01110) Or (ORA-01565 ORA-27406) (Doc ID 1077033.6)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

You are attempting to recreate the controlfiles for an existing database and during creation you see the following errors:

    Case 1:

    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file '/u02/oradata/RM805/system01.dbf'
    ORA-27046: file size is not a multiple of logical block size

- or -

    Case 2:

    ORA-01503: CREATE CONTROLFILE failed
    ORA-01160: file is not a data file
    ORA-01110: data file : '/u02/oradata/RM805/system01.dbf'

- or -

    Case 3:

    ORA-00058: DB_BLOCK_SIZE must be <the correct block size> to mount this database (not <the incorrect block size>)

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.