utlu102i.sql - exact fetch returns more than requested no of rows error

[Former Member]

I am doing an oracle upgrade from 9.2.0.2 to oracle 10g in hpux11.31 here.

As a pre steps we need to run the enclosed script. While running the script as sysdba, I am getting the below error message.

Can u help me to figure this out?

*

kdecc03:orats3 68> sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Oct 27 10:26:04 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

SQL> pwd

SP2-0042: unknown command "pwd" - rest of line ignored.

SQL> spool preupgrade.sql

SQL> @/install/819830/SAP/utlu102i.sql

DECLARE

*

ERROR at line 1:

ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at line 2597

*

Regards

Senthil

[Former Member]

After configuring AUM in oracle9i and restarting database, the issue got resolved.

Thank u all for replying

[markus_doehr2]

> I am doing an oracle upgrade from 9.2.0.2 to oracle 10g in hpux11.31 here.

Oracle Upgrade guide chapter 2.1:

If the source database runs Oracle 9.2.0.3, 9.2.0.2, or 9.2.0.1, 
you need to update the source database to patch set 9.2.0.4 or later. 
The DBUA checks for the source release of the Oracle 9.2 database. 
If the source database runs on a lower version than Oracle 9.2.0.4 you cannot proceed.

I know, I told you before to upgrade to 10g instead of 9.2.0.4 which you initially intended.

I would install 9.2.0.8 and do the upgrade to 10g from that version.

Markus

[Former Member]

Markus,

Thank u for ur reply.

The reason we are going from 9.2.0.2 to 9.2.0.4 is our customer is currently running on 9.2.0.4

We are replicating the same environment and doing a trial upgrade.

The tasks is to upgrade from oracle 9.2.0.2 to 9.2.0.4 (which I completed yesterday).

Now I want to upgrade from 9.2.0.4 to Oracle 10g.

So while running the utlu102i.sql script, on the oracle 9.2.0.4 system, I get the error message.

kdecc03 rats3 87> cat pre_upgrade.log

SQL> @/install/819830/SAP/utlu102i.sql

DECLARE

*

ERROR at line 1:

ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at line 2597

SQL> exit

Does that mean there is an error in the script?

I can very well understand that going from 9.2.0.2 to 9.2.0.8 is the best way. But our customer need is this.

Can you please help to over come the above error

Thanks

[markus_doehr2]

> SQL> @/install/819830/SAP/utlu102i.sql

> DECLARE

> *

> ERROR at line 1:

> ORA-01422: exact fetch returns more than requested number of rows

> ORA-06512: at line 2597

> Does that mean there is an error in the script?

I can't help you with that specific error, sorry.

> I can very well understand that going from 9.2.0.2 to 9.2.0.8 is the best way. But our customer need is this.

You may upgrade from 9.2.0.4 to 9.2.0.8 first and then try the upgrade. That's a well tested path.

Markus

[lbreddemann]

> kdecc03 rats3 87> cat pre_upgrade.log

> SQL> @/install/819830/SAP/utlu102i.sql

> DECLARE

> *

> ERROR at line 1:

> ORA-01422: exact fetch returns more than requested number of rows

> ORA-06512: at line 2597

Please do check whether table DUAL still only contains just one row.

If this is not the case anymore, than errors like these may occur.

select rowid,* from dual;

If there is more than one row in the table, get rid of the superfluos rows with the following statement

DELETE FROM DUAL WHERE ROWID != (SELECT MIN(ROWID) FROM DUAL);
COMMIT;

regards,

LArs