ORA-27046: file size is not a multiple of logical block size
Answers were Sorted based on User's Feedback
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 |
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 |
PLS-00245: Formals used in the 'parameters' clause must appear exactly once
NNF-01005: Internal XOM class violation
ORA-19653: cannot switch to older file incarnation
ORA-22346: Type has cyclical dependency. Should use CASCADE option
ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction
ORA-39107: Master process string violated startup protocol. Master error:
RMAN-05012: trying to start the Oracle instance without parameter files ...
QSM-02061: one or more joins present in mv
ORA-31508: invalid parameter value for synchronous change set
QSM-02034: no joins are present in the HAVING clause
ORA-10579: Can not modify control file during test recovery
IMG-00846: adjacency matrix allocation failed