Wednesday, January 20, 2010

Oracle 11.1.0.7.2 DB cannot write to 11.1.0.7.1 ASM.

In the case below 11.1.0.7.2 DB could not write to 11.1.0.7.1 ASM.

If you see any of the following errors, check to confirm if DB ORACLE_HOME is at exactly the same patch level as ASM ORACLE_HOME.

SQL> create tablespace asm_test;
create tablespace asm_test
*
ERROR at line 1:
ORA-19510: failed to set size of 12800 blocks for file
"+ASM_ORADATA41/t01dwh/datafile/asm_test.2558.708719699" (block size=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 12800 blocks
ORA-15061: ASM operation not supported [41]


SQL> create spfile='+ASM_ORADATA41/t01dwh/spfilet01dwh.ora_1263913779030' FROM pfile='/opt/oracle/product/11.1.0/db_1/dbs/inittl01dwh1.ora';
create spfile='+ASM_ORADATA41/t01dwh/spfilet01dwh.ora_1263913779030' FROM pfile='/opt/oracle/product/11.1.0/db_1/dbs/inittl01dwh1.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
ORA-17505: ksfdrsz:1 Failed to resize file to size 5 blocks
ORA-15061: ASM operation not supported [41]


SQL> startup upgrade;
ORACLE instance started.

Total System Global Area 4292558848 bytes
Fixed Size 2160600 bytes
Variable Size 1593837608 bytes
Database Buffers 2684354560 bytes
Redo Buffers 12206080 bytes
ORA-00600: internal error code, arguments: [kccgtt_1], [3], [], [], [], [], [], [], [], [], [], []


ORA-00202: control file: '+ASM_ORADATA42/control02.ctl'
ORA-17505: ksfdrsz:1 Failed to resize file to size 2114 blocks
ORA-15061: ASM operation not supported [41]
Control file not expanded from 1982 to 2114 blocks for upgrade:denied by OS
Errors in file /opt/oracle/diag/rdbms/t01dwh/tl01dwh1/trace/tl01dwh1_ora_119470.trc (incident=18204):
ORA-00600: internal error code, arguments: [kccgtt_1], [3], [], [], [], [], [], [], [], [], [], []