cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DB IMPORT ERROR

Go to solution
Former Member

on ‎01-19-2009 5:01 AM

0 Kudos

Hi Gurus ,

We are now upgrading the server from R3 4.7 32 BIT to ECC 6.0 64 BIT . As per the upgrade plan we installed R3 4.7 64 BIT in our new server . Then we export the DB using system copy from the old server . Then we import that data into the new server R3 4,7 64 BIT . But now we getting the follwing error while import process .

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20090117182031

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -ctf I E:\DATA\copy/DATA/SAP0000.STR C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/DDLORA.TPL C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.TSK ORA -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.log -o D

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: job completed

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20090117182031

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20090117213443

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

DbSl Trace: Error in exec_immediate()

DbSl Trace: ORA-959 occurred 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 PSAPDEV620 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 'PSAPDEV620' does not exist

(DB) INFO: disconnected from DB

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

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20090117213443

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20090119085258

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP TABLE "REPOLOAD")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error in exec_immediate()

DbSl Trace: ORA-959 occurred 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 PSAPDEV620 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 'PSAPDEV620' does not exist

(DB) INFO: disconnected from DB

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

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20090119085258

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20090119091448

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.log -stop_on_error

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

DbSl Trace: CONNECT failed with sql error '1034'

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

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

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

DbSl Trace: CONNECT failed with sql error '1034'

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

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

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

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20090119091448

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: START OF LOG: 20090119093657

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#12 $ SAP

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: version R6.40/V1.4 [UNICODE]

Compiled Dec 15 2005 22:22:21

E:\usr\sap\DEV\SYS\exe\run/R3load.exe -dbcodepage 4103 -i C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\UC\DB/SAP0000.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(DB) ERROR: DDL statement failed

(DROP TABLE "REPOLOAD")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error in exec_immediate()

DbSl Trace: ORA-959 occurred 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 PSAPDEV620 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 'PSAPDEV620' does not exist

(DB) INFO: disconnected from DB

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

E:\usr\sap\DEV\SYS\exe\run/R3load.exe: END OF LOG: 20090119093657

So kindly give me the solution .

Regards

Selvan .SP

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎01-19-2009 9:05 AM
0 Kudos

HI Nikunj Thaker ,

Thanks , can you tell me , How can i upgrade , for new installation we ran server.cmd file , So kindly tell me if upgrade means which file i have to run in the oracle 10.2 DVD . Kindly tell me .

Regards

Selvan

Show replies
Show replies
Former Member
‎01-19-2009 9:28 AM
0 Kudos

Refer To https://websmp109.sap-ag.de/~sapdownload/011000358700003520252006E/WIN_ORA_UPG_GUIDE_vers40.pdf

Regards,

Nikunj Thaker

Answers (8)

Answers (8)

Former Member
‎01-19-2009 9:34 AM
0 Kudos

Hi ,

Thanks

SElvan

Show replies
Show replies
Former Member
‎01-19-2009 8:50 AM
0 Kudos

HI Nikunj Thaker ,

Kindly tell me , no need to upgrade oracle 10.2 from 9.2 seperately ? Kindly advice me .

Regards

Selvan .SP

Show replies
Show replies
Former Member
‎01-19-2009 9:01 AM
0 Kudos

ECC 6.0 required 10.2 so before start SAP Upgrade you have to Upgrade your database to 10.2.

Regards,

Nikunj Thaker.

Former Member
‎01-19-2009 8:36 AM
0 Kudos

HI Nikunj Thaker ,

Thanks , I got your point . Now i have one doubt . After import the data , what is the next step . Shall i use the upgrade master DVD for ECC 6.0 or UPGRADE the oracle from 9.2 to 10.2 .

Kindly advice me .

Regards

Selvan .SP

Show replies
Show replies
Former Member
‎01-19-2009 8:38 AM
0 Kudos

After Import data you have to follow homo. system copy steps i.e. stms, rz10 etc.

One you system get migrated then you can use upgrade master.

Regards,

Nikunj Thaker.

Former Member
‎01-19-2009 7:32 AM
0 Kudos

HI Nikunj Thaker ,

We had a new IBM blade server , in that server i installed 64 bit OS , 64 bit SAP 4.7 and oracel 10.2 . After thst the 64 bit 4.7 worked fine , i am able to login also . Then i took the system copy from the old server and import the system copy into the server . This is the pocess i have done . Kindly tell me my process is right ? Kindly advice me .

Regards

Selvan .

Show replies
Show replies
Former Member
‎01-19-2009 8:32 AM
0 Kudos

Your process was not right how you can attach 9.2 DB to 10.2 ?

Install 9.2 64bit there and import 9.2 32bit DB.

I suggest use database specific method cold backup which is much faster then export/import.

Regards,

Nikunj

Former Member
‎01-19-2009 7:01 AM
0 Kudos

HI Nikunj Thaker ,

No , i used the installation master for 32 bit from the old server and took the system copy , Then i used the 64 bit installation master , used system copy , restore the DB . This is the porocess i done .

Regards

Selvan .SP

Show replies
Show replies
Former Member
‎01-19-2009 7:25 AM
0 Kudos

Without Upgrading database from 9.2 to 10.2 how can import will work ?

Regards,

Nikunj Thaker.

Former Member
‎01-19-2009 6:45 AM
0 Kudos

HI Nikunj Thaker ,

Our old servers one of the block corrupted , so we are not able to take backup through 3rd party software or RMAN . So we planned to take system copy method . We installed oracle 10.2 for the new server . Existing server usend Oracle 9 .

So kindly give me the solution .

Regards

Selvan

Show replies
Show replies
Former Member
‎01-19-2009 6:47 AM
0 Kudos

How you can migrate from Oracle 9 to 10.2 ?

Are you able to take cold backup ?

Regards,

Nikunj Thaker

Former Member
‎01-19-2009 6:26 AM
0 Kudos

HI Nikunj Thaker ,

Yes , You are right exactly .

Regards

Selvan

Show replies
Show replies
Former Member
‎01-19-2009 6:32 AM
0 Kudos

Dear,

Then why are you using export/import method ?

You have to use Database Backup and Resore.

details steps.

install 64bit OS

Install 64bit DB Software

Install 64bit SAP CI.

Restore Database.

Attach Database.

32bit to 64bit migration is over.

Perform System copy methods like configure stms, rz10 etc.

Which database are you using ?

Regards,

Nikunj Thaker.

Edited by: Nikunj Thaker on Jan 19, 2009 12:03 PM

Former Member
‎01-19-2009 6:24 AM
0 Kudos

Do you want to convert your 4.7 32bit system to 4.7 64bit system ?

Regards,

Nikunj Thaker

Show replies
Show replies
Ask a Question