ORA-27046 是一个 Oracle 数据库错误代码,表示“文件大小不是逻辑块大小的倍数”。这通常发生在 Oracle 试图读取或写入一个文件时,但文件的实际大小与 Oracle 预期的基于逻辑块大小的对齐方式不匹配。 2. 可能导致 ORA-27046 错误的原因 文件损坏:最常见的原因是文件(如 SPFILE 或 Data Pump 导出文件)已被损坏...
ora-27046处理(重建spfile) 数据库无法连接,提示ora-27046错误。 原因:spfile损坏(spfile是系统二进制文件不可以修改) 解决方法: 可以用下面方法恢复过来: sqlplus /nolog connect/ as sysdba create spfile='D:\oracle\product\10.2.0\db_1\dbs\SPFILEDATAEXCH.ORA' from pfile='D:\oracle\product\10.2.0\admi...
IMPDPORA-27046,dump文件损坏 客户提出导入报错 一、报错如下 SYMPTOMS DataPump Import (IMPDP) fails with the following errors: ORA-39002: invalid operation ORA-31694: master table"<master table name>"failed to load/unload ORA-31640: unable to open dump file"<dump file name>"forread ORA-19505: ...
Errors in file <PATH>/<SID>_ora_13955.trc: The trace file reports:ORA-27046: file size is not a multiple of logical block sizeAdditional information: 1No information available on the default traces indicating which file was causing ORA-27046 error....
ORA-27046错误码解决方法 背景 当前数据库undo表空间使用undotbs1,数据文件大小已大26G,严重占用系统分区空间。为了解决这个问题,重新创建另外一个undo表空间,并使数据库在使用新的undo表空间启动。在使用新的undo表空间前,创建pfile文件,结果就出现了本文描述的问题。
LRM-00109: could not open parameter file '/rdcrmap/oracrm/rdcrm/10.2.0/dbs/initrdcrm.ora' 试着用SPFILE 创建PFILE SQL> create pfile from spfile; create pfile from spfile * ERROR at line 1: ORA-27046: file size is not a multiple of logical block size ...
ORA-01110: data file 13: '/oradata/ora04/DBDEV01/DBDEV01_DATA_T02a.dbf' ORA-27046: file size is not a multiple of logical block size Additional information: 1 ORA-1157 signalled during: ALTER DATABASE OPEN... During Startup:
ORA-27046: file size is not a multiple of logical block size Additional information: 1 Additional information: 1895833576 Additional information: 8192 Checked in target system init<SID>.ora and found the parameter db_block_size is 8192. Also checked in source system init<SID>.ora and found th...
***ORA-27046: file size is not a multiple of logical block size Former Member on 2009 Jan 06 0 Kudos 2,932 SAP Managed Tags: Oracle Database, SAP NetWeaver Hi, I could not be take a backup through brtools, its giving me a below message... Kindly give me solution to ...
LRM-00109: could not open parameter file '/rdcrmap/oracrm/rdcrm/10.2.0/dbs/initrdcrm.ora' 试着用SPFILE 创建PFILE SQL> create pfile from spfile; create pfile from spfile * ERROR at line 1: ORA-27046: file size is not a multiple of logical block size ...