oracle upgrade SYSTEM tablespace error

[Former Member]

Hello,

I am upgrading using DBUA tool from oracle 9i to 10g and it is asking for system table size as

1152918749999950666 MB??

THIS IS SHOCKING .............PLEASE HELP ASAP

I have lready allocated 14GB to it ............what to do?? is it some bug on itanium2 server 64 bit windows

as per note 948305 issue is

3 Problems with the upgrade to 10.2

12/May/06

Set the attribute AUTOEXTEND for one or more datafiles of tablespace

SYSTEM and tablespace SYSAUX, as the Oracle database server might not

correctly calculate the required free space. Perform this step before

you perform the preparation step "Migrating to Automatic Undo

Management " in the Windows upgrade guide (Version 1.0) for Oracle 10

Release 2 (10.2).

This step is included in the upgrade guide as of version 2.0.

but UNDO MGT was already set in system. There is no rollback tabelsapce too as it was ECC 5

PLEASE HELP

Regards

Ankita

[Former Member · Accepted solution]

In my understanding the key is this:

Set the attribute AUTOEXTEND for one or more datafiles of tablespace
SYSTEM and tablespace SYSAUX

And I don't see any reason why it shouldn't help if you do it now, even after UNDO MGT was already set in system.

regards

[Former Member · Accepted solution]

Hello,

I have already set autoextend on for SYSTEM tablespace still getting below error.

ORA02494 invalid or missing maximum file size in MAXSIZE clause

Now what should i set in maxsize clause?

Regards,

Ankita

[Former Member · Accepted solution]

It seems you have got a syntax error in your sql statement, I suppose you left out the value for the maximal size.

I would try something like this in sqlplus:

alter database datafile '/oracle/<SID>/sapdata1/system_1/system.data1' autoextend on maxsize 10240m

Or perhaps this:

alter database datafile '/oracle/<SID>/sapdata1/system_1/system.data1' autoextend on maxsize unlimited

(of course substitute your path of a datafile.)

hope this helps

[Former Member · Accepted solution]

Hi,

I have already executed this still the same error.

Given cmd -

Alter database datafile u2018L:\oracle\DEV\sapdata1\SYSTEM_1\SYSTEM.DATA1u2019

Autoextend on next 1m maxsize unlimited;

Still getting the same error on running DBUA -

ORA-02494 invalid or missing maximum file size in MAXSIZE clause

Now what should i do?

Regards,

Ankita.

[Former Member · Accepted solution]

Not sure if I correctly understood your problem.

So the error ORA02494 is from DBUA?

And did your given command in sqlplus run without error?

And did you do the same switch for a file of tablespace SYSAUX?