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 |
ORA-01618: redo thread string is not enabled - cannot mount
ORA-30937: No schema definition for 'string' (namespace 'string') in parent 'string'
ORA-31493: could not prepare session for LogMiner session
PROC-00021: Maximum permitted depth of the OCR tree is reached
IMP-00067: Could not convert to server character set's handle
LPX-00101: parameter-entity markup cannot be split up
ORA-07718: sksafre: error freeing memory
ORA-12659: Error received from other process
EXP-00080: Data in table "string" is protected. Using conventional mode.
ORA-06536: IN bind variable bound to an OUT position
RMAN-06498: skipping datafile string; already backed up string time(s)
ORA-02459: Hashkey value must be a positive integer