Export the DB from our Production system faild

[Former Member]

Dear All,

we trying to 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

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

[Former Member · Accepted solution]

hi

please check whether you have the read/write access to the path specified.

r/w/x

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Kumar,

Check if the tablespace PSAPPRD640 exist.

SQL> select tablespace_name from dba_tablespaces where tablespace_name='PSAPPRD640';

Regards

Ashok Dalai