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-14322: DEFAULT partition already exists
ORA-38726: Flashback database logging is not on.
ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
ORA-08321: scnmin: NOT IMPLEMENTED YET
ORA-06040: NETDNT: invalid login (connect) string
ORA-23341: user function required
ORA-24421: OCISessionRelease cannot be used to release this session.
SQL-02106: Inconsistent cursor cache. Invalid Oracle cursor number
ORA-24342: unable to destroy a mutex
ORA-28110: policy function or package string.string has error
ORA-29521: referenced name string could not be found
ORA-23301: mixed use of deferred rpc destination modes