IS IT POSSIABLE TO DO SYSTEM COPY 64 to 32 bit

[Former Member]

Dear All,

We doing system copy and facing problem.

Connected.

ERROR: ORA-06553: PLS-801: internal error 56319

There source system is 64bit and target system is on 32bit.

In Sap system copy there is upgrade your database from 32-bit to 64-bit but not form 64bit to 32bit.

Do I have to add the same in the control. sol file.

Changes to be made

1. If you want to upgrade your database from 32-bit to 64-bit, add the following lines at the bottom of

the CONTROL.SQL file:

shutdown immediate;

startup restrict

spool utlirp.log

@?/rdbms/admin/utlirp.sql

spool off

alter system disable restricted session;

Till no we have restore the database the oracle is up and running but when starting sap dispatches is getting stop.

It is possiable to do system copy form 64 bit to 32 bit . by any process like R3load.

*So Please suggest is there any way .*

Regards,

Kumar

[Former Member]

Thanks all

[Former Member]

Hi I read your questions

and Here is what you can do

first your source system is 64-bit and target would be 32-bit, you can not just take the backup of 64-bit database and do restore on 32-bit. What you can do is take full EXPORT (Logical Backup of Oracle database using expdp userid="/as sysdba" dumpfile="file_name" logfile="file_name" full=y) Assuming you have oracle10g database. then take that dump to target system and start import . Monitor the import for any errors. That would run for few hours for sure.

thanks

[Former Member]

Dear all,

Thanks all,

So if I go for R3load there are some queries(Read system copy guide).

1 sap should be stop and oracle (9i) up and sap server also stop.

2. where will be dump of sap will go

3. At what time I have to request the migration key .

4. if I have run the r3load how much time it will take for 280GB database .

5. can I stop the process r3load at any time and there is no harm (eg if take long time so we have up the sap application )

Please suggest.

Regards,

Kumar

[markus_doehr2]

> So if I go for R3load there are some queries(Read system copy guide).

> 1 sap should be stop and oracle (9i) up and sap server also stop.

> 2. where will be dump of sap will go

you will be asked for a directory.

> 3. At what time I have to request the migration key .

At installation time

> 4. if I have run the r3load how much time it will take for 280GB database .

This depends of the speed of the underlying I/O system, the number of R3load processes you run in parallel and the speed of the machine.

> 5. can I stop the process r3load at any time and there is no harm (eg if take long time so we have up the sap application )

no, if you stop them and restart them your system won't be consistent.

Markus

[Former Member]

Hi,

5. can I stop the process r3load at any time and there is no harm (eg if take long time so we have up the sap application )

no, if you stop them and restart them your system won't be consistent.

The System won't be consistent means the data which we are exporting or PRD server database.

in general how much time it will take so we can plan the actives (Eg if i take dome time for night but the process go till morning that time i have to stop bze sap cant be down)

Please suggest.

Kumar

[markus_doehr2]

> The System won't be consistent means the data which we are exporting or PRD server database.

Your export is not consistent then (and hence the target system that you will up).

> in general how much time it will take so we can plan the actives (Eg if i take dome time for night but the process go till morning that time i have to stop bze sap cant be down)

as I said - this depends on too many factors (speed of I/O system, number of R3loads, load of the machine) etc.

Generally, if you use R3load you need to shut down the SAP instance to get a consistent export. If you keep the system running you won't.

One night may or may not be enough, you'll have to try that out.

Markus

[Former Member]

Hi Markus,

Thanks ,So if i there is an issues where i have up sap system in a susation to stop the r3load process

do the same process again for export.

Regards,

Kumar

[markus_doehr2]

> Thanks ,So if i there is an issues where i have up sap system in a susation to stop the r3load process

> do the same process again for export.

you'll have to start over with the export.

Markus

[Former Member]

Dear all ,

I am facing problem while doing the r3load process for export data from PRD.the error just come after given the profile path.

The error is the parameter is not set in default profile for host name in message sever .

we have set the parameter rdisp/msserv_internal =0 as per note 821875 in default profile.

But after setting the parameter the error is not able to connect internal .

There is once thing else to as per system copy we have to run the program SMIGR_CREATE_DDL.

But is getting time out i have incess the parameter to 1 hr but still it is time out. how imp this process is .

Please suggest .

Regards,

Kumar

[Former Member]

>

> There is once thing else to as per system copy we have to run the program SMIGR_CREATE_DDL.

> But is getting time out i have incess the parameter to 1 hr but still it is time out. how imp this process is .

>

If you are not making copy of Bw system then you can skip this step.

- Rohit

[Former Member]

Dear All,

Export the DB from our Production system to network drive.we MSCS environement and Our system details are below

Ecc5 ,oracle 9i and windows 2003 (SP1)

SAP-01 (NODE1 active)

SAP-02 (NODE2 pactive)

virtual hosts

SAP-CLUS

SAP-VIR

SAP-ORAV

we have set the parameter rdisp/msserv_internal as per note 821875 in default profile

In the server with DB, we launch the sapinst from the 51033511_12 CD.

We select the path: ECC6 -> Additional Life-cycle... -> System Copy ->

Oracle -> Source System -> HA System -> Database Instance Export.

Sapinst asks only for the parameters:

- profile directory

- sidadm password

- export location

and start for the export. after a few seconds the system finish

with "successfully completed".

But in the export directory there are only ABAP folder and LABELIDX.ASC

file with out any data.

The sapinst.log file have no error reported.

The R3load aren't never started.

Please suggest.

Regards,

Kumar

[markus_doehr2]

> and start for the export. after a few seconds the system finish

> with "successfully completed".

> But in the export directory there are only ABAP folder and LABELIDX.ASC

> file with out any data.

> The sapinst.log file have no error reported.

> The R3load aren't never started.

you may need to set "SAPINST_USE_HOSTNAME" to make sure sapinst uses the correct one.

Markus

[Former Member]

Hi,

I have set the parameter "SAPINST_USE_HOSTNAME" already in default path.

The value i have tried both

1 the virtual host of application and database but the result in the export directory(network drive) there are only ABAP folder and LABELIDX.ASC.

Please suggest .What value has to bee given of parameter SAPINST_USE_HOSTNAME in MSCS environment.and the application and database both are one sever and the 2 node is pasive.

Regards,

Kuamr

[markus_doehr2]

> I have set the parameter "SAPINST_USE_HOSTNAME" already in default path.

What do you mean with "in the default path"?

Markus

[Former Member]

Hi,

sorry , In the default profile . we have add the SAPINST_USE_HOSTNAME parameter.

Regards,

[markus_doehr2]

Sapinst evaluates that parameter on startup, not on profile evaluation.

Exeucte it on command line using

sapinst SAPINST_USE_HOSTNAME=

Markus

[Former Member]

Hi,

Thanks ,the export form PRD sucessfully complected no i am facinf problem in trget system

in phase22 database load.

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

DbSl Trace: ORA-959 occured when executing SQL statement (parse error offset = 615)

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD" ( "PROGNAME" VARCHAR2(120) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "MACH" NUMBER(5) DEFAULT 0 NOT NULL , "UNAM" VARCHAR2(36) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(18) DEFAULT '000000' NOT NULL , "L_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "Q_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "SDAT" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(18) DEFAULT '000000' NOT NULL , "MINOR_VERS" NUMBER(5) DEFAULT 0 NOT NULL , "MAJOR_VERS" NUMBER(10) DEFAULT 0 NOT NULL , "LDATA" BLOB , "QDATA" BLOB ) TABLESPACE PSAPPRD640 LOB ("LDATA", "QDATA") STORE AS (CACHE) STORAGE (INITIAL 0000000016K NEXT 0000040960K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 959)

error message returned by DbSl:

ORA-00959: tablespace 'PSAPPRD640' does not exist

(DB) INFO: disconnected from DB

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

C:\usr\sap\PRD\SYS\exe\run/R3load.exe: END OF LOG: 20090828045440

Please suggest .

Regadrs,

Kumar

[markus_doehr2]

Did you enter PRD as <SID> at time of the installation?

Markus

[Former Member]

Hi,

Yes the sid is same PRD for test server but i have change the password in the test sever that also shuled be same.

Regards,

Kumar

[markus_doehr2]

And your tablespaces for the target system were also created with database name PRD?

Markus

[Former Member]

Hi Markus,

Yes, there is once thing when i was installing it ask the datafile(SAPDATA1,2and 3) i have taken default only but in the prd there are SAPDATA4.

Please suggest

regards,

Kumar

[markus_doehr2]

Was that a clean install or did you just delete old database files on the target system?

Markus

[Former Member]

Hi Markus,

It is new (clean) install on the target system.

Regards,

Kumar

[markus_doehr2]

This is really strange.

Something went wrong during the configuration of the database instance. R3load is trying to import data into a tablespace that is not existing...

Markus

[Former Member]

Dear All,

I came to know that it is not possible to do system copy or R3load prosess because

the oracle 9i is supported by 64 bit or 32 bit. It support only IA base server.

As suggest by sap so we can do system copy from IA64 bit to 32 bit server.

Thanks all

Regards,

Kumar

[markus_doehr2]

R3load is available on ALL platforms and depending on the version used it can unload/load a database on a 32bit or 64bit OS. The resulting export could even be imported into other databases.

The "clean" and supported way in this case is R3load.

Markus

[Former Member]

Hi,

Usually any lower to higher end shifting we call upgrade and not frm higher end to lower.

In your case it was migration scenario and i am not aware if the higher bit format supported in lower bit.

you need to make hetrogenous system copy and then follow steps for migration process. For this u require a migration key from SAP.

Apart from this no other process can be helpfull in your case(as far iam aware).

Pls post if u found a solution for 64 bit to 32bit system copy........

Thanks,

Regards,

Sitarama.

[markus_doehr2]

You can always use R3load because the format is database and OS independent.

Markus

[Former Member]

Hi,

Why you are doing MULTI POSTING?

Just log one message and follow-up. Then your query will get resolved soon.

The same you logged in ERP forum........

Regards

Nick Loy

[markus_doehr2]

> Till no we have restore the database the oracle is up and running but when starting sap dispatches is getting stop.

What is the output of dev_disp and dev_w0?

Markus

[Former Member]

Hi,

I done system copy and restore the databse

Please find the below logs.

-

---

trc file: "dev_disp", trc level: 1, release: "640"

-

---

Sat Aug 08 16:34:26 2009

kernel runs with dp version 128000(ext=102000) (@(#) DPLIB-INT-VERSION-128000-UC)

length of sys_adm_ext is 524 bytes

systemid 560 (PC with Windows NT)

relno 6400

patchlevel 0

patchno 43

intno 20020600

make: multithreaded, Unicode

pid 2716

***LOG Q00=> DpSapEnvInit, DPStart (00 2716) [dpxxdisp.c 1100]

shared lib "dw_xml.dll" version 43 successfully loaded

Sat Aug 08 16:34:31 2009

• WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 4 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c 3886]

Sat Aug 08 16:34:32 2009

MBUF state OFF

EmInit: MmSetImplementation( 2 ).

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 2456 blocks reserved for free list.

ES initialized.

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 2.6.1 2.6 4.0) [dpxxdisp.c 1462]

***LOG Q0K=> DpMsAttach, mscon ( ##) [dpxxdisp.c 9736]

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

CCMS: start to initalize 3.X shared alert area (first segment).

DpMsgAdmin: Set release to 6400, patchlevel 0

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c 1025]

DpMsgAdmin: Set patchno for this platform to 43

Release check o.K.

Sat Aug 08 16:35:12 2009

• ERROR => W0 (pid 3696) died [dpxxdisp.c 12187]

• ERROR => W7 (pid 4000) died [dpxxdisp.c 12187]

my types changed after wp death/restart 0xa0 --> 0x80

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

killing W0-3696 (SIGUSR2)

• ERROR => DpWpKill(3696, SIGUSR2) failed [dpxxtool.c 2468]

killing W1-3748 (SIGUSR2)

• ERROR => DpWpKill(3748, SIGUSR2) failed [dpxxtool.c 2468]

k

Sat Aug 08 16:35:27 2009

NiISelect: TIMEOUT occured (5000 ms)

Shutdown server ...

DpJ2eeDisableRestart

DpModState: buffer in state MBUF_PREPARED

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIModState: change state to SHUTDOWN

DpModState: change server state from STARTING to SHUTDOWN

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

Stop work processes...

Stop gateway

killing process (560) (SOFT_KILL)

Stop icman

killing process (520) (SOFT_KILL)

Terminate gui connections

[DpProcDied] Process lives (PID:560 HANDLE:1576)

waiting for termination of gateway

NiWait: sleep (1000 msecs) ...

NiISelect: timeout 1000 ms

NiISelect: maximum fd=1597

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Sat Aug 08 16:35:28 2009

NiISelect: TIMEOUT occured (1000 ms)

[DpProcDied] Process died (PID:560 HANDLE:1576)

[DpProcDied] Process died (PID:520 HANDLE:1568)

DpHalt: cancel all lcom connections

MPI CancelAll 2 -> 0

MPI DeleteAll 2 -> 0

NiIMyHostName: hostname = '##'

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 4 (AD_STARTSTOP), ser 0, ex 0, errno 0

DpConvertRequest: net size = 163 bytes

NiBufSend starting

NiIWrite: write 562, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 562 bytes

send msg (len 110+452) to name -, type 4, key -

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 9962]

NiBufSend starting

NiIWrite: write 110, 1 packs, MESG_IO, hdl 3, data complete

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiSelClear: removed hdl 3 from selectset

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/8

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 19)

MBUF component DOWN

NiBufClose: clear extensions for hdl 3

NiBufSetStat: bufstat of hdl 3 changed from OK to OFF

NiICloseHandle: shutdown and close hdl 3 / socket 1580

MsIDetach: detach MS-system

EsCleanup ....

***LOG Q05=> DpHalt, DPStop ( 2716) [dpxxdisp.c 8495]

Good Bye .....

-

---

trc file: "dev_w0", trc level: 1, release: "640"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Sat Aug 08 16:34:32 2009

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B Library 'C:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.39)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 43

M intno 20020600

M make: multithreaded, Unicode

M pid 3696

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3696) [dpxxdisp.c 1160]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M DpShMCreate: sizeof(wp_adm) 10528 (1316)

M DpShMCreate: sizeof(tm_adm) 2780232 (13832)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpShMCreate: sizeof(comm_adm) 290000 (580)

M DpShMCreate: sizeof(vmc_adm) 0 (372)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 04540040, size: 3192688)

M DpShMCreate: allocated sys_adm at 04540040

M DpShMCreate: allocated wp_adm at 04541B58

M DpShMCreate: allocated tm_adm_list at 04544478

M DpShMCreate: allocated tm_adm at 045444A0

M DpShMCreate: allocated wp_ca_adm at 047EB0E8

M DpShMCreate: allocated appc_ca_adm at 047F0EA8

M DpShMCreate: allocated comm_adm_list at 047F2DE8

M DpShMCreate: allocated comm_adm at 047F2E00

M DpShMCreate: allocated vmc_adm_list at 04839AD0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 04839AF8

M DpShMCreate: allocated wall_adm at 04839B00

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Sat Aug 08 16:34:33 2009

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora92 from environment

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Got TNS_ADMIN=
##\sapmnt\PRD\SYS\profile\oracle from environment

C Logon as OPS$-user to get SAPPRD's password

C Connecting as /@PRD on connection 0 ...

C Attaching to DB Server PRD (con_hdl=0,svchp=042813D4,svrhp=0431A584)

C Starting user session (con_hdl=0,svchp=042813D4,srvhp=0431A584,usrhp=075EE0D8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3720]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 9750]

C Try to connect with default password

C Connecting as SAPPRD/<pwd>@PRD on connection 0 ...

C Starting user session (con_hdl=0,svchp=042813D4,srvhp=0431A584,usrhp=075EE0D8)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 3720]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 9750]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1200] [dbsh 1200 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1269]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M

M *

M * LOCATION SAP-Server ##_PRD_00 on host ## (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat Aug 08 16:34:33 2009

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9589

M * COUNTER 1

M *

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 252]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3696) [dpnttool.c 357]

Regards,

[Former Member]

ERROR => CONNECT failed with sql error '1017' [dbsloci.c 9750] B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1200] [dbsh 1200 ] B ***LOG BY0=> ORA-01017: invalid username/password; logon denied

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=400241]

[Former Member]

You may want to consider using homo/hetrogeneous system copy procedures. You can find detailed information in the link below.

[]

[Former Member]

Hi,

Please go through below link.

[http://help.sap.com/saphelp_nw70/helpdata/en/a2/2f0c173a5e43d19585724239ff4de7/content.htm]

Regards,

Muralidharl