sap R3 471 system copy error

[Former Member]

Dear all:

Migration evironment:

Source system:

DEV system:SAP R/3 Enterprise 4.7x110,non-unicode, SID:DEV,database schema:SAPPRD

(because through brbackup / brrestore manner transplant from production system,then change the SID)

DB:Oracle 9.2.0.4.0 64bit

OS:AIX 5.3 64bit

Target system:

QAS system:SAP R/3 Enterprise 4.7x110,non-unicode,SID:QAS database schema:SAPQAS

DB:Oracle 10.2.0.2.0 64bit

OS:WIN2003 SP2 64bit (CPU:AMD Athlon(tm) 64X2 Dual Core Processor 5000+)

Now,in "Database instance installation"->"Oracle Post-Load Actions" phase occur errors:

sapinst.log:

************************************************************************************************************************

INFO 2009-01-06 15:15:50

Working directory changed to C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\NUC\DB.

INFO 2009-01-06 15:15:50

Working directory changed to C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\NUC\DB.

ERROR 2009-01-06 15:15:50

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL1'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL2'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'CLUST'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'POOL'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SDIC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SDOCU'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SLDEF'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SLEXC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SLOAD'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SPROT'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SSDEF'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SSEXC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SSRC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'TEMP'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQASUSR' WHERE TABART = 'USER'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQASUSR' WHERE TABART = 'USER1'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL0'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL1'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL2'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'CLUST'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'POOL'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SDIC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SDOCU'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SLDEF'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SLEXC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SLOAD'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SPROT'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SSDEF'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPA.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

***********************************************************************************************************************

ora_sql_results.log:

===============================================================================

2009-01-06, 15:15:50 SAPINST ORACLE start logging for

connect / as sysdba ;

set newpage 0

set space 0

set pagesize 0

set linesize 32767

set markup HTML off

set heading off

set verify off

set feedback off

set trimspool on

set sqlprompt SQL>

set termout on

set verify off

set echo off

spool ora_query3_tmp0_1.res

SELECT STATUS FROM V$INSTANCE;

spool off

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jan 6 15:15:50 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected.

OPEN

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SAPINST: End of output of SQL executing program D:\oracle\QAS\102/bin/sqlplus.

2009-01-06, 15:15:50 SAPINST ORACLE stop logging

==============================================================

2009-01-06, 15:15:50 SAPINST ORACLE start logging for

connect / as sysdba ;

@@ddicora.sql

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jan 6 15:15:50 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected.

Connected.

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL0'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL1'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL2'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'CLUST'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'POOL'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SDIC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SDOCU'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SLDEF'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SLEXC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SLOAD'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SPROT'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SSDEF'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SSEXC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SSRC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'TEMP'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQASUSR' WHERE TABART = 'USER'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.taora SET TABSPACE = 'PSAPQASUSR' WHERE TABART = 'USER1'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL0'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL1'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'APPL2'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'CLUST'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'POOL'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SDIC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SDOCU'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SLDEF'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SLEXC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SLOAD'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SPROT'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SSDEF'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS620' WHERE TABART = 'SSEXC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'SSRC'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQAS' WHERE TABART = 'TEMP'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQASUSR' WHERE TABART = 'USER'

*

ERROR at line 1:

ORA-00942: table or view does not exist

UPDATE SAPQAS.iaora SET TABSPACE = 'PSAPQASUSR' WHERE TABART = 'USER1'

*

ERROR at line 1:

ORA-00942: table or view does not exist

DELETE FROM SAPQAS.tsora

*

ERROR at line 1:

ORA-00942: table or view does not exist

INSERT INTO SAPQAS.tsora (TABSPACE, INDSPACE) VALUES ('PSAPQAS', 'PSAPQAS')

*

ERROR at line 1:

ORA-00942: table or view does not exist

INSERT INTO SAPQAS.tsora (TABSPACE, INDSPACE) VALUES ('PSAPQAS620', 'PSAPQAS620')

*

ERROR at line 1:

ORA-00942: table or view does not exist

INSERT INTO SAPQAS.tsora (TABSPACE, INDSPACE) VALUES ('PSAPQASUSR', 'PSAPQASUSR')

*

ERROR at line 1:

ORA-00942: table or view does not exist

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SAPINST: End of output of SQL executing program D:\oracle\QAS\102/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2009-01-06, 15:15:50 SAPINST ORACLE stop logging

***********************************************************************************************************************

Please give me help and suggestion, Thanks!!

[markus_doehr2 · Accepted solution]

Was the table "taora" created?

start a cmd.exe
cd C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\NUC\DB
find /N /I "taora" *.TSK

Markus

[Former Member · Accepted solution]

Dear Markus Doehr :

The above error has been resolved from what I used to 640_64bit_EX2, re-installed, but now it prompt

"The Migration Key for hoterogene systemcopy is wrong" in the "Database Load" phase.The Migration key was appied for SAP net.

The MIGKEY.LOG show below error info:

**********************************************************************************************************************

D:\usr\sap\QAS\SYS\exe\run/R3load.exe: START OF LOG: 20090114161506

D:\usr\sap\QAS\SYS\exe\run/R3load.exe: sccsid @(#)

$Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP

D:\usr\sap\QAS\SYS\exe\run/R3load.exe: version R6.40/V1.4

Compiled Aug 17 2008 23:18:48

D:\usr\sap\QAS\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program

Files\sapinst_instdir\R3E47X2

\COPY\IMPORT\SYSTEM\ABAP\ORA\NUC\DB/SAPAPPL0.cmd -l MIGKEY.log -K

1gUgeUM50TH01eqtd1]y3Qq1

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(CNV) ERROR: rscpMCInit rc = 2048

-

---

3-

code: 2048 RSCPENOCONV

convert MDMP to Unicode during export only

module: rscpexmh location: 4 line: 424

TSL01: CQI p3: MDMP&->&1100&during export only&&

-

---

.

D:\usr\sap\QAS\SYS\exe\run/R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\run/R3load.exe: END OF LOG: 20090114161506

*********************************************************************************************************************

I have 3 queries about request migration key via SAP NET:

Query1:

In Operating system, AIX 5.3 is no alternative.

Query2:

In Database,Oracle 9.2.0.4 is no alternative.

Query3:

In Operating system, NT/AMD CPU is no alternative,it only provide NT/INTEL WIN2003 alternative , because the target OSu2019s CPU is AMDX64 type.

Above mention will affect generate's Migration KEY whether correct?

[markus_doehr2 · Accepted solution]

It seems that you migration key is wrong - did you generate that on the SMP?

Markus

[Former Member · Accepted solution]

YES!!!

I have generated that on the SAP NET.

https://websmp202.sap-ag.de/migrationkey -> request migration key

But i have 3 queries about request migration key via SAP NET:

Query1:

In Operating system, AIX 5.3 is no alternative.

Query2:

In Database,Oracle 9.2.0.4 is no alternative.

Query3:

In Operating system, NT/AMD CPU is no alternative,it only provide

NT/INTEL WIN2003 alternative , because the target OSu2019s CPU is AMDX64

type.

Above mention will affect generate's Migration KEY whether correct?

[markus_doehr2 · Accepted solution]

> But i have 3 queries about request migration key via SAP NET:

> Query1:

> In Operating system, AIX 5.3 is no alternative.

Simply use AIX (without a version)

> Query2:

> In Database,Oracle 9.2.0.4 is no alternative.

Simply use "Oracle"

> Query3:

> In Operating system, NT/AMD CPU is no alternative,it only provide

> NT/INTEL WIN2003 alternative , because the target OSu2019s CPU is AMDX64

> type.

Both INTEL and AMD processors can run as 64bit, they are equal, just different manufactures.

Use NT/INTEL Windows 2003

Markus

[Former Member · Accepted solution]

HI.Markus:

I have already tried to generation the Migration Key as your mention,but it also occur the same error"The Migration Key for hoterogene systemcopy is wrong",can't pass in the phase.

Operating system:AIX (without a version)

Database,Oracle (without a version)

Target Operating system: NT/INTEL WIN2003

[markus_doehr2 · Accepted solution]

Is this an MDMP system (more than one codepage)?

Markus

[Former Member · Accepted solution]

HI Markus:

1>Source system is :Latin-1 or MDMP codepage, non-unicode

2>Target system is: should be Latin-1 or MDMP codepage,non-unicode

3>1100 the codepage used in the export

4>1100 the codepage used in the import

[markus_doehr2 · Accepted solution]

1>Source system is :Latin-1 or MDMP codepage, non-unicode

2>Target system is: should be Latin-1 or MDMP codepage,non-unicode

3>1100 the codepage used in the export

4>1100 the codepage used in the import

???

you have to decide whether it´s a single codepage system or not.

If you have more than one codepage you need to enter "MDMP" in the export codepage field and the same during the import.

Markus

[Former Member · Accepted solution]

HI Markus:

In the source system's RSCPINST:current NLS Settings show:

• C o n f i g u r a t i o n T y p e :

Non-Unicode System

Non-Unicode - MDMP configuration

Attention!

The required language combination is supported without restrictions

only in Unicode systems.

Please refer to SAP Note 73606.

C o d e p a g e s :

1100 Code Page of Application Server

1160 Code Page of SAP GUI

D a t a b a s e t a b l e e n t r i e s :

TCP0C: Code pages and locale names

OK Checked and no inconsistency found.

TCP0F: Frontend code pages

OK Checked and no inconsistency found.

TCPDB: Database code pages

1100 SAP internal, like ISO 8859-1 (00697/00819)

8400 Simplified Chinese (based on GB2312-EUC, MS CP936)

TCP0D: Country code

(3 spaces) Latin-1 or MDMP

TCP0I: Processed language(s) entry

ACTIVE 1DE

L o c a l e c h e c k :

Locale: Required OS locales and their current status

Locale installed = the locale is installed correctly

Set locale failed = the locale needs to be corrected on the app server

clidev_DEV_00 de_DE.ISO8859-1 Locale installed

en_US.ISO8859-1 Locale installed

zh_CN Locale installed

P r o f i l e p a r a m e t e r s :

zcsa/installed_languages (value sorted):

clidev_DEV_00 1DE

Required profile parameter modifications:

OK Checked and no inconsistency found.

[markus_doehr2 · Accepted solution]

> TCPDB: Database code pages

> 1100 SAP internal, like ISO 8859-1 (00697/00819)

> 8400 Simplified Chinese (based on GB2312-EUC, MS CP936)

>

> TCP0D: Country code

> (3 spaces) Latin-1 or MDMP

>

So you are using an MDMP system.

If you copy that, you need to enter "MDMP" during export and import in the codepage field, otherwise you will destroy data.

This field is usually numeric only, you will need to follow the workaround in

Note 970518 - Hom./Het.System Copy SAP NetWeaver 7.0 (2004s) SR2

section "System copy of MDMP systems:".

That note is newer than your release but still valid.

Markus

[Former Member]

Dear Markus:

Thank you for your help!

This issue have already solved!

Thank you very much!!

BEN

[markus_doehr2]

you´re welcome

Please mark this as "answered" if the question is answered.

Markus

[Former Member]

How did you resolve this? can you please let me know the solution idea?

Thanks,

Kamal

[markus_doehr2]

> How did you resolve this? can you please let me know the solution idea?

Read the note mentioned and follow the suggestions in the section I mentioned.

Markus