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 |
NNL-00561: register <name> [-t<type>] [-d<address>] [-h<hostname>] [-l<listener_name>] : register an object with Oracle Names
CLSR-00530: Can not get user name
ORA-29340: export file appears to be corrupted: [string] [string] [string]
ORA-22905: cannot access rows from a non-nested table item
ORA-01211: Oracle7 data file is not from migration to Oracle8
NNO-00265: warning: cannot load data from checkpoint file
ORA-15053: diskgroup "string" contains existing files
DRG-12218: section group name missing
ORA-16234: restarting to reset Logical Standby apply
RMAN-06607: RMAN configuration parameters are:
ORA-06029: NETASY: port assignment failure
ORA-01060: array binds or executes not allowed