Skip to Content
avatar image
Former Member

ORA-01659: unable to allocate MINEXTENTS beyond 28 in tablespace PSAPSR3700

hi everyone

When I install ECC6.00 sr3 with oracle&HP-UX

I come across an error at the set u201Cimport abapu201D

my oracle version is 10.2.0.4

my HP-UX is 11-23

*********************import monitor log********************

ERROR: 2010-01-22 02:42:37 com.sap.inst.migmon.LoadTask run

Loading of 'DD03L' import package is interrupted with R3load error.

Process '/usr/sap/R3T/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4102 -l DD03L.

log -stop_on_error' exited with return code 9.

For mode details see 'DD03L.log' file.

Standard error output:

/usr/lib/hpux64/dld.so: Unable to find library 'libclntsh.so.10.1'.

*******************************************************************

  • 'DD03L.log' ****************************

(DB) ERROR: DDL statement failed

(DROP INDEX "DD03L~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 "DD03L~0" ON "DD03L" ( "TABNAME", "FIELDNAME", "AS4LOCAL",

"AS4VERS", "POSITION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 712194033 NEXT 0

000002560K 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 P015

ORA-01659: unable to allocate MINEXTENTS beyond 28 in tablespace PSAPSR3700

(DB) INFO: disconnected from DB

**********************************************************

********************tablespace view****************

Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.

Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt. Largest[KB]

1 - PSAPSR3 DATA ONLINE LOCAL AUTO NO 20/20

41328640 75.99 9922304 204800000 20008960 93 8192000:8192000:3624960+:1157056:866304

2 - PSAPSR3700 DATA ONLINE LOCAL AUTO NO 21/21

43868160 76.44 10337472 215040000 20008960 44 8151040:8151040:3706880+:2088896:2071488

3 - PSAPSR3USR DATA ONLINE LOCAL AUTO NO 1/1

20480 9.38 18560 10240000 10219520 1 10219520+:18560:0:0:0

4 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 3/1

6144000 0.00 6144000 14336000 8192000 0 8192000+:0:0:0:0

5 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO 3/1

6266880 0.00 6266688 14417920 8151040 4854 8151040+:2083776:2073344:8192:8192

6 - SYSAUX DATA ONLINE LOCAL AUTO NO 1/1

204800 24.72 154176 10240000 10035200 1 10035200+:154176:0:0:0

7 - SYSTEM DATA ONLINE LOCAL MANUAL NO 2/2

1392640 49.76 699712 20480000 19087360 2 9543680:9543680:696256:3456:0

**********************************************************

I do need yours helps

any advise will be much appreciated!

Thanks&Regards

Peter

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 22, 2010 at 02:29 PM

    you have 2 possible solutions:

    1. grow/resize an exiting datafile:

    brspace -c -u / -f dfalter

    2. add a datafile

    brspace -c -u / -f tsextend

    I prefer option 1 whenever possible.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2010 at 06:54 AM

    Hi,

    > Standard error output:

    > /usr/lib/hpux64/dld.so: Unable to find library 'libclntsh.so.10.1'.

    client library files are missing. check it.

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2010 at 08:58 AM

    Hi,

    The problem is your tablespace is full... (it should not...)

    see if you can be able to run BRTOOLS from command line,

    if so, check your tablespace and if needed extend it...

    Steps to do so :

    run brtools...

    2 - Space management

    1 = Extend tablespace

    Press "c" .. again "c" and continue..

    1 = Extend tablespace

    then enter the number of your tablespace you want to extend.. and continue..

    It will show you default setting for the datafile..

    Press "c" and continue...

    add more datafile if needed...

    then retry the installation...

    If you still face the same error, do the next...

    logon as ora<sid>

    go to $ORACLE_HOEM/bin

    execute "relink all" command

    then retry the installation...

    Regards.

    Rajesh Narkhede

    Edited by: Rajesh Narkhede on Jan 22, 2010 2:35 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for all replies

      in fact,i have done these tablespace extention operation ,include adding new datafiles and autoextend

      But it does not worked

      ********************tablespace view****************

      Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.

      Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt. Largest[KB]

      1 - PSAPSR3 DATA ONLINE LOCAL AUTO NO 20/20

      41328640 75.99 9922304 204800000 20008960 93 8192000:8192000:3624960+:1157056:866304

      2 - PSAPSR3700 DATA ONLINE LOCAL AUTO NO 21/21

      43868160 76.44 10337472 215040000 20008960 44 8151040:8151040:3706880+:2088896:2071488

      3 - PSAPSR3USR DATA ONLINE LOCAL AUTO NO 1/1

      20480 9.38 18560 10240000 10219520 1 10219520+:18560:0:0:0

      4 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 3/1

      6144000 0.00 6144000 14336000 8192000 0 8192000+:0:0:0:0

      5 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO 3/1

      6266880 0.00 6266688 14417920 8151040 4854 8151040+:2083776:2073344:8192:8192

      6 - SYSAUX DATA ONLINE LOCAL AUTO NO 1/1

      204800 24.72 154176 10240000 10035200 1 10035200+:154176:0:0:0

      7 - SYSTEM DATA ONLINE LOCAL MANUAL NO 2/2

      1392640 49.76 699712 20480000 19087360 2 9543680:9543680:696256:3456:0

      ****************************************************************

      the other hand,my os platform is HP-UX

      is there any OS parameters should be modified?

      eg. ulimits file (the values of file is ulimited)and vg configuration(allow large file)

  • avatar image
    Former Member
    Jan 23, 2010 at 05:29 AM

    I do not know why the newlines are all missed in my posts

    but in my reply everything goes well

    Does somebody know the reasons?

    **********************************************************8

    When I install ECC6.00 sr3 with oracle&HP-UX

    I come across an error at the set u201Cimport abapu201D

    my oracle version is 10.2.0.4

    my HP-UX is 11-23

    *********************import monitor log********************

    ERROR: 2010-01-22 02:42:37 com.sap.inst.migmon.LoadTask run

    Loading of 'DD03L' import package is interrupted with R3load error.

    Process '/usr/sap/R3T/SYS/exe/run/R3load -i DD03L.cmd -dbcodepage 4102 -l DD03L.

    log -stop_on_error' exited with return code 9.

    For mode details see 'DD03L.log' file.

    Standard error output:

    /usr/lib/hpux64/dld.so: Unable to find library 'libclntsh.so.10.1'.

    *******************************************************************

    • 'DD03L.log' ****************************

    (DB) ERROR: DDL statement failed

    (DROP INDEX "DD03L~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 "DD03L~0" ON "DD03L" ( "TABNAME", "FIELDNAME", "AS4LOCAL",

    "AS4VERS", "POSITION" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 712194033 NEXT 0

    000002560K 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 P015

    ORA-01659: unable to allocate MINEXTENTS beyond 28 in tablespace PSAPSR3700

    (DB) INFO: disconnected from DB

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      this looks strange.

      ORA-1659 indicates TS full, but your data says plenty of space available.

      Do you have any other short logs of successfully imported tables?

      Any filesystem full ?

      Shared_pool_size ?

      Space of TEMP TS ?

      Did you change the window from where you started sapinst after an aborted

      first try, so that your environment (Like Lib-Path stuff) has been changed ?

      700MB Index size do not look very critical when having GBs of freespace...

      weird!

      ... oh, and running brtools/brspace while still installing the system might

      give you a couple of headaches later on. But we'll deal with that then 😊

      Next time use plain sqlplus until the LOAD is completely finished.

      Volker