cancel
Showing results for 
Search instead for 
Did you mean: 

DB IMPORT ERROR

Former Member
0 Kudos
153

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

View Entire Topic
Former Member
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

Former Member