DB IMPORT ERROR
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