Tablespace PSAPTEMP couldn't be extended

[Former Member]

Hi all,

I've a problem with the tablespace "PSAPTEMP". With brtools, it's indicated that this tablespaces is already used up to 100 %. If I want to extend the tablespace, there're shown the current options:

1*last addes file name F:\ORACLE\WSP\SAPDATA3\TEMP_1\TEMP.DATA1

...........

3-new file to be added F:\oracle\WSP\sapdata3\temp_2\temp.data2

Although, a further problem ist that the directories temp_x is available up to temp_6\TEMP.DATA6.

What is the right way to extend the tablespace PSAPTEMP? Why doesn't it work in my database?

Thanks &

Best Regards,

Petra

[Former Member · Accepted solution]

Hi,

Use Oracle Enterprise Manager to extend the tablespace

regards

Umesh K

[Former Member · Accepted solution]

Where can I find the Oracle Enterprise Manager?

More details of our system:

SAP system: SAP R/3 Enterprise

database: ORACLE 9.2.0.5.0

SAP-Version: 610, 620, 630, 640

Best Regards,

Petra

[Former Member · Accepted solution]

why using Oracle Enterprise Manager?

I currently do not know if they have changed something there, but in Oracle9 OEM was not able to create the datafile not the directory structure to it.

brtools will do the complete (directory structure and datafile) job for you!

If extending a tablespace you first have to select the tablespace name.

maybe you are struggeling at the point where you are able to add more than one datafile at a time.

Have a look at the output of my session extending PSAPTEMP (OK it's Oracle10 based, but the 640 brtools should look similar at this point):

regards

Peter

Windows PowerShell
Copyright (C) 2006 Microsoft Corporation. All rights reserved.

PS C:WINDOWSsystem32> brtools
BR0651I BRTOOLS 7.00 (26)

BR0280I BRTOOLS time stamp: 2007-07-04 11.03.27
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2007-07-04 11.03.29
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2007-07-04 11.03.29
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
Database space management

 1 = Extend tablespace
 2 - Create tablespace
 3 - Drop tablespace
 4 - Alter tablespace
 5 - Alter data file
 6 - Move data file
 7 - Additional space functions
 8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2007-07-04 11.03.44
BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2007-07-04 11.03.44
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension

 1 - BRSPACE profile (profile) ...... [initJUO.sap]
 2 - Database user/password (user) .. [/]
 3 ~ Tablespace name (tablespace) ... []
 4 - Confirmation mode (confirm) .... [yes]
 5 - Scrolling line count (scroll) .. [20]
 6 - Message language (language) .... [E]
 7 - BRSPACE command line (command) . [-p initJUO.sap -s 20 -l E -f tsextend]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2007-07-04 11.04.00
BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2007-07-04 11.04.00
BR0681I Enter string value for "tablespace" []:
psaptemp
BR0280I BRTOOLS time stamp: 2007-07-04 11.04.02
BR0683I New value for "tablespace": 'psaptemp'

BR0280I BRTOOLS time stamp: 2007-07-04 11.04.02
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension

 1 - BRSPACE profile (profile) ...... [initJUO.sap]
 2 - Database user/password (user) .. [/]
 3 ~ Tablespace name (tablespace) ... [psaptemp]
 4 - Confirmation mode (confirm) .... [yes]
 5 - Scrolling line count (scroll) .. [20]
 6 - Message language (language) .... [E]
 7 - BRSPACE command line (command) . [-p initJUO.sap -s 20 -l E -f tsextend -t
psaptemp]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2007-07-04 11.04.24
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initJUO.sap -s 20 -l E -f tsex
end -t psaptemp'

BR0280I BRTOOLS time stamp: 2007-07-04 11.04.24
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2007-07-04 11.04.32
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 7.00 (26)
BR1002I Start of BRSPACE processing: sdvpykqi.tse 2007-07-04 11.04.32
BR0484I BRSPACE log file: H:oracleJUOsapreorgsdvpykqi.tse

BR0280I BRSPACE time stamp: 2007-07-04 11.04.33
BR1009I Name of database instance: JUO
BR1010I BRSPACE action ID: sdvpykqi
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2007-07-04 11.04.35
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPTEMP (1. file)

 1 * Last added file name (lastfile) ....... [H:ORACLEJUOSAPDATA2TEMP_1TEM
.DATA1]
 2 * Last added file size in MB (lastsize) . [2000]
 3 - New file to be added (file) ........... [H:oracleJUOsapdata2temp_2tem
.data2]
 4 # Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [2000]
 6 - File autoextend mode (autoextend) ..... [no]
 7 # Maximum file size in MB (maxsize) ..... [10000]
 8 # File increment size in MB (incrsize) .. [20]
 9 - SQL command (command) ................. [alter tablespace PSAPTEMP add tem
file 'H:oracleJUOsapdata2temp_2temp.data2' size 2000M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2007-07-04 11.04.53
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-07-04 11.04.53
BR1091I Next data file can be specified now
BR0675I Do you want to perform this action?
BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]'
to abort:
c
BR0280I BRSPACE time stamp: 2007-07-04 11.05.08
BR0257I Your reply: 'c'
BR0678I The action will be skipped...
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-07-04 11.05.08
BR0370I Directory H:oracleJUOsapreorgsdvpykqi created

BR0280I BRSPACE time stamp: 2007-07-04 11.05.10
BR0319I Control file copy created: H:oracleJUOsapreorgsdvpykqiCNTRLJUO.old
12664832

BR0280I BRSPACE time stamp: 2007-07-04 11.05.10
BR0370I Directory H:oracleJUOsapdata2temp_2 created

BR0280I BRSPACE time stamp: 2007-07-04 11.05.10
BR1088I Extending tablespace PSAPTEMP...

BR0280I BRSPACE time stamp: 2007-07-04 11.05.10
BR1016I SQL statement 'alter tablespace PSAPTEMP add tempfile 'H:oracleJUOsa
data2temp_2temp.data2' size 2000M autoextend off' executed successfully
BR1051I Tablespace PSAPTEMP extended successfully with file: H:oracleJUOsapd
ta2temp_2temp.data2 2000M

BR0280I BRSPACE time stamp: 2007-07-04 11.05.10
BR0340I Switching to next online redo log file for database instance JUO ...
BR0321I Switch to next online redo log file for database instance JUO successfu


BR0280I BRSPACE time stamp: 2007-07-04 11.05.13
BR0319I Control file copy created: H:oracleJUOsapreorgsdvpykqiCNTRLJUO.new
12664832

BR0280I BRSPACE time stamp: 2007-07-04 11.05.13
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2007-07-04 11.05.46
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-07-04 11.05.46
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function 'tsextend' completed

BR1008I End of BRSPACE processing: sdvpykqi.tse 2007-07-04 11.05.46
BR0280I BRSPACE time stamp: 2007-07-04 11.05.48
BR1005I BRSPACE completed successfully

###############################################################################

BR0292I Execution of BRSPACE finished with return code 0
BR0280I BRTOOLS time stamp: 2007-07-04 11.05.48
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:
c
BR0280I BRTOOLS time stamp: 2007-07-04 11.05.51
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2007-07-04 11.05.51
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
Database space management

 1 + Extend tablespace
 2 - Create tablespace
 3 - Drop tablespace
 4 - Alter tablespace
 5 - Alter data file
 6 - Move data file
 7 - Additional space functions
 8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:

[Former Member · Accepted solution]

PS C:WINDOWSsystem32> brtools
BR0651I BRTOOLS 7.00 (26)

BR0280I BRTOOLS time stamp: 2007-07-04 11.20.09
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2007-07-04 11.20.11
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2007-07-04 11.20.11
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
Database space management

 1 = Extend tablespace
 2 - Create tablespace
 3 - Drop tablespace
 4 - Alter tablespace
 5 - Alter data file
 6 - Move data file
 7 - Additional space functions
 8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
5
BR0280I BRTOOLS time stamp: 2007-07-04 11.20.19
BR0663I Your choice: '5'

BR0280I BRTOOLS time stamp: 2007-07-04 11.20.19
BR0657I Input menu 85 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for alter data file

 1 - BRSPACE profile (profile) ....... [initJUO.sap]
 2 - Database user/password (user) ... [/]
 3 ~ Alter data file action (action) . []
 4 ~ Tablespace names (tablespace) ... []
 5 ~ Data file names (file) .......... []
 6 - Confirmation mode (confirm) ..... [yes]
 7 - Scrolling line count (scroll) ... [20]
 8 - Message language (language) ..... [E]
 9 - BRSPACE command line (command) .. [-p initJUO.sap -s 20 -l E -f dfalter]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
5
BR0280I BRTOOLS time stamp: 2007-07-04 11.20.43
BR0663I Your choice: '5'

BR0280I BRTOOLS time stamp: 2007-07-04 11.20.43
BR0681I Enter string value for "file" []:
H:oracleJUOsapdata2temp_1TEMP.DATA1
BR0280I BRTOOLS time stamp: 2007-07-04 11.20.58
BR0683I New value for "file": 'H:oracleJUOsapdata2temp_1TEMP.DATA1'

BR0280I BRTOOLS time stamp: 2007-07-04 11.20.58
BR0657I Input menu 85 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for alter data file

 1 - BRSPACE profile (profile) ....... [initJUO.sap]
 2 - Database user/password (user) ... [/]
 3 ~ Alter data file action (action) . []
 4 ~ Tablespace names (tablespace) ... []
 5 ~ Data file names (file) .......... [H:oracleJUOsapdata2temp_1TEMP.DATA1
]
 6 - Confirmation mode (confirm) ..... [yes]
 7 - Scrolling line count (scroll) ... [20]
 8 - Message language (language) ..... [E]
 9 - BRSPACE command line (command) .. [-p initJUO.sap -s 20 -l E -f dfalter -f
H:oracleJUOsapdata2temp_1TEMP.DATA1]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2007-07-04 11.21.03
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initJUO.sap -s 20 -l E -f dfalt
er -f H:oracleJUOsapdata2temp_1TEMP.DATA1'

BR0280I BRTOOLS time stamp: 2007-07-04 11.21.03
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2007-07-04 11.21.04
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 7.00 (26)
BR1002I Start of BRSPACE processing: sdvpymcm.dfa 2007-07-04 11.21.04
BR0484I BRSPACE log file: H:oracleJUOsapreorgsdvpymcm.dfa

BR0280I BRSPACE time stamp: 2007-07-04 11.21.05
BR1009I Name of database instance: JUO
BR1010I BRSPACE action ID: sdvpymcm
BR1011I BRSPACE function ID: dfa
BR1012I BRSPACE function: dfalter

BR0280I BRSPACE time stamp: 2007-07-04 11.21.05
BR0656I Choice menu 314 - please make a selection
-------------------------------------------------------------------------------
Alter data file main menu

 1 - Set data file online
 2 - Set data file offline
 3 - Turn on and maintain autoextend
 4 - Turn off autoextend
 5 - Resize data file
 6 - Rename data file
 7 - Drop empty data file
 8 - Show data files
 9 - Show tablespaces
10 - Show disk volumes
11 * Exit program
12 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
5
BR0280I BRSPACE time stamp: 2007-07-04 11.21.10
BR0663I Your choice: '5'

BR0280I BRSPACE time stamp: 2007-07-04 11.21.11
BR0657I Input menu 316 - please check/enter input values
-------------------------------------------------------------------------------
Options for alter of data file H:ORACLEJUOSAPDATA2TEMP_1TEMP.DATA1

 1 * Current data file status (status) ....... [AUTOEXTEND]
 2 * Current data file size in MB (currsize) . [2000]
 3 * Alter data file action (action) ......... [resize]
 4 # Maximum file size in MB (maxsize) ....... [10000]
 5 # File increment size in MB (incrsize) .... [20]
 6 ? New data file size in MB (size) ......... []
 7 # New data file name (name) ............... []
 8 # Force data file alter (force) ........... [no]
 9 - SQL command (command) ................... [alter database tempfile 'H:ORAC
LEJUOSAPDATA2TEMP_1TEMP.DATA1' resize M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
6
BR0280I BRSPACE time stamp: 2007-07-04 11.21.17
BR0663I Your choice: '6'

BR0280I BRSPACE time stamp: 2007-07-04 11.21.17
BR0682I Enter integer value for "size" (1-32767) []:
3000
BR0280I BRSPACE time stamp: 2007-07-04 11.21.23
BR0683I New value for "size": '3000'

BR0280I BRSPACE time stamp: 2007-07-04 11.21.23
BR0657I Input menu 316 - please check/enter input values
-------------------------------------------------------------------------------
Options for alter of data file H:ORACLEJUOSAPDATA2TEMP_1TEMP.DATA1

 1 * Current data file status (status) ....... [AUTOEXTEND]
 2 * Current data file size in MB (currsize) . [2000]
 3 * Alter data file action (action) ......... [resize]
 4 # Maximum file size in MB (maxsize) ....... [10000]
 5 # File increment size in MB (incrsize) .... [20]
 6 - New data file size in MB (size) ......... [3000]
 7 # New data file name (name) ............... []
 8 # Force data file alter (force) ........... [no]
 9 - SQL command (command) ................... [alter database tempfile 'H:ORAC
LEJUOSAPDATA2TEMP_1TEMP.DATA1' resize 3000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2007-07-04 11.21.28
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1049W Not enough free space in H:ORACLEJUOSAPDATA1 for total maximum size o
f all database files of tablespace PSAPSR3 located on this disk volume, missing
at least 53497.781 MB
BR1049W Not enough free space in H:ORACLEJUOSAPDATA1 for total maximum size o
f all database files of tablespace PSAPSR3700 located on this disk volume, missi
ng at least 15377.781 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back
 to repeat the last action
BR0280I BRSPACE time stamp: 2007-07-04 11.21.28
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2007-07-04 11.22.47
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-07-04 11.22.47
BR0370I Directory H:oracleJUOsapreorgsdvpymcm created

BR0280I BRSPACE time stamp: 2007-07-04 11.22.49
BR0319I Control file copy created: H:oracleJUOsapreorgsdvpymcmCNTRLJUO.old
12664832

BR0280I BRSPACE time stamp: 2007-07-04 11.22.49
BR1016I SQL statement 'alter database tempfile 'H:ORACLEJUOSAPDATA2TEMP_1TE
MP.DATA1' resize 3000M' executed successfully
BR1079I The size of data file H:ORACLEJUOSAPDATA2TEMP_1TEMP.DATA1 altered s
uccessfully from 2000 MB to 3000 MB

BR0280I BRSPACE time stamp: 2007-07-04 11.22.49
BR0340I Switching to next online redo log file for database instance JUO ...
BR0321I Switch to next online redo log file for database instance JUO successful


BR0280I BRSPACE time stamp: 2007-07-04 11.22.50
BR0319I Control file copy created: H:oracleJUOsapreorgsdvpymcmCNTRLJUO.new
12664832

BR0280I BRSPACE time stamp: 2007-07-04 11.22.50
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:
c
BR0280I BRSPACE time stamp: 2007-07-04 11.22.57
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-07-04 11.22.57
BR0656I Choice menu 314 - please make a selection
-------------------------------------------------------------------------------
Alter data file main menu

 1 - Set data file online
 2 - Set data file offline
 3 - Turn on and maintain autoextend
 4 - Turn off autoextend
 5 + Resize data file
 6 - Rename data file
 7 - Drop empty data file
 8 - Show data files
 9 - Show tablespaces
10 - Show disk volumes
11 = Exit program
12 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:

[Former Member · Accepted solution]

Hi,

Sorry Peter, I totaly disagree with you, We can add datafiles according to SAP Directory Structure Itself, Oracle 9I we can use OEM and for 8I we can use DBA studio for creating all you need is patience for what u do

Regards

Umesh K

[Former Member · Accepted solution]

Hi Peter,

thank you very much for your further support.

After entering the tablespace "PSAPTEMP" and at step 5 - "Size of the new file in MB", the process cancelled with the following message:

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2007-07-04 13.09.50

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1052E File F:\oracle\WSP\sapdata3\temp_2\temp.data2 is already used by the dat

abase

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last action

BR0280I BRSPACE time stamp: 2007-07-04 13.09.50

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Best Regards,

Petra

[Former Member · Accepted solution]

I did not test it for a while therefore I was a little unsure if the problem is stil existing, but it does even in Oracle10 OEM:

generated statement by OEM:

ALTER TABLESPACE "PSAPSR3700" ADD DATAFILE 'H:\oracle\JUO\nonexistingdirectory\test.data1' SIZE 2375680K REUSE AUTOEXTEND ON NEXT 20480K MAXSIZE 10000M;

Failed to commit: ORA-01119: error in creating database file 'H:\oracle\JUO\nonexistingdirectory\test.data1' ORA-27040: file create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 3) The system cannot find the path specified.

That's what I said: OEM will not create the directory.

br*tools can handle a maximum of 1 datafile per directory.

OEM is not able to create directories -at least on windows- for new datafiles, this is very stupid.

regards

Peter

[Former Member · Accepted solution]

first of all, check wether you are using actual br*tools.

second, brtools will normaly automatically generate a filename and directory name for newly creating datafiles. Did brtools calculate the filename or did you specify it manually?

creating a new file needs a new and empty directory for it's destination.

the alternativ is to extend an existing one.

regards

Peter

[Former Member · Accepted solution]

Hi Peter,

our actual version of the br*tools at this system is 6.40 (11).

The problem is, that the other files are created automatically by brtools. But with the tablespace "PSAPTEMP", it doesn't work.

1 * Last added file name (lastfile) ....... [F:\ORACLE\WSP\SAPDATA3\TEMP_1\TEMP

.DATA1]

2 * Last added file size in MB (lastsize) . [540]

3 - New file to be added (file) ........... [F:\oracle\WSP\sapdata3\temp_2\temp

.data2]

4 # Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [540]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... [10000]

8 # File increment size in MB (incrsize) .. [20]

9 - SQL command (command) ................. [alter tablespace PSAPTEMP add temp

file 'F:\oracle\WSP\sapdata3\temp_2\temp.data2' size 540M autoextend off]

The problem is "3 - New file to be added (file) ........... [F:\oracle\WSP\sapdata3\temp_2\temp.data2]". This datafile already exists. In our system, there are actually tempfiles up to F:\oracle\WSP\sapdata3\temp_6\TEMP.DATA6.

There's something amiss with the step" 1 * Last added file name (lastfile) ....... [F:\ORACLE\WSP\SAPDATA3\TEMP_1\TEMP.DATA1]" . Because the actual last added file name ist TEMP.DATA6.

Regards,

Petra

[Former Member · Accepted solution]

your used version (11) is quite old.

current version on service market place is 43.

try this one, if this behaves in the same way it is time to file a bug.

regards

Peter

[former_member204746 · Accepted solution]

check timestamp on file F:\oracle\WSP\sapdata3\temp_2\temp.data2

I would think that PSAPTEMP was change to temporary tablesapce a few months back.

F:\oracle\WSP\sapdata3\temp_2\temp.data2 is probably a leftover from old layout. if timestamp is old, delete the fiel at OS level and try again.

[Former Member · Accepted solution]

Hello Herr Simon,

you often gave us a very helpful support on SDN.

The described problem just occurs at 2 systems.

This two systems act extreme slowly at the login via sap-logon. And on opening a new session, the process aborts at times.

The only conspicuity, is the problem with the tablespace PSAPTEMP. These are busy up to 100 percent. But it isn't possible to extend them with BRTools.

A further risk is, that the one of the affected systems is our productive system.

But here I want to interpellate you, if you could give us support via PCAnywhere or locally at this current problem. As best I can review your support, I'm sure, that you could help us to solve this problem.

That I can clarify with our manager, I should know, how much you demand for such a support per hour.

Hoping for an early and positive answer.

Best Regards,

Petra Wiedemann (pwi@wsw.de]

[Former Member · Accepted solution]

Hello Petra,

sorry, but for the same reason why advertising is not allowed in this forum we do not accept service requests via this forum.

please use the official support channels (http://service.sap.com) if you can not get an appropriate answer to your questions here or if they do not solve your problem.

thank you for understanding.

regards

Peter

[fidel_vales · Accepted solution]

Hi,

Perhaps you can provide the following information

1) Is PSAPTEMP Locally managed or dictionary Managed?

2) How many datafiles/tempfiles PSAPTEMP has?

You can answer this two questions looking at DB02 or looking at SQLPLUS:

select CONTENTS, EXTENT_MANAGEMENT from DBA_TABLESPACES

where TABLESPACE_NAME='PSAPTEMP';

If the content is PERMANENT then you have to query DBA_DATAFILES for the number of datafiles: If the content is TEMPORARY then you have to query DBA_TEMP_FILES:

select FILE_NAME from DBA_DATA_FILES

where TABLESPACE_NAME ='PSAPTEMP

order by FILE_NAME;

or

select FILE_NAME from DBA_TEMP_FILES

where TABLESPACE_NAME ='PSAPTEMP'

order by FILE_NAME;

Then you can see if Eric is correct and the file

F:\oracle\WSP\sapdata3\temp_2\temp.data2

( and maybe others )is a leftover.

If so, delete it at OS and try again.

Fidel

[Former Member · Accepted solution]

Hello Fidel,

the output of the query <i>select CONTENTS, EXTENT_MANAGEMENT from DBA_TABLESPACES where TABLESPACE_NAME='PSAPTEMP';</i> is the following:

CONTENTS EXTENT_MAN

-

---

-

---

TEMPORARY LOCAL

And the result of <i>SQL> select FILE_NAME from DBA_TEMP_FILES where TABLESPACE_NAME='PSAPTEMP' order by FILE_NAME;</i> is the following:

FILE_NAME

-

---

F:\ORACLE\WSP\SAPDATA3\TEMP_1\TEMP.DATA1

F:\ORACLE\WSP\SAPDATA3\TEMP_2\TEMP.DATA2

F:\ORACLE\WSP\SAPDATA3\TEMP_3\TEMP.DATA3

F:\ORACLE\WSP\SAPDATA3\TEMP_4\TEMP.DATA4

F:\ORACLE\WSP\SAPDATA3\TEMP_5\TEMP.DATA5

F:\ORACLE\WSP\SAPDATA3\TEMP_6\TEMP.DATA6

6 rows selected.

Best regards,

Petra

[fidel_vales · Accepted solution]

Hi,

then the file proposed by BRSPACE already exists.

You should try with the latest BR* version and if it does not work, keep the log files and open an message in SAP.

Perhaps the files 2-6 were not added with BRSPACE but externally.

Knowing the last file added, then you can tell BRSPACE to add a different one.

For example, BRSPACE shows you this:

Options for extension of tablespace PSAPTEMP (1. file)

1 * Last added file name (lastfile) ....... [<b>F:\ORACLE\WSP\SAPDATA3\TEMP_1\TEMP.DATA1</b>]

2 * Last added file size in MB (lastsize) . [2000]

3 - New file to be added (file) ........... [<b>F:\oracle\WSP\sapdata3\temp_2\temp.data2</b>]

4 # Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [2000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... [10000]

8 # File increment size in MB (incrsize) .. [20]

9 - SQL command (command) ................. [alter tablespace PSAPTEMP add tem

file <b>'F:\oracle\WSP\sapdata3\temp_2\temp.data2'</b> size 2000M autoextend off]

Then choose the option 3 and change it to ( for example )

3 - New file to be added (file) ........... [<b>F:\oracle\WSP\sapdata3\temp_7\temp.data7</b>]