migrate to linux + oracle stuck on database load phase

[Former Member]

when we do an import database on Linux + oracle from Windows + sql, we encounter the following error

***** Transaction begin ********************************************************

TRACE
checking existence of account user="prdadm" uid="205" succeeded with true.

TRACE
inserted account (prdadm, 205, USER) into the accountcache.

TRACE
checking existence of account group="dba" gid="201" succeeded with true.

TRACE
inserted account (dba, 201, GROUP) into the accountcache.

TRACE
trying to generate task file: /sapmnt/PRD/exe/R3load  -ctf I "/root/Desktop/PRD_Export1/DATA/SAPSSRC.STR" "/dbinstal/DDLORA.TPL" "/dbinstal/SAPSSRC.TSK" ORA -l "/dbinstal/SAPSSRC.log"

ERROR 2008-04-12 13:59:15
MSC-01004  Couldn't create task file /dbinstal/SAPSSRC.TSK 

***** Transaction end **********************************************************

and when i check the SAPSSRC.log, below is a log information.

/sapmnt/PRD/exe/R3load: START OF LOG: 20080412135915

/sapmnt/PRD/exe/R3load: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#6 $ SAP
/sapmnt/PRD/exe/R3load: version R6.20/V1.2
/sapmnt/PRD/exe/R3load -ctf I /root/Desktop/PRD_Export1/DATA/SAPSSRC.STR /dbinstal/DDLORA.TPL /dbinstal/SAPSSRC.TSK ORA -l /dbinstal/SAPSSRC.log 

(TPL) ERROR: unknown template variable "lob_cache"

/sapmnt/PRD/exe/R3load: job finished with 1 error(s)
/sapmnt/PRD/exe/R3load: END OF LOG: 20080412135915

any idea with this stuff ?

Edited by: Herry Lie on Apr 12, 2008 9:38 AM

[markus_doehr2]

Update to the latest R3load + dboraslib.so. If you migrate systems it´s highly suggested to use the latest tools (R3load, R3szchk, R3ta + database library).

The reason for this error is, that the export used a newer R3load with a new option that is not in your current R3load.

Markus

[Former Member]

it doesn't work pal. still got the same error.

[markus_doehr2]

With such a statement it's impossible to help (or to guess). Please post the latest log with the new R3load patch.

Markus

[stefan_koehler]

Hello Herry,

the error that you get, comes from the replacement character "&lob_cache&" in the DDLORA.TPL file.

In my 6.40 system it looks like:

cretab: CREATE TABLE &tab_name&
        ( /{ &fld_name& &fld_desc& /-, /} )
        TABLESPACE &tablespace&
        &lob_cache&
        STORAGE (INITIAL     &init&
                 NEXT        &next&
                 MINEXTENTS  &minext&
                 MAXEXTENTS  &maxext&
                 PCTINCREASE &pctinc& )

Which sap release and R3load / R3ldctl version are you using and please post the cretab part from your DDLORA.TPL.

Regards

Stefan

[Former Member]

hi stefan,

i'm running SAP R/3 Enterprise 4.7 Ext 1.10 and using R3load 640 version.

my DDLORA.TPL is exactly same like what u show me.

what a bad day, this few day running with this kind of case.

i try to get the latest sapinst version 641 to do the import, and now encounter the wrong migration key, eventhough i believe i was entry the correct mig key already.

try to check MIGKEY.log, got the following information.

/sapmnt/PRD/exe/R3load: START OF LOG: 20080412195603

/sapmnt/PRD/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#22 $ SAP
/sapmnt/PRD/exe/R3load: version R6.40/V1.4
Compiled Feb 18 2008 21:20:46
/sapmnt/PRD/exe/R3load -dbcodepage MDMP -i /dbinstall/SAPSSRC.cmd -l MIGKEY.log -K 1WqfdeM50TL105qtdaE93A10 

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 12705

DbSl Trace: CONNECT failed with sql error '12705'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 12705

DbSl Trace: CONNECT failed with sql error '12705'

(DB) ERROR: db_connect rc = 256
DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 12705

DbSl Trace: CONNECT failed with sql error '12705'

DbSl Trace: OCI-call 'OCISessionBegin' failed: rc = 12705

DbSl Trace: CONNECT failed with sql error '12705'

(DB) ERROR: DbSlErrorMsg rc = 99

/sapmnt/PRD/exe/R3load: job finished with 1 error(s)
/sapmnt/PRD/exe/R3load: END OF LOG: 20080412195604

what should i do with this R3load, looks like can not connect to anywhere.

how to trace the error ?

hope yours weekend can be fun stefan. thanks for helping.