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

Answers were Sorted based on User's Feedback



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

Answer / guest

Cause: file size as indicated by stat is not correct,
additional information indicates which function encountered
the error

Action: verify that the file has not been overwritten or
truncated

Please add more information about this Error

Is This Answer Correct ?    3 Yes 0 No

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

Answer / sarvesh chaurasia

ERROR at line 1:
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Recreate a binary SPFILE from an old init.ora, if any exists:

SQL> create spfile from pfile='initservu.ora';
File created.


Here initservu.ora
servu is a ORACLE_SID name .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32054: lost communication with FMPUTL process

1 Answers  


ORA-07718: sksafre: error freeing memory

1 Answers  


ORA-06515: PL/SQL: unhandled exception string

1 Answers  


RMAN-20218: datafile not found in recovery catalog

1 Answers  


ORA-06119: NETTCP: spurious client request

1 Answers  


ORA-00068: invalid value string for parameter string, must be between string and string

1 Answers  


ORA-31516: CDC change set string already exists

1 Answers  


LPX-00284: namespace prefix to NULL URI is not allowed

1 Answers  


PLS-00587: a static method cannot be invoked on an instance value

1 Answers  


ORA-25195: invalid option for index on an index-organized table

1 Answers  


ORA-16173: incompatible archival network connections active

1 Answers  


PCC-02345: SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used

1 Answers  


Categories