Skip to Content
author's profile photo Former Member
Former Member

ERP 2004 SR1 with Oracle: unable to allocate MINEXTENTS

Hello Everybody,

I'm trying to install SAP ERP 2004 SR1 with Oracle on Debian Sarge (I know that it is not supported). The installation was prety straight forward. But now in the step "Database Load (Post processing)" i get this Errors:

/tmp/sapinst_instdir/ECC_50_ABAP_NUC/DB/SAPSSEXC.log:

(DB) ERROR: DDL statement failed

(CREATE INDEX "T100~001" ON "T100" ( "ARBGB" , "MSGNR" ) TABLESPACE PSAPIDS640 STORAGE (INITIAL 363889471 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 1659)

error message returned by DbSl:

ORA-01659: unable to allocate MINEXTENTS beyond 17 in tablespace PSAPIDS640

(DB) INFO: disconnected from DB

/tmp/sapinst_instdir/ECC_50_ABAP_NUC/DB/SAPAPPL2.log:

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "T512G~0" ON "T512G" ( "MANDT", "SPRSL", "MOLGA", "FORML", "WINDO", "GRPPE", "KENNZ", "LFDNR" ) TABLESPACE PSAPIDS STORAGE (INITIAL 11615742 NEXT 0000000080K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 1659)

error message returned by DbSl:

ORA-01659: unable to allocate MINEXTENTS beyond 4 in tablespace PSAPIDS

(DB) INFO: disconnected from DB

/tmp/sapinst_instdir/ECC_50_ABAP_NUC/DB/SAPSLEXC.log

(DB) ERROR: DDL statement failed

(CREATE INDEX "DDFTX~1" ON "DDFTX" ( "ROLLNAME" ) TABLESPACE PSAPIDS640 STORAGE (INITIAL 52072826 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 1659)

error message returned by DbSl:

ORA-01659: unable to allocate MINEXTENTS beyond 24 in tablespace PSAPIDS640

I think the tablespace is to small. Which commands do I need to extend them? I've alredy tried:

su – oraids
sqlplus /nolog
connect / as sysdba
SELECT * FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = 'PSAPIDS';
ALTER TABLESPACE PSAPIDS DEFAULT STORAGE 
(INITIAL 11615742 NEXT 0000000080K MINEXTENTS 0000000001 MAXEXTENTS 2347483645 PCTINCREASE 0);

Hope that anybody can help me out. I will publish the installation instructions here on SDN.

Regards

Gregor

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2005 at 01:01 PM

    Hi Gregor. The text of the Oracle message ORA-01659 is as follows. As you can see it recommends adding a data file first.

    01659, 00000, "unable to allocate MINEXTENTS beyond %s in tablespace %s"
    // *Cause:  Failed to find sufficient contiguous space to allocate MINEXTENTS
    //          for the segment being created.
    // *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
    //          tablespace or retry with smaller value for MINEXTENTS, NEXT or
    //          PCTINCREASE
    

    The syntax for adding a datafile would be

    alter tablespace PSAPIDS add datafile '/your/path/psapids99.dbf' size 100m;
    

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.