ORA-1403

[Former Member]

Dear Experts,

I am installing SAP R/3 4.7 on HP-UX 11.23 on IA64 Processor with Oracle 9i Database. We have successfully completed the CI installation. We are step database load in Database instance installation. All the jobs are getting terminated with below error.

1. more SAPTTREE.log

/sapmnt/SBX/exe/R3load: START OF LOG: 20100925162703

/sapmnt/SBX/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/SBX/exe/R3load: version R6.40/V1.4

/sapmnt/SBX/exe/R3load -ctf I /oracle/SBX/sapdata16/SAP_INSTALLABLES/SAP_R3_RELEASE_ENTERPRISE_47X200_CD8/DATA/SAPTTREE.STR /

tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPTTREE.TS

K ORA -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPTTREE.log

/sapmnt/SBX/exe/R3load: job completed

/sapmnt/SBX/exe/R3load: END OF LOG: 20100925162703

/sapmnt/SBX/exe/R3load: START OF LOG: 20100925165542

/sapmnt/SBX/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/SBX/exe/R3load: version R6.40/V1.4

/sapmnt/SBX/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPTTREE.cmd -l /tmp/sapinst_i

nstdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPTTREE.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): WE8DEC

DbSl Trace: my_free: failed to free memory, invalid address 60000000007a9f58

(DB) INFO: TTREEI created

(IMP) INFO: import of TTREEI completed (1216779 rows)

DbSl Trace: ORA-1157 occured when executing SQL statement (parse error offset = 34)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "TTREEI~0" ON "TTREEI" ( "ID", "NODE_ID" ) TABLESPACE PSAPSBX620 STORAGE (INITIAL 147635451 NEXT 000000

0640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 1157)

error message returned by DbSl:

ORA-01157: cannot identify/lock data file 255 - see DBWR trace file

ORA-01110: data file 255: '/oracle/SBX/sapdata3/temp_1/temp.data1'

DbSl Trace: my_free: failed to free memory, invalid address 60000000007b28e8

DbSl Trace: my_free: failed to free memory, invalid address 6000000000c6ab98

(DB) INFO: disconnected from DB

/sapmnt/SBX/exe/R3load: job finished with 1 error(s)

/sapmnt/SBX/exe/R3load: END OF LOG: 20100925165554

SAPTTREE.log: END

Output of LISTENER and R3trans -d is perfect. The owner of table SAPUSER is OPS$SBXADM. Please, advise how to resolve this issue.

Thanks and Regards,

Kedar

[former_member204746]

post duplicated at

read forum rules...