upgrade from ecc5 to ecc6 old data like PRD640_1 is still there

[Former Member]

Dear All,

we have resent upgrade from ecc5 to ecc6 and i have some quires regarding the datafile.

In sapdata1 -4 i see all old data like PRD640_1 i still there .Please suggest it is ok or it should not be there in the sapdata.

in db02 tablespace

PSAPEL701D

PSAPEL701I

PSAPPRD

PSAPPRD640

PSAPPRD701

PSAPPRDUSR

PSAPTEMP

PSAPUNDO

PSAPUNDO2

SYSAUX

SYSTEM

There is once more thing when i am extend the table from brtools for

BR*Tools main menu 2 - Space management 1 = Extend tablespace 3 ~ Tablespace name (tablespace) ... []

1 - BRSPACE profile (profile) ...... [initPRD.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPPRDUSR]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initPRD.sap -s 20 -l E -f tsextend -t

PSAPPRDUSR]

c

c

Options for extension of tablespace PSAPPRDUSR (1. file)

1 * Last added file name (lastfile) ....... [L:\ORACLE\PRD\SAPDATA4\PRDUSR_4\PR

DUSR.DATA4]

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

3 - New file to be added (file) ........... [L:\oracle\PRD\sapdata4\prdusr_5\pr

dusr.data5]

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

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

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

7 - Maximum file size in MB (maxsize) ..... [500]

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

9 - SQL command (command) ................. [alter tablespace PSAPPRDUSR add da

tafile 'L:\oracle\PRD\sapdata4\prdusr_5\prdusr.data5' size 460M autoextend on ne

xt 20M maxsize 500M]

BR0259I Program execution will be continued...

BR1049W Not enough free space in L:\oracle\PRD\sapdata4\prdusr_5 for total maxim

um size of all database files of tablespace PSAPPRD located on this disk volume,

missing at least 741702.647 MB

BR1049W Not enough free space in L:\oracle\PRD\sapdata4\prdusr_5 for total maxim

um size of all database files of tablespace PSAPPRD640 located on this disk volu

me, missing at least 137942.647 MB

BR1049W Not enough free space in L:\oracle\PRD\sapdata4\prdusr_5 for total maxim

um size of all database files of tablespace PSAPPRDUSR located on this disk volu

me, missing at least 13522.647 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

Please suggest what is right configuration and how to sol ther error in brtools.

Regards,

Kumar

[Former Member]

Hi,

Check in DB02 the size of old tablespace, it should be used ZERO.

Then go to BRtools & DROP it.

BR,

Darshan

[Former Member]

Hi,

the size of old tablespace is not 0 and it is of 50 gb .Please what to do.

and the while extend the tablesapce how to remove the old tablespace.

Please suggest.

Regards

Kumar

[Former Member]

Hi,

Go to DB02old what is the free(kb) for this tablespace ?

Mark

[Former Member]

HI,

The size for tablespace would be 50 GB. But the used must 0%. This tablespace will not be used. So you can go ahead and drop it using BRTOOLS. You might have to select the force option while dropping through BRTOOLS

The 2nd warning that you are getting can be ignored. It is about the space available according to size of all tablespaces. You can ignore and add datafile to tablsespace. But makse sure to always keep some space as buffer on your server.

Regards,

Tajinder

[Former Member]

Dear All,

Thanks for your suggestions . i have another queries regarding Tablespace name in ecc6.

Please suggest it is ok

Tablespace name

PSAPEL701D

PSAPEL701I

PSAPPRD

PSAPPRD640

PSAPPRD701

PSAPPRDUSR

PSAPTEMP

PSAPUNDO

PSAPUNDO2

SYSAUX

SYSTEM

Regards,

Kumar

[tomas_black]

Hello Kumar9,

if I understoon correctly your last reply, you have doubts if PSAPPRD640 should exist at all, correct?

Please do the following:

1) Check any object assigned to this tablespace PSAPPRD640

2) If any object occupied to PSAPPRD640 then reorganise to new tablespace

If any object not occupied to PSAPPRD640 then check the table entry

a)TAORA for tablespace PSAPPRD640(if exist delete)

b)IAORA for tablespace PSAPPRD640(if exist delete)

3) If above done then drop the tablespace through BRTools.

Best regards,

Tomas Black

[Former Member]

Dear Tomas Black,

Thanks ,yes i want to know the same . Please suggest the step how check the below

1) Check any object assigned to this tablespace PSAPPRD640

2) If any object occupied to PSAPPRD640 then reorganise to new tablespace

and i have check table TAORA & IAORA for tablespace PSAPPRD640 exist.

Please suggest.

Thanks a lot

Regards,

Kumar

[tomas_black]

Hello Kumar,

for task #1:

select name from dba_segments where tablespace = 'PSAPPRD640';

(from sqlplus, connected to the database. Ask your DBA for help if needed)

for task #2:

please use BRSPACE tool in order to perform the reorg of the database. Please check note #646681.

Best regards,

Tomas Black

[Former Member]

Dear Tomas Black,

I am getting below error when i am running the command

for task #1:

select name from dba_segments where tablespace = u2018PSAPPRD640u2019;

ERROR at line 1:

ORA-00904: "TABLESPACE": invalid identifier

Please suggest.

Regards

Kumar

[tomas_black]

Hello Kumar,

sorry, the correct syntax is:

u201Cselect name from dba_segments where tablespace_name = u2018PSAPPRD640u2019;u201D

(in order to make sure the field name is correct, please issue command u201Cdesc dba_segmentsu201D and then check if it's tablespace_name)

Best regards,

Tomas Black

[Former Member]

Hi,

By the looks of it you have also applied Enhancment Packs too..?

In the upgrade guide in the post upgrade stuff it should mention that the old tablespace names are now redundant and can be deleted. Dropping the old tables will clean up your old data files.

Please read the guide for confirmation.

Mark

[Former Member]

Hi,

Thanks and what about the error in Britons.

Regards,

[Former Member]

Hi Kumar,

Once you finished the upgrade, it is necessary to delete the old version tablespaces using Brtools. You can get sufficient amount of free space once you delete them. you can extend new tablespaces with the available free space.

Thanks and Regards

Purna

[Former Member]

Thanks all as i have told you that we have upgraded from ecc5 to ecc6.

i have some queries

1 i an extend the tablespace PSAPPRD but why the tablespace PSAPPRD640 is comming.

2 if i want to alter tablespace by oracle than the command is

alter tablespace PSAPPRD add datafile

'L:\oracle\DEV\sapdata4\prd_95\prd.data95' size 2000M autoextend on next 20M

maxsize 6000M

Please suggest.

Regards,

Kumar