Many ORA-00955 during upgrade to Oracle 11G

[Former Member]

Dear Community,

I upgraded my SAP EHP4 fro NW 7.01 system to Oracle 11.2.0.4 (BuldlePatch 228396008 and required generic Patches).

During the uprade of Oracle Server appeared many ORA-00955 on the system.LOGMNR_*  tables.

I didn't find no notes to describe the problem.

Someone of you have had the same problem?

I think that it dependes from the bundle Patches installed on the Oracle 11g software.

Thanks, Pietro Ragonesi

Oracle_Server_extract.txt.zip

[Former Member]

Hi Gaurav,

thank for your reply, I think that the problem isn't a problem, excuse me for beating around the bush.

The log file show a comment on the top of create tables's attempt:

Rem Create partitioned Logminer tables if they do not yet  exist

These kind of tables are used only to investicate the redo log file and on my system I have actived this feature.

Is it a fake problem?

Regards.

[former_member182657]

Hi,

CREATE TABLE SYSTEM.LOGMNR_DICTSTATE$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

Have you checked SAP KBA  1233860 - ORA-00955 "Name is already used by existing object"

with resolution suggested

Oracle related issue:
- flush the sharedpool with SQL>alter system flush shared_pool,
- restart the database to clear out the rowcache.

Regards,