Unicode convertion source=target

[ganimede_dignan]

Hi,

I'm tring a Unicode convertion on a send-box system just copied from production system. I'm in export phase now in our Solaris 10 SPARC + Oracle 10.2.04 box

For the import I must use the same server, same <SID> name and system number... is it necessary to unistall previus ASCII istance and then re-install in Unicode? ... ora can I switch only the kernel from ASCII 2 Unicode? ... how?

Regards.

Ganimede Dignan.

[Former Member]

Are you refering to Unicode conversion guide? You can download from SMP.

This link may give you some more ideas about conversion. [http://www.sdn.sap.com/irj/scn/events?rid=/library/uuid/efd1dd90-0201-0010-e1b0-8437c998cd79&overridelayout=true]

[ganimede_dignan]

First error in export....

ERROR: 2009-10-06 22:23:46 com.sap.inst.migmon.LoadTask run

Unloading of 'SAPAPPL0_7' export package is interrupted with R3load error.

Process '/usr/sap/SID/SYS/exe/run/R3load -e SAPAPPL0_7.cmd -datacodepage 4102 -l SAPAPPL0_7.log -stop_on_error' exited with return code 2.

For mode details see 'SAPAPPL0_7.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

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

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(EXP) TABLE: "CUKBT" #20091006222346

rscpGetUmgContainerDLine,3568, l_result = 16

received return code 16 from rscpCopyContainerInfos for transparent table CUKN.(CNV) ERROR: data conversion failed. rc = 2

(DB) INFO: disconnected from DB

rscpGetUmgContainerDLine,3568, l_result = 16

received return code 16 from rscpCopyContainerInfos for transparent table CUEX.(CNV) ERROR: data conversion failed. rc = 2

(DB) INFO: disconnected from DB

[Former Member]

- did you do all the necessary pre-processing (like SPUMG)?

- did you read the unicode conversion guide?

Regards, Michael

[Former Member]

Hi,

The procedure is as follows for unicode migration.

Question :- Is it Single code page or MDMP?

Single code page:-

Step 1:- Run Tcode SPUMG to scan

Step 2:- Export Database

Step 3:- Drop Database

Step 4:- Create New Database

Step 5:- Import database

Step 6:- Chnage unicode Kernel

Thanks and regards,

Atil Gaikwad

[Former Member]

Hi ,

If its a single code page make sure u go to transaction SPUMG and perform the consistency check

Thanks,

Siva kumar

[ganimede_dignan]

A question regarding spumg...

Should I enable the flag "Would you like to replace code page 1100 with 1160 in the language list" ?

it is a single codepage system...

Regards.

[ganimede_dignan]

Ok, thanks to all, now export ends without errors.

Our system has got some custmer table due very large table, when we start sapinst it show us only startdard sap tablespace with out my custom teblespace... is it correct?

I try to read DDLORA.TPL and DBSIZE.XML and our custom tbs are present... but I don't understand the sytax of this files...

Regards.

[ganimede_dignan]

Source system tablespaces..

PSAPBTABD

PSAPBTABI

PSAPCLUD

PSAPCLUI

PSAPDDICD

PSAPDDICI

PSAPDIMD

PSAPDIMI

PSAPDOCUD

PSAPDOCUI

PSAPEL700D

PSAPEL700I

PSAPES700D

PSAPES700I

PSAPFACTD

PSAPFACTI

PSAPLOADD

PSAPLOADI

PSAPODSD

PSAPODSI

PSAPPOOLD

PSAPPOOLI

PSAPPROTD

PSAPPROTI

PSAPSOURCED

PSAPSOURCEI

PSAPSTABD

PSAPSTABI

PSAPTEMP

PSAPUNDO

PSAPUSER1D

PSAPUSER1I

PSAPZACCTCRD

PSAPZACCTCRI

PSAPZACCTITD

PSAPZACCTITI

PSAPZAFVCD

PSAPZAFVCI

PSAPZAFVVD

PSAPZAFVVI

PSAPZAUSPD

PSAPZAUSPI

PSAPZBALDATD

PSAPZBALDATI

PSAPZBALHDRD

PSAPZBALHDRI

PSAPZBKPFD

PSAPZBKPFI

PSAPZBSIMD

PSAPZBSIMI

PSAPZBSISD

PSAPZBSISI

PSAPZCDHDRD

PSAPZCDHDRI

PSAPZCKISD

PSAPZCKISI

PSAPZCKITD

PSAPZCKITI

PSAPZCMFPD

PSAPZCMFPI

PSAPZCNVCLUD

PSAPZCNVCLUI

PSAPZCOEPD

PSAPZCOEPI

PSAPZCOSPD

PSAPZCOSPI

PSAPZCOSSD

PSAPZCOSSI

PSAPZEIPOD

PSAPZEIPOI

PSAPZEKBED

PSAPZEKBEI

PSAPZEKPOD

PSAPZEKPOI

PSAPZGLPCD

PSAPZGLPCI

PSAPZJESTD

PSAPZJESTI

PSAPZKONHD

PSAPZKONHI

PSAPZLIPSD

PSAPZLIPSI

PSAPZMARCD

PSAPZMARCI

PSAPZMARDD

PSAPZMARDI

PSAPZMBEWD

PSAPZMBEWI

PSAPZMCKALKWD

PSAPZMCKALKWI

PSAPZMDKPD

PSAPZMDKPI

PSAPZMDTBD

PSAPZMDTBI

PSAPZMSEGD

PSAPZMSEGI

PSAPZMSTAD

PSAPZMSTAI

PSAPZNASTD

PSAPZNASTI

PSAPZRESBD

PSAPZRESBI

PSAPZS022D

PSAPZS022I

PSAPZS026D

PSAPZS026I

PSAPZS027D

PSAPZS027I

PSAPZS033D

PSAPZS033I

PSAPZVBAPD

PSAPZVBAPI

PSAPZVBFAD

PSAPZVBFAI

PSAPZVBPAD

PSAPZVBPAI

PSAPZVBRPD

PSAPZVBRPI

SYSAUX

SYSTEM

But SAPinst show me only... on advanced db configuration:

PSAPSR3

PSAPSR3700

PSAPSR3FACT

PSAPSR3ODS

PSAPSR3USR

SYSAUX

PSAPUNDO

PSAPTEMP

SYSTEM

Why?

[ganimede_dignan]

I've just read 957917 ... but how can I solve now?

Regards.

[Former Member]

Add them in on the page it shows the missing tablespaces.....

Be careful when assigning the files as not to blow the filesystems.

Mark

Edited by: Mark Norman on Oct 20, 2009 1:25 PM

[ganimede_dignan]

We select to retuns to standard tbs layout, should be nicer.

regards.