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

PLS-00245: Formals used in the 'parameters' clause must appear exactly once

1 Answers  


NNF-01005: Internal XOM class violation

1 Answers  


ORA-19653: cannot switch to older file incarnation

1 Answers  


ORA-22346: Type has cyclical dependency. Should use CASCADE option

1 Answers  


ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction

1 Answers  


ORA-39107: Master process string violated startup protocol. Master error:

1 Answers  


RMAN-05012: trying to start the Oracle instance without parameter files ...

1 Answers  


QSM-02061: one or more joins present in mv

1 Answers  


ORA-31508: invalid parameter value for synchronous change set

1 Answers  


QSM-02034: no joins are present in the HAVING clause

1 Answers  


ORA-10579: Can not modify control file during test recovery

1 Answers  


IMG-00846: adjacency matrix allocation failed

1 Answers  


Categories