Sample Header Ad - 728x90

ORA-27046: file size is not a multiple of logical block size

1 vote
0 answers
1619 views
I have oracle19c container, running by docker-compose:
`
version: '3.7'
services:
  oracle:
    image: container-registry.oracle.com/database/enterprise:19.3.0.0
    container_name: oracle19c
    ports:
      - 1521:1521
    volumes:
      - oracle19c:/opt/oracle/oradata
      - /etc/localtime:/etc/localtime
    shm_size: '2gb'
networks:
  oracle19c:
    external: yes
volumes:
  oracle19c:
    external: yes
` After some tuning, like turning on archive log, now I cannot start oracle.
`
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
` Then I tried to create pfile from sfile, it shows error:
`
SQL> create pfile='/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora' from spfile='/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora';
create pfile='/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora' from spfile='/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora'
*
ERROR at line 1:
ORA-01565: error in identifying file
'/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
` This is the detail of spfile:
`
bash-4.2$ cd /opt/oracle/product/19c/dbhome_1/dbs/
bash-4.2$ ls
init.ora orapwORCLCDB  spfileORCLCDB.ora
bash-4.2$ cat spfileORCLCDB.ora
C"▒▒f▒▒CCC"["ORCLCDB.__data_transfer_cache_size=0
ORCLCDB.__db_cache_size=889192448
ORCLCDB.__inmemory_ext_roarea=0
ORCLCDB.__inmemory_ext_rwarea=0
ORCLCDB.__java_pool_size=0
ORCLCDB.__large_pool_size=67108864
ORCLCDB.__oracle_base='/opt/oracle'#ORACLE_BASE set from environment
ORCLCDB.__pga_aggregate_target=536870912
ORCLCDB.__sga_target=1610612736
ORCLCDB.__shared_io_pool_size=83886080
ORCLCDB.__shared_pool_size=520093696
ORCLCDB.__streams_pool_size=33554432
ORCLCDB.__unified_pga_pool_size=0
*.CC"v9audit_file_dest='/opt/oracle/admin/ORCLCDB/adump'
*.audit_sys_operations=false
*.audit_trail='none'
*.compatible='19.0.0'
*.control_files='/opt/oracle/oradata/ORCLCDB/control01.ctl'
*.db_block_size=8192
*.db_flashback_retention_target=1440
*.db_name='ORCLCDB'
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLCDBXDB)'
*.enable_pluggable_database=true
*.CC":)local_listener=''
*.log_archive_format='%s_%t_%r.ARC'
*.log_archive_start=TRUE
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=512m
*.processes=640
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1536m
*.undo_tablespace='UNDOTBS1'
CC"FeCC"EeCC"DeC
` Please help me how to fix this. I need to keep the data which is already mounted to volume. Thank you all.
Asked by MiH (125 rep)
May 28, 2023, 03:11 PM
Last activity: May 28, 2023, 11:33 PM