error importa abap ORA-01659: unable to allocate MINEXTENTS beyond 52 in t

[Former Member]

Hi All,

I´m installing ECC, Java, abap , ep , epcore and bi java in the same instance, with oracle 10g and linux red hat 5.3, but in the phase import abab I have errors , I attach the log

Please help me

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DB) ERROR: DDL statement failed

(DROP INDEX "TODIR~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

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

DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "TODIR~0" ON "TODIR" ( "FRAGID", "FRAGMENT", "FRAGNAME" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 904410666 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P037

ORA-01659: unable to allocate MINEXTENTS beyond 46 in tablespace PSAPSR3

(DB) INFO: disconnected from DB

/usr/sap/BWP/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/BWP/SYS/exe/run/R3load: END OF LOG: 20100811165714

/usr/sap/BWP/SYS/exe/run/R3load: START OF LOG: 20100811171433

/usr/sap/BWP/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

/usr/sap/BWP/SYS/exe/run/R3load: version R7.00/V1.4

Compiled Nov 18 2008 20:49:15

/usr/sap/BWP/SYS/exe/run/R3load -i TODIR.cmd -dbcodepage 4103 -l TODIR.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

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(DB) ERROR: DDL statement failed

(DROP INDEX "TODIR~0")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

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

DbSl Trace: Error 12801 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-12801 occurred when executing SQL stmt (parse error offset=0)

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "TODIR~0" ON "TODIR" ( "FRAGID", "FRAGMENT", "FRAGNAME" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 904410666 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P002

ORA-01659: unable to allocate MINEXTENTS beyond 52 in tablespace PSAPSR3

(DB) INFO: disconnected from DB

/usr/sap/BWP/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/BWP/SYS/exe/run/R3load: END OF LOG: 20100811171438

Regards and Thanks

Graciela

[former_member204746]

use this command to extend PSAPSR3

brspace -c -u / -f tsextend

[Former Member]

Hi use this command , but I have this error about the license

brspace -c -u / -f tsextend

BR1001I BRSPACE 7.00 (32)

BR1002I Start of BRSPACE processing: sedwpdoc.tse 2010-08-12 10.25.38

BR0484I BRSPACE log file: /oracle/BWP/sapreorg/sedwpdoc.tse

BR0925I Public synonym SAP_SDBAH created successfully for table SAPSR3DB.SDBAH

BR0925I Public synonym SAP_SDBAD created successfully for table SAPSR3DB.SDBAD

BR0925I Public synonym SAP_DBSTATC created successfully for table SAPSR3DB.DBSTA TC

BR0925I Public synonym SAP_DBSTATTORA created successfully for table SAPSR3DB.DB STATTORA

BR0925I Public synonym SAP_DBSTATIORA created successfully for table SAPSR3DB.DB STATIORA

BR0925I Public synonym SAP_DBSTATHORA created successfully for table SAPSR3DB.DB STATHORA

BR0925I Public synonym SAP_DBSTAIHORA created successfully for table SAPSR3DB.DB STAIHORA

BR0925I Public synonym SAP_DBCHECKORA created successfully for table SAPSR3DB.DB CHECKORA

BR0925I Public synonym SAP_DBMSGORA created successfully for table SAPSR3DB.DBMS GORA

BR1304E Checking SAP license failed at location BrLicCheck-103

BR0602E No valid SAP license found - please contact SAP

BR0700E Fatal errors occurred - terminating processing...

BR0280I BRSPACE time stamp: 2010-08-12 10.25.39

BR0301W SQL error -980 at location BrsDblogOpen-1, SQL statement:

'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES (' 20100812102538', 'tse', 'BWP', ' ', '9999', ' ', 'sedwpdoc', '7.00 (32)')'

ORA-00980: synonym translation is no longer valid

BR0324W Insertion of database log header failed

BR1008I End of BRSPACE processing: sedwpdoc.tse 2010-08-12 10.25.39

BR0280I BRSPACE time stamp: 2010-08-12 10.25.39

BR1007I BRSPACE terminated with errors

[former_member204746]

you will need to do this manually:

md /oracle/bwp/sapdata1/sr3_2

sqlplus / as sysdba

alter tablespace PSAPSR3 add datafile '/oracle/BWP/sapdata1/sr3_2/sr3.data size 64M autoextend on next 64M maxsize 16000M;

exit

good luck.

[former_member524429]

Hi,

Its pointing to Overflow of PSAPSR3 Tablespace. Please verify it.

Please [extend PSAPSR3 tablespace using br*tools|http://help.sap.com/saphelp_nw04//helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm] by adding new data-file(s) at another free storage location and continue with old installation...

Regards,

Bhavik G. Shroff

[Fabrizio_Irmici]

Hi,

first of all check your tablespace sizing and read the following OSS notes:

3155

502237

Regards,

Fabrizio