System Copy import issue

[Former Member]

Hi,

While doing import of  BW by System Copy Method its getting failed because its unable to extent tablespace in Import ABAP phase.

Below is error detail :-

RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable

for some databases

(DB) INFO: /BIC/B0000423000 deleted/truncated #20160202104738

DbSl Trace: Error 1688 in stmt_execute() from oci_execute_stmt(),

orpc=166

DbSl Trace: ORA-01688 occurred at SQL stmt (parse error offset=0)

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "/BIC/B0000423000"

(SQL error 1688)

error message returned by DbSl:

ORA-01688: unable to extend table SAPSR3./BIC/B0000423000 partition

/BIC/B00004230000000001085 by 1024 in tablespace

PSAPSR3

(DB) INFO: disconnected from DB

/usr/sap/DBP/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/DBP/SYS/exe/run/R3load: END OF LOG: 20160202181534

Reply from SAP to extent table space

alter database datafile 4 autoextend on maxsize 32G;

alter database datafile 4 autoextend on maxsize 32G;

But also increasing many times its stucking in same error.

As of now import has been stucked in Import Abap phase.

Why its giving space issue as already there is enough space in file system , why its not not extending?

Pls suggest...

Regards

Adil

[Sriram2009]

Hi Adil.

1. On Source and target kernel release and level are same ?

2. Refer the SAP Note error message "ORA-01688: unable to extend table "

3155 - Termination due to tablespace overflow

Regards

SS

[Former Member]

Hi Sriram,

Source system : NW7.0 Ehp1 , Kernel version is 701_rel with patch level and database is 10.2.0.2

target system : NW7.0 Ehp1 Kernel version is 721_REl with patch level 402 and database is 12c

We are migrating system by system copy (database export import method)

We are using SWPM in target system which supports 721_REl.

We have skipped database statistic in source system.Is this can be issue root cause?

Or do we need to upgrade source system kernel before taking export?

Kindly suggest.

Regards

Adil

[Sriram2009]

Hi Adil.

Could you share the full log as attachment?

BR

SS

[manish_singh13]

Hi Adil,

Not sure if your methodology will work (Upgrading Oracle with System Copy).

Secondly as per SAP Note 1915315 and Oracle Upgrade guide, you can upgrade Oracle from 10.2.0.5 to Oracle 12c while your version is 10.2.0.2.

Also you need 721_EXT kernel for Oracle 12c.

Please check this SAP Note and guide again.

Thanks,

MPS