EHP7 error in MAIN_NEWBAS/PARCONV_UPG / ORA-02220: invalid MINEXTENTS

[former_member280075]

Dear All,

I'm doing an upgrade to EHP7 in Linux/Oracle (11.2). I am currently facing an error in MAIN_NEWBAS/PARCONV_UPG phase. The error log is:

2 ED0314 ORA-02220: invalid MINEXTENTS storage option value

4 EDA093 "DDL time(___1):" ".........1" milliseconds

2EEGT236 The SQL statement was not executed

4 EGT281 sql:

4 ED0314 DROP TABLE "QCM8TXW_VWLOG2"

2 ED0314 ORA-00942: table or view does not exist

4 EDA093 "DDL time(___1):" ".........2" milliseconds

4 EGT247 .... "QCM8TXW_VWLOG2" was already removed

2EEGT207 Creation of table "TXW_VWLOG2" or primary index in DB failed

2EEGT239 Error in step "TXW_VWLOG2-STEP5"

4 EGT253XTotal time for table "TXW_VWLOG2": "000:00:00"

2EEGT094 Conversion could not be restarted

2 EGT067 Request for "TXW_VWLOG2" could not be executed

This occurs for several tables. I´ve readed notes 1570366, 1536104, 1891719 and 1904315 but error remains. Oracle parameter _FIX_CONTROL value '8937971:ON' is already active but tables are still generated with the parameter value 0 in MINEXTENTS.

Could you please advice what could be wrong here ?

Thanks!

[ashish_vikas]

As per 1570366 - ORA-02220 during transport, If you already encountered the problem you need to adjust the values for min_extents and max_extents. Depending on the columns of the table / index there are different methods to do so.

Attached to this note is shell script note1570366_v1_sh.txt which you should download to your database server (please transfer the shell script in ascii mode - not binary mode).

Have you done this ?

best regards

ashish

[Former Member]

Hi ashish. Yes, i already run the script. When running this stage tables are deleted and created again.

Thank you.

[Sriram2009]

Hi Mariano

1. Is it possible to do the full restart and than try again in the same phase.

2.  Could refer the Oracle parameters as mention in the SAP Note
1431798 - Oracle 11.2.0: Database Parameter Settings

3. What is the kernel release ? is it possible to upgrade the kernel & DBSL latest patches

BR

SS

[Former Member]

Hi! I've rebooted the system (including DB). Also note parameters checked and parameters are OK (especially the value of FIX_CONTROL). The kernel version is 721 (NO), I use LINUX ORACLE

Thanks for the reply!