Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Pre upgrade script fails

Subbu ADec 20 2019 — edited Dec 22 2019

Hi All

I am trying to upgrade my 11.2.0.3 standalone database 12.1.0.2.0, while running preupgrade.sql script facing below error:

Anyone faced this issue?

SQL> @/user1/oracle/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/preupgrd.sql

Loading Pre-Upgrade Package...

DECLARE

*

ERROR at line 1:

ORA-00955: name is already used by an existing object

ORA-06512: at "SYS.DBMS_PREUP", line 4001

ORA-06512: at "SYS.DBMS_PREUP", line 3189

ORA-06512: at "SYS.DBMS_PREUP", line 3159

ORA-06512: at line 56

***************************************************************************

Pre-Upgrade Checks in <****> Completed.

***************************************************************************

***************************************************************************

*****************************************************

This post has been answered by Venkata Thiruveedhi-Oracle on Dec 20 2019
Jump to Answer

Comments

Venkata Thiruveedhi-Oracle
Answer

Hi,

Check if there are any hidden parameters in pfile/spfile.

If yes, remove them, restart the database.

Then attempt the Upgrade.

Best Regards,

Venkat

Marked as Answer by Subbu A · Sep 27 2020
Subbu A

Hi Venkat

Thanks much, as per your suggestion after disabling the below parameters  i can able to run preupgrade script.

#*.nls_comp='LINGUISTIC'

#*.nls_sort='BINARY_CI'

Thanks

Subbu

1 - 2

Post Details

Added on Dec 20 2019
2 comments
200 views