cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

Go to solution
Former Member

on ‎01-22-2010 2:56 AM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
‎01-22-2010 2:29 PM
0 Kudos

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.

Show replies
Show replies

Answers (3)

Answers (3)

Former Member
‎01-23-2010 5:29 AM
0 Kudos

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

Show replies
Show replies
peter_dzurov
Contributor
‎01-23-2010 10:51 AM
0 Kudos

Please check note:

Note 3155 - Termination due to tablespace overflow

volker_borowski2
Active Contributor
‎01-24-2010 1:43 PM
0 Kudos

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

Former Member
‎01-22-2010 8:58 AM
0 Kudos

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

Show replies
Show replies
Former Member
‎01-23-2010 5:25 AM
0 Kudos

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)

sunny_pahuja2
Active Contributor
‎01-22-2010 6:54 AM
0 Kudos

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

Show replies
Show replies
Ask a Question